ETL Developer: Data Integration & Quality

Jack Schroeder and Associates, LLC; Green Bay (WI); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Competitive salary

Comprehensive benefits

Half-day Fridays

Paid holidays

Professional development

Job summary

Jack Schroeder and Associates, LLC in Green Bay, WI is seeking an ETL Developer to design and implement data integration pipelines. You will extract data from diverse sources, transform it to business specifications, and load it into target systems using SQL and modern ETL tools.

You will optimize performance, ensure data quality, and collaborate with analysts and data scientists to deliver reliable, scalable solutions.

Qualifications

• Strong understanding of data warehousing concepts.
• Familiarity with scripting languages (Python, Shell) desirable.
• Experience with cloud-based ETL tools (Azure Data Factory or DataBricks) preferred.
• Excellent problem-solving skills and attention to detail.
• Clear communication and teamwork abilities.

Responsibilities

• ETL Design & Development: Develop and implement ETL processes to extract data from various sources, transform it as per business requirements, and load it into target systems.
• Design and develop complex SQL queries, scripts, and procedures to support data transformation and manipulation.
• Integrate data from multiple sources including databases, flat files, APIs, and cloud services.
• Optimize ETL processes for performance, scalability, and reliability.
• Troubleshoot and resolve ETL performance issues, data discrepancies, and failures.
• Implement data validation and cleansing processes to ensure data accuracy and integrity.
• Monitor ETL jobs and workflows to ensure data loads are completed successfully and in a timely manner.
• Create and maintain detailed documentation for ETL processes, workflows, and data mappings.
• Generate reports and dashboards to provide insights into ETL performance and data quality.
• Work closely with business analysts and data scientists to understand data requirements and deliver solutions that meet their needs.
• Participate in data architecture and design discussions to ensure alignment with overall data strategy.

Skills

Data warehousing

Scripting (Python, Shell)

Cloud ETL tools

SQL

Data integration

Data quality

Problem solving

Communication & teamwork

Tools

Azure Data Factory

DataBricks

Tableau

PowerBI

Job description

Jack Schroeder and Associates, LLC in Green Bay, WI is seeking an ETL Developer to design and implement data integration pipelines. You will extract data from diverse sources, transform it to business specifications, and load it into target systems using SQL and modern ETL tools.

You will optimize performance, ensure data quality, and collaborate with analysts and data scientists to deliver reliable, scalable solutions.