Lead Data Engineer – Financial Data, Compliance & Business Intelligence

Crowe•Washington, DC

About The Position

Your Journey at Crowe Starts Here: At Crowe, you can build a meaningful and rewarding career. With real flexibility to balance work with life moments, you’re trusted to deliver results and make an impact. We embrace you for who you are, care for your well-being, and nurture your career. Everyone has equitable access to opportunities for career growth and leadership. Over our 80-year history, delivering excellent service through innovation has been a core part of our DNA across our audit, tax, and consulting groups. That’s why we continuously invest in innovative ideas, such as AI-enabled insights and technology-powered solutions, to enhance our services. Join us at Crowe and embark on a career where you can help shape the future of our industry. Job Description: We 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, as well as 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 provide meaningful firm-wide contributions that uphold the team’s dedication to “One Crowe”. We strive for an unparalleled client experience and look to you to promote our success. Additionally, you will work as part of a team of problem solvers with extensive consulting and industry experience, helping our clients solve their complex business issues from strategy to execution. Specific responsibilities include but are not limited to: 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

Requirements

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 as well as expert knowledge of both Agile and traditional project management principles and practices and the ability to blend them together in the right proportions to fit a project and business environment
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
Effectively managing multiple deliverables, clients and projects in a fast-paced environment
Strong problem solving and analytical skills

Nice To Haves

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

Responsibilities

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