[Remote] Data Engineer II
Note: The job is a remote job and is open to candidates in USA. Ncontracts provides integrated risk management and compliance solutions that help financial institutions understand and mitigate risks. The Data Engineer II will build and optimize ETL pipelines, data warehouses, and data models, while supporting analytics, reporting, dashboards, and scalable data platform architecture. This individual contributor will also collaborate with stakeholders and mentor less experienced team members.
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
Benefits
- For all regular full-time team members: A fun, fast-paced work environment
- For all regular full-time team members: Responsible PTO Plan that meets or exceeds state and local medical and family leave laws
- For all regular full-time team members: 11 paid holidays
- For all regular full-time team members: Community and social events to keep you connected and engaged
- For all regular full-time team members: Mental Health Benefits
- For all regular full-time team members: Medical, Dental and Vision insurance
- For all regular full-time team members: Company-paid Group Life Insurance, Short- and Long-Term Disability
- For all regular full-time team members: Flexible Spending Account & Health Savings Account
- For all regular full-time team members: Aflac Benefits – Critical Illness, Cancer Protection, & Hospital Choice
- For all regular full-time team members: Pet Insurance
- For all regular full-time team members: 401 (k) with company match with eligibility on Day 1 of employment
- For all regular full-time team members: 2 Paid Volunteer Time Off Days
- Bonus
Company Overview
Company H1B Sponsorship