Data Transformation Manager

Strongpoint Partners; Chicago (IL); Hybrid; USD 100,000 - 120,000; Full time

Benefits offered by this job

Flexible Workplace

Flexible PTO

Inclusive Environment

Growth Opportunities

Comprehensive Benefits

Job summary

Strongpoint Partners is seeking a Data Transformation Manager to join our Data & Analytics team in Chicago. This hybrid role entails leading data transformation, ensuring data quality, and migrating data across core business systems.

You will leverage AI tools to optimize processes, collaborate with cross‑functional teams, and design automated monitoring to maintain hygiene and coverage. The position requires 5–7 years in data transformation and hands‑on experience with BI tools.

Qualifications

• Bachelor's degree in a relevant field or equivalent experience.
• 5–7 years of experience in data transformation, analytics, or data engineering.
• Experience with data visualization tools such as Power BI or Tableau.
• Strong understanding of database management, data manipulation, and data governance.
• Experience owning enterprise‑level data quality or governance initiatives.
• Experience designing automated data monitoring, validation, or alerting systems.

Responsibilities

• Define, monitor, and improve data integration speed and coverage KPIs, owning design and implementation.
• Maintain enterprise‑wide data hygiene by establishing data quality standards and collaborating with cross‑functional teams.
• Design, build, and maintain automated tools to monitor data quality, coverage, and integrity.
• Leverage AI tools (ChatGPT, Claude) to improve transformation processes and coverage detection.
• Analyze data structures, collect, clean, validate, and transform data from multiple sources.
• Collaborate with teams to understand requirements and ensure successful data conversions.
• Create and maintain documentation for data mappings and transformation logic.
• Troubleshoot data conversion issues and implement long‑term solutions.
• Identify opportunities for process improvements and automation to increase efficiency.
• Conduct post‑conversion validation to ensure data integrity and accuracy.
• Analyze structured and unstructured datasets using statistical methods and data visualization.
• Communicate progress, challenges, and outcomes to stakeholders.

Skills

Data transformation

Data analytics

Data governance

AI tooling

Power BI

Tableau

Communication

Problem solving

Education

Bachelor's degree in Data Science/Statistics/CS

Tools

Snowflake

dbt

Power BI

Tableau

Job description

Strongpoint Partners is a tech‑enabled retirement services platform serving small‑to‑mid‑sized businesses with integrated retirement third‑party administration, recordkeeping, payroll, and HR solutions. Recognized as one of Inc. 5000’s Fastest Growing Private Companies in America and certified as a Great Place to Work, Strongpoint offers a suite of services that prioritizes accuracy, compliance, and reduction of regulatory risk for its clients, delivered by local client success teams that understand the nuances of the markets they serve.

Position Summary

Strongpoint Partners is seeking a Data Transformation Manager to join our Data & Analytics team. This role plays a critical part in analyzing and interpreting complex data sets while leading the transformation and migration of data across core business systems. The Data Transformation Manager is responsible for ensuring accurate, efficient, and seamless data conversions while maintaining enterprise‑wide data quality, hygiene, and coverage.

This is a hybrid position based in our Chicago, Illinois office, with an expectation of three days per week in the office.

Key Responsibilities

• Define, monitor, and improve data integration speed and coverage KPIs while owning process design and implementation.
• Maintain accountability for enterprise‑wide data hygiene and coverage by establishing data quality standards and partnering with cross‑functional teams.
• Design, build, and maintain automated tools that monitor data quality, coverage, and integrity while identifying inconsistencies or missing data.
• Leverage AI tools, including ChatGPT and Claude, to improve data transformation processes, automate monitoring, and enhance coverage detection.
• Analyze existing data structures and formats while collecting, cleaning, validating, and transforming data from multiple sources.
• Collaborate with cross‑functional teams to understand business requirements and ensure successful data conversions.
• Create and maintain documentation for data mappings, conversion processes, and transformation logic.
• Troubleshoot data conversion issues and implement timely, long‑term solutions.
• Identify opportunities for process improvements and automation to increase efficiency.
• Conduct post‑conversion validation to ensure data integrity and accuracy.
• Analyze structured and unstructured datasets using statistical methods and data visualization tools.
• Communicate project progress, challenges, and outcomes to technical and non‑technical stakeholders.

Minimum Qualifications

• Bachelor's degree in Data Science, Statistics, Mathematics, Computer Science, a related business discipline, or equivalent experience.
• 5–7 years of experience in data transformation, analytics, data engineering, or a related field.
• Experience with data visualization tools such as Power BI or Tableau.
• Strong understanding of database management principles, data manipulation techniques, and data governance best practices.
• Demonstrated experience owning enterprise‑level data quality or governance initiatives.
• Experience designing or implementing automated data monitoring, validation, or alerting systems.
• Strong analytical and problem‑solving skills with the ability to work with large, complex datasets.
• Excellent written and verbal communication skills with the ability to communicate technical concepts to diverse audiences.
• Strong organizational skills, attention to detail, and the ability to manage multiple priorities.
• Ability to work independently and collaboratively in a fast‑paced environment.
• Consulting experience and certifications in Snowflake, Power BI, dbt, or related technologies are a plus.

Pay Transparency Statement

The anticipated pay range for this position is $100,000–120,000 annually.

Our Value‑Driven Employee Experience

• Flexible Workplace – Hybrid and remote options available for many roles.
• Flexible PTO – Competitive paid time off, including flexible & unlimited options.
• Inclusive Environment – A culture that values diversity, collaboration, and respect.
• Growth Opportunities – Support for ongoing learning and career development.
• Comprehensive Benefits – Health, dental, vision, life, and disability coverage.

As set forth in Strongpoint Partners’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.