Sr ETL Developer - Chicago, IL

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

Design, build, and maintain ETL workflows using Azure Data Factory or other enterprise ETL tools

Develop solutions that integrate data from SQL Server, Oracle, MySQL, and other data sources (cloud and on-premises)

Automate and streamline data integration processes using Azure Logic Apps and Azure Functions

Data Modeling & Azure Analysis Services (AAS)

Design and implement tabular data models in Azure Analysis Services to support business reporting and analytics

Define and support key performance indicators (KPIs), working with stakeholders to align models with reporting needs

Ensure data models are optimized for report performance and accuracy

Performance Optimization

Monitor, troubleshoot, and tune ETL and reporting workflows for speed and reliability

Optimize SQL queries and data model structures to support efficient data processing

Data Quality & Documentation

Apply data validation techniques to ensure accuracy, consistency, and integrity across all pipelines

Maintain ETL documentation, including data lineage, transformation logic, and reporting specifications

Collaboration & Mentorship

Partner with developers, analysts, and business users to translate reporting needs into technical solutions

Guide stakeholders on data modeling decisions, explaining the pros and cons of various design approaches

Tools & Technologies

Utilize a combination of tools, including:

Azure Data Factory, AAS, SQL Server, Power BI

Azure DevOps, Git repositories, SSDT Projects

Power BI dashboards, paginated reports, and data mapping tools

What you’ll bring

Education & Experience

Bachelor's degree in Computer Science, Information Systems, or a related field (preferred)

5+ years of experience in ETL development, data integration, and BI reporting

Strong experience working with Azure cloud services and modern ETL/ELT tools

Technical Skills

Proficiency in SQL and experience across multiple database platforms (e.g., SQL Server, Oracle, MySQL)

Experience building solutions with Azure Data Factory, Azure Functions, Azure Logic Apps

Advanced skills in data modeling, particularly with Azure Analysis Services

Hands-on experience with Power BI dashboards and paginated reports

Familiarity with Azure DevOps, Git, SSDT Projects, and source control practices

Soft Skills

Strong problem-solving and analytical capabilities

Excellent communication skills, both technical and business-facing

Ability to mentor junior developers and guide stakeholders through technical decision-making

Comfortable working independently in a fast-paced, collaborative environment

What we offer

Competitive annual salary ranging from $110,000 to $135,000 per year

Robust and affordable benefits options, including medical, dental, vision, life insurance, short and long-term disability insurance, and more

401(K) with employer contribution

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. These duties and responsibilities listed above are judged to be "essential functions" in terms of the Americans With Disabilities Act, or ADA. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill, and/or ability required. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Furthermore, the above statements are intended to describe the general nature and level of work being performed by a person in this position. They are not to be construed as an exhaustive list of all duties that may be performed by such a person.

#LI-Hybrid

#LI-AS1

Regular Full-Time