Lead Data Engineer – Financial Data, Compliance & Business Intelligence

Overview

Lead Data Engineer – Financial Data, Compliance & Business Intelligence  are looking for an experienced ETL Engineer to join our Data Engineering team. The ideal candidate will have a strong understanding of ETL processes and technologies, and experience with a variety of data sources. The ETL developer will be responsible for designing, developing, and maintaining ETL pipelines that extract, transform, and load data into our data warehouse.

As a member of the Data Analytics team, you will contribute to firm-wide projects and uphold the team’s dedication to delivering value to clients.

• Identify and map source data in various commercial and custom systems
• Design, develop, test and maintain ETL pipelines
• Extract, transform, and load data from a variety of data sources
• Work with data engineers and other stakeholders to define data requirements
• Troubleshoot and debug ETL pipelines
• Stay up-to-date on ETL technologies and best practices
• Formulate development estimates (task, effort, dependencies, etc.)
• Develop test cases and demonstrate results for assigned deliverables
• Maintain and present daily/weekly status
• Articulate project deliverable details and activities to client and project team members
• Adapt to various industries and quickly learn the client’s context to document and translate business requirements to development plans
• Interact professionally with clients as needed

• Bachelor's degree in computer science, information technology, or a related field
• 3+ years of experience in ETL development
• Hands-on experience with Bank Secrecy Act (BSA), Financial Audits, or Anti-Money Laundering (AML) regulations and compliance requirements
• Previous consulting experience or experience working with external clients
• Strong understanding of ETL processes and technologies
• Experience with a variety of data sources, including relational databases, flat files, and web APIs
• Experience with Python, Java, or another programming language
• Experience with data warehouse technologies, such as Azure, AWS, and Snowflake
• Excellent problem-solving and debugging skills
• Strong communication and teamwork skills
• Solid understanding of SDLC models and ability to blend Agile and traditional project management practices
• Technical background with understanding or hands-on experience in enterprise solutions for different industries
• High-level knowledge of BI architecture or data warehousing
• Excellent written and verbal communication skills
• Ability to manage multiple deliverables, clients and projects in a fast-paced environment
• Strong analytical and problem-solving skills

• Certifications in BI (ETL tools, visualization tools, cloud architectures)
• CAMS (Certified Anti-Money Laundering Specialist), CFE (Certified Fraud Examiner) or similar certifications

• Internal:
  Senior BI Analyst, Data Product Manager, BI Architect / Senior Architect, Data Engineers, Report Developer (Power BI, Tableau)
• External: C-Suite executives, data owners, data stewards, Enterprise Information Management and Data Governance teams, IT staff – Architects, DBAs, Developers

The wage range is $104,500 - $208,300 per year, with factors including skill sets, experience, training, licensure and certifications, and business needs.

Crowe offers a comprehensive total rewards package. Learn more about what working at Crowe can mean for you.

We nurture talent in an inclusive culture that values diversity. You will have opportunities for career growth and leadership, with support from a Career Coach to guide your goals.

Crowe () is one of the largest public accounting, consulting and technology firms in the United States. Crowe provides audit, tax, advisory, risk and performance services to clients worldwide and is a member of Crowe Global, a network spanning more than 130 countries. Crowe is an equal opportunity employer and prohibits discrimination and harassment of any type. Crowe will consider qualified applicants with criminal histories in a manner consistent with applicable laws.

We do not sponsor work visas at this time.

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States upon hire.