Lead Data Engineer – Financial Data, Compliance & Business Intelligence

Crowe LLP10 months ago
Los Angeles, CA, United States
Hybrid
Full-time
Junior Level (1-3 years)

Job Description

Position Overview

At Crowe, you’ll embark on a meaningful career where flexibility, innovation, and integrity thrive. Join our Data Engineering team as an experienced ETL Engineer and help design, develop, and maintain ETL pipelines that extract, transform, and load data into our data warehouse. Work alongside a team of problem solvers committed to excellence and supporting one another under our core values of Care, Trust, Courage, and Stewardship.

Key Responsibilities

  • Identify and map source data in various commercial and custom systems.
  • Design, develop, test, and maintain ETL pipelines.
  • Extract, transform, and load data from various data sources.
  • Collaborate with data engineers and stakeholders to define data requirements.
  • Troubleshoot and debug ETL processes.
  • Stay up-to-date on ETL technologies and best practices.
  • Formulate development estimates including tasks, effort, and dependencies.
  • Develop test cases and demonstrate results for assigned deliverables.
  • Maintain and present daily/weekly status reports.
  • Clearly articulate project deliverable details to both clients and team members.
  • Adapt quickly to various industries and translate business requirements into development plans.
  • Maintain a professional presence during client interactions.

Required Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • Minimum of 3 years of experience in ETL development.
  • Hands-on experience with compliance frameworks such as Bank Secrecy Act (BSA) and Anti-Money Laundering (AML) regulations.
  • Previous consulting experience or experience working with external clients.
  • Strong understanding of ETL processes and technologies.
  • Experience with diverse data sources including relational databases, flat files, and web APIs.
  • Proficiency in Python, Java, or another programming language.
  • Familiarity with data warehouse technologies such as Azure, AWS, and Snowflake.
  • Excellent problem-solving, debugging, and communication skills.
  • In-depth knowledge of software development life cycle models, Agile, and traditional project management principles.
  • Experience with enterprise solutions and BI architecture or data warehousing.
  • Ability to manage multiple deliverables, clients, and projects concurrently in a fast-paced environment.

Preferred Qualifications

  • Certifications in BI tools, visualization tools, or cloud architectures.
  • Certifications such as CAMS (Certified Anti-Money Laundering Specialist) or CFE (Certified Fraud Examiner).

Benefits & Perks

  • Compensation: $104,500.00 - $208,300.00 per year
  • Comprehensive total rewards package designed with your well-being in mind.
  • An inclusive culture that offers continuous growth and guidance through Career Coach support.
  • Opportunities to work with innovative technologies and contribute firm-wide.

Required Skills

Agile Methodologies
ETL Development
Snowflake
Python
ETL Pipeline Design
Azure
Data Warehousing
Debugging
Consulting
Java
Project Management
AWS
SQL
BI Architecture
Data Engineering