Data Engineer II

About the Role

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.

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.

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

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

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

Benefits

• 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