Data Engineer II

Summary

Ncontracts helps financial institutions make better decisions by providing tools to understand and mitigate risks and compliance concerns. The Data Engineer II will build and optimize ETL pipelines, data warehouses, data models, reports, and dashboards while collaborating with stakeholders and cross-functional teams to deliver scalable, accurate data systems.

Responsibilities

• Contribute to building out ETL pipelines to include data from all Ncontracts products
• Write performant and maintainable code, utilizing state-of-the-art tooling and AI agents
• Ensure the quality of ETL process
• Define data models and build reports in our analytics platform
• Communicate well with other members of the data team and across the functional area
• Advocate for best practices and continuous improvement
• Participate in architecting and building a scalable data platform
• Mentor team members on their area of expertise

Skills

• 3+ Years of experience as Data Engineer designing and implementing data warehouse and data lake solutions in an enterprise environment
• Intimate knowledge of dbt is required
• 3+ years experience with Azure Data Factory, Snowflake, or AWS Redshift is required
• Strong background in MS SQL Server is required
• Experience in data architecture using different database types and data formats
• Strong knowledge in building data pipelines to clean, enrich, and transform data
• Experience in database design and tuning techniques
• Experience with version control systems (Azure DevOps, Git) and familiarity with CI/CD concepts
• Experience with Python is a plus and highly desirable
• Experience working in horizontally scaling systems
• Experience with Claude Code in developing ETL pipelines and data models
• Prior work in creating reports and dashboards in a modern analytics platform (Sigma, Omni, etc.)
• Exposure to Microsoft Fabric is a plus
• Experience with other cloud data stacks (Google, AWS) is a plus
• Familiarity with message/event driven architecture patterns and distributed systems architecture
• Familiarity with systems integration

Qualifications

Must Haves

• 3+ Years of experience as Data Engineer designing and implementing data warehouse and data lake solutions in an enterprise environment
• Intimate knowledge of dbt is required
• 3+ years experience with Azure Data Factory, Snowflake, or AWS Redshift is required
• Strong background in MS SQL Server is required
• Experience in data architecture using different database types and data formats
• Strong knowledge in building data pipelines to clean, enrich, and transform data
• Experience in database design and tuning techniques
• Experience with version control systems (Azure DevOps, Git) and familiarity with CI/CD concepts

Nice to Haves

• Experience with Python is a plus and highly desirable
• Experience working in horizontally scaling systems
• Experience with Claude Code in developing ETL pipelines and data models
• Prior work in creating reports and dashboards in a modern analytics platform (Sigma, Omni, etc.)
• Exposure to Microsoft Fabric is a plus
• Experience with other cloud data stacks (Google, AWS) is a plus
• Familiarity with message/event driven architecture patterns and distributed systems architecture
• Familiarity with systems integration

Benefits

• Offers Bonus
• Remote work option
• Responsible PTO Plan that meets or exceeds state and local medical and family leave laws
• 11 paid holidays
• Community and social events to keep you connected and engaged
• Mental Health Benefits
• Medical, Dental and Vision insurance
• Company-paid Group Life Insurance, Short- and Long-Term Disability
• Flexible Spending Account & Health Savings Account
• Aflac Benefits – Critical Illness, Cancer Protection, & Hospital Choice
• Pet Insurance
• 401 (k) with company match with eligibility on Day 1 of employment
• 2 Paid Volunteer Time Off Days
• Full-time temporary employees are eligible for certain group benefits after a waiting period; specific eligibility timing will be provided at the time of offer.