Senior Data Engineer - ETL, Data Integration & Data Warehousing - REMOTE/ONSITE (Must be WI Resident)

Chandra Technologies, Inc; Madison (WI); Hybrid; USD 95,000 - 130,000; Full time

Job summary

Chandra Technologies, Inc. is seeking a Data Engineer to join a team modernizing our core data systems, focusing on invoicing and data warehousing. The role involves data integration, ETL process design, and collaboration on agile delivery with a small team. Remote work is possible with onsite option in Wisconsin.

Ideal candidates have extensive experience with SQL, ETL tooling (Alteryx preferred), CDC, and data loading strategies across diverse data sources.

Qualifications

• 6+ years of designing complex SQL and ETL processes.
• 6 years experience gathering requirements and creating technical specs for ETL.
• 6 years developing data loads (incremental, history/full, survivorship).
• 4 years implementing change data capture (CDC).
• 6 years testing and debugging ETL pipelines.
• 2 years ETL job scheduling.
• 2 years loading data warehouses using ETL tools, preferably SQL Server.

Skills

SQL

ETL requirements

ETL design

CDC implementation

ETL testing

ETL scheduling

Tools

Alteryx

SQL Server

Job description

Job Description

• Crop to Crop resumes are accepted

Location Requirement: Onsite or Remote? Candidate must be a WI Resident. No relocation is allowed. This position can work 100% remote or in the office.

We have an immediate opening at the Department of Employee Trust Funds (ETF) for a Data Engineer to participate in data integration and data warehousing for a new Invoicing system. This is part of a larger effort to modernize our core business systems. Prior experience with invoicing, billing, or payment systems is preferred. The duration of this position is expected to be 15 months. This position will work on a small, collaborative team that uses agile practices to deliver value to our business partners

Required Skills & Years Of Experience

• Developing complex SQL - 6 years
• Gathering requirements and developing technical specifications for ETL – 6 years
• Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx)
• Developing various types of data loads (e.g. incremental, history/full, survivorship rules) – 6 years
• Implementing change data capture (CDC) – 4 years
• Testing and debugging ETL – 6 years
• ETL job scheduling – 2 years
• Loading data warehouses using ETL tools – 2 years (preferably with SQL Server)

Desired Skills

• Data integration for invoicing, billing, or payment systems HIGHLY PREFERRED – 2 years (years may not align with their system, but it’s included in job description anyway)
• Management of multiple ETL tools
• Experience with data quality tools and frameworks - preferred
• Using source code version control software - preferred