Manager - Data Transformation

Career1Source - Executive Recruiting; Chicago (IL); Hybrid; USD 120,000 - 190,000; Full time

Job summary

Career1Source - Executive Recruiting partners with a fast-growing, private equity-backed services organization in Chicago to recruit a Manager – Data Transformation. The role focuses on leading data transformation, integration, and migration initiatives to unify data across multiple systems.

You will improve data quality, hygiene, and integrity while building automated tools to detect data issues. The position leverages AI and automation to enhance transformation and monitoring, collaborating

Qualifications

• 5–7+ years in data transformation, data engineering, analytics, or related field.
• Strong SQL skills with hands‑on Python or similar programming experience.
• Experience with complex datasets and multiple source systems.

Responsibilities

• Lead complex data transformation, integration, and migration initiatives.
• Own and improve enterprise data quality, hygiene, and integrity.
• Build automated tools to identify missing, inconsistent, or inaccurate data.
• Leverage AI and automation to improve data transformation and monitoring.
• Develop repeatable processes for data validation, mapping, and conversion.
• Partner with business and technical teams to solve complex data challenges.

Skills

SQL

Python

Data transformation

Data integration

AI and emerging tech

Tools

Snowflake

dbt

Power BI

Tableau

Job description

Chicago, IL | Hybrid – 3 Days/Week

We’re partnering with a rapidly growing, private equity-backed services organization in Chicago to find a Manager – Data Transformation who can play an important role in how the company integrates, manages, and scales its data.

The company has grown significantly through acquisition, creating an increasingly complex data environment across multiple businesses and systems. This person will help bring that data together—improving quality, consistency, and accessibility while building better tools and processes to support continued growth.

What You’ll Do

• Lead complex data transformation, integration, and migration initiatives
• Own and improve enterprise data quality, hygiene, and integrity
• Build automated tools to identify missing, inconsistent, or inaccurate data
• Leverage AI and automation to improve data transformation and monitoring
• Develop repeatable processes for data validation, mapping, and conversion
• Partner with business and technical teams to solve complex data challenges
• Help build the data infrastructure needed to support continued acquisition-driven growth

What We’re Looking For

• 5–7+ years in data transformation, data engineering, analytics, or a related field
• Strong SQL skills with hands‑on Python or similar programming experience
• Experience working with complex datasets and multiple source systems
• Experience building automated monitoring or validation solutions
• Strong problem‑solving skills and an interest in using AI and emerging technologies
• Snowflake, dbt, Power BI, Tableau, or similar experience is a plus

Why This Opportunity?

This is an opportunity to do more than maintain an existing data environment. You’ll have the chance to build, improve, automate, and influence how a growing PE‑backed organization uses data as it continues to scale.

Compensation:

Competitive base salary + bonus + comprehensive benefits.

*Candidates must be eligible to work in the US as well as meet the qualifications listed above in order to be considered for the Manager – Data Transformation job.