Identify & 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, language, and jargon to clearly document and translate business requirements to development plans
Maintain a professional presence and be ready to interact with the client at all times

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 software development life cycle models and expert knowledge of both Agile and traditional project management principles
Technical background, with understanding or hands-on experience in enterprise solutions for different industries
High-level knowledge of BI architecture or data warehousing

Lead Data Engineer – Financial Data, Compliance, Business Intelligence

Key skills