Data Warehouse Engineer III: Invoicing & ETL Specialist

Novalink Solutions; Kentucky; Sur place; USD 90 000 - 130 000; Plein temps

Résumé du poste

Novalink Solutions seeks a Data Engineer for the Department of Employee Trust Funds in Madison, WI. The role focuses on data integration and warehousing for a new invoicing system, with an agile team delivering value to business partners.

Ideal candidates bring extensive ETL experience, including Alteryx, CDC, SQL, and data quality tools, and can mentor others while managing multiple projects in a fast-paced environment.

Qualifications

• 6 years ETL design experience, preferably 2 years with Alteryx.
• Developing various types of data loads (incremental, history/full, survivorship) – 6 years.
• Implementing change data capture (CDC) – 4 years.
• Testing and debugging ETL – 6 years.
• Developing complex SQL – 6 years.
• ETL job scheduling – 2 years.
• Loading data warehouses using ETL tools – 2 years (preferably SQL Server).
• Data integration for invoicing, billing, or payment systems – 2 years preferred.
• Experience with data quality tools and frameworks.
• Using source code version control software – GitHub preferred.
• Mentoring to others on ETL development.
• Managing multiple, concurrent projects and tasks.
• Strong interpersonal skills including communication, mentoring, collaborating, and team building.

Responsabilités

• Design ETL jobs using ETL tools and develop loads.
• Implement CDC and ensure data accuracy across warehouses.
• Test, debug, and optimize ETL pipelines.
• Develop complex SQL queries for data extraction.
• Schedule ETL jobs and monitor runs.
• Support data integration for invoicing and payments.

Connaissances

Interpersonal skills

Communication

Mentoring

Team building

Project management

Outils

Alteryx

SQL Server

GitHub

Description du poste

Novalink Solutions seeks a Data Engineer for the Department of Employee Trust Funds in Madison, WI. The role focuses on data integration and warehousing for a new invoicing system, with an agile team delivering value to business partners.

Ideal candidates bring extensive ETL experience, including Alteryx, CDC, SQL, and data quality tools, and can mentor others while managing multiple projects in a fast-paced environment.