Data Transformation Manager — AI-Driven, Scalable Data

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

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