Sr ETL Developer - Chicago, IL

GCG; Chicago (IL); Hybrid; USD 110,000 - 135,000; Full time

Job summary

Join a forward-thinking company as a Senior ETL Developer, where you'll design and implement enterprise ETL solutions to enhance data quality and accessibility. This role offers a hybrid work environment, allowing you to collaborate with business users and data analysts to drive data-driven decision-making. With a focus on Azure cloud services, you'll optimize performance and ensure data integrity while mentoring junior developers. Enjoy a competitive salary and robust benefits in an inclusive workplace that values your contributions and fosters professional growth.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

401(K) with employer contribution

Short and long-term disability insurance

Qualifications

• 5+ years of ETL development and data integration experience required.
• Strong experience with Azure cloud services and ETL tools.

Responsibilities

• Design and maintain ETL workflows using Azure Data Factory.
• Collaborate with analysts to deliver actionable insights.

Skills

SQL

ETL Development

Data Integration

Problem-solving

Communication Skills

Education

Bachelor's degree in Computer Science

Tools

Azure Data Factory

Power BI

Azure Functions

Azure Logic Apps

SQL Server

Job description

Overview

GCG is currently seeking a Senior ETL Developer to join our Business Intelligence team. In this role, you will be responsible for the design, development, implementation, and maintenance of enterprise ETL solutions that support reliable, accessible, and high-quality data for analytical and reporting needs across the organization.

This role will work across multiple database platforms, including Azure cloud services, and play a key role in data modeling, integration, and analysis. You'll collaborate with business users and data analysts to deliver actionable insights that improve processes and support data-driven decision-making.

This role offers a hybrid work arrangement. When in office, the candidate chosen for the role will report to our Corporate Headquarters at 8550 W Bryn Mawr Ave Suite 400 Chicago, IL.

What you’ll do

ETL Development & Integration

1. Design, build, and maintain ETL workflows using Azure Data Factory or other enterprise ETL tools
2. Develop solutions that integrate data from SQL Server, Oracle, MySQL, and other data sources (cloud and on-premises)
3. Automate and streamline data integration processes using Azure Logic Apps and Azure Functions

Data Modeling & Azure Analysis Services (AAS)

1. Design and implement tabular data models in Azure Analysis Services to support business reporting and analytics
2. Define and support key performance indicators (KPIs), working with stakeholders to align models with reporting needs
3. Ensure data models are optimized for report performance and accuracy

Performance Optimization

1. Monitor, troubleshoot, and tune ETL and reporting workflows for speed and reliability
2. Optimize SQL queries and data model structures to support efficient data processing

Data Quality & Documentation

1. Apply data validation techniques to ensure accuracy, consistency, and integrity across all pipelines
2. Maintain ETL documentation, including data lineage, transformation logic, and reporting specifications

Collaboration & Mentorship

1. Partner with developers, analysts, and business users to translate reporting needs into technical solutions
2. Guide stakeholders on data modeling decisions, explaining the pros and cons of various design approaches

Tools & Technologies

1. Utilize a combination of tools, including:
2. Azure Data Factory, AAS, SQL Server, Power BI
3. Azure DevOps, Git repositories, SSDT Projects
4. Power BI dashboards, paginated reports, and data mapping tools

What you’ll bring

Education & Experience

1. Bachelor's degree in Computer Science, Information Systems, or a related field (preferred)
2. 5+ years of experience in ETL development, data integration, and BI reporting
3. Strong experience working with Azure cloud services and modern ETL/ELT tools

Technical Skills

1. Proficiency in SQL and experience across multiple database platforms (e.g., SQL Server, Oracle, MySQL)
2. Experience building solutions with Azure Data Factory, Azure Functions, Azure Logic Apps
3. Advanced skills in data modeling, particularly with Azure Analysis Services
4. Hands-on experience with Power BI dashboards and paginated reports
5. Familiarity with Azure DevOps, Git, SSDT Projects, and source control practices

Soft Skills

1. Strong problem-solving and analytical capabilities
2. Excellent communication skills, both technical and business-facing
3. Ability to mentor junior developers and guide stakeholders through technical decision-making
4. Comfortable working independently in a fast-paced, collaborative environment

What we offer

1. Competitive annual salary ranging from $110,000 to $135,000 per year
2. Robust and affordable benefits options, including medical, dental, vision, life insurance, short and long-term disability insurance, and more
3. 401(K) with employer contribution
4. An employee-centric company that values and truly appreciates our most important asset: You!

About GCG

At GCG, our mission is to power, connect, and automate our world. With the responsive DNA of a startup and the size of a global leader, we offer top brands and extensive value-added services that make us an invaluable partner to our customers in multiple industry verticals across the globe. We are committed to meeting the needs of our customers, while focusing attention on our responsibility to the environment, our associates and the communities we serve.

GCG is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.