Data Engineer II

1. About Our Client: The organization operates in the financial services industry, focusing on integrated risk management and compliance solutions. It serves over 5,000 financial institutions across the United States. The company addresses challenges related to risk and compliance by providing tools and expert guidance to help financial institutions make informed decisions and mitigate risks effectively.

2. About the Opportunity: The Data Engineer II role is an individual contributor position responsible for developing and maintaining ETL pipelines, data warehouses, and data models. This role supports the organization’s ability to analyze and utilize data from various products, ensuring data accuracy, performance, and scalability. The position involves collaboration with cross-functional teams and contributes to continuous improvement of the data architecture.

3. Responsibilities:

• Build and enhance ETL pipelines incorporating data from all products
• Write efficient, maintainable code using modern tools and AI agents
• Ensure quality and reliability of ETL processes
• Define data models and develop reports within the analytics platform
• Collaborate with data team members and other functional areas
• Promote best practices and continuous improvement initiatives
• Participate in architecting scalable data platforms
• Mentor less experienced team members

4. Requirements:

• Minimum 3 years experience as a Data Engineer in enterprise environments
• Proficient with dbt
• At least 3 years experience with Azure Data Factory, Snowflake, or AWS Redshift
• Strong expertise in MS SQL Server
• Experience with data architecture across various database types and formats
• Skilled in building data pipelines for data cleaning, enrichment, and transformation
• Python experience is highly desirable
• Knowledge of database design and tuning
• Familiarity with version control systems (Azure DevOps, Git) and CI/CD concepts

5. Preferred Skills:

• Experience in horizontally scaling systems
• Experience with Claude Code for ETL and data modeling
• Experience creating reports and dashboards using modern analytics platforms
• Exposure to Microsoft Fabric or other cloud data stacks
• Understanding of message/event-driven and distributed systems architectures
• Experience with systems integration

6. Pay Range and Compensation Package:

The pay range and compensation package for this role will be determined based on the candidate’s experience, skills, and other relevant factors.

7. Benefits & Perks:

• Paid time off plan compliant with medical and family leave laws
• 11 paid holidays
• Mental health benefits
• Medical, dental, and vision insurance
• Company-paid group life insurance, short- and long-term disability
• Flexible spending and health savings accounts
• Supplemental Aflac benefits (critical illness, cancer protection, hospital choice)
• Pet insurance
• 401(k) with company match, eligibility from first day
• Paid volunteer time off
• Community and social events

8. Equal Opportunity Statement: Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin.

Note: TalentHop is not the Employer of Record (EOR) for this role. Our purpose in this opportunity is to connect exceptional candidates with leading employers. We help job seekers worldwide discover roles that match their goals and guide them to complete their full application directly through the hiring company’s career page or ATS.