1

Data Transformation Jobs in Chicago, IL (NOW HIRING)

Strong data transformation skills across various software CRE platforms and tools * Demonstrated ability to work effectively in matrix environment with cross-functional teams. * Experience working in ...

We are seeking a detail-oriented Data Analyst with strong experience in data mapping, data analysis, and data transformation . The ideal candidate will work closely with business stakeholders, data ...

Data Engineering & DevelopmentDesign and develop end-to-end data ingestion| transformation| and loading (ETL/ELT) pipelines.Build and maintain enterprise data lakes and data warehouses on Azure.

next page

Showing results 1-20

Data Transformation information

See Chicago, IL salary details

$47.4K

$170K

$250.8K

How much do data transformation jobs pay per year?

As of Aug 4, 2026, the average yearly pay for data transformation in Chicago, IL is $169,993.00, according to ZipRecruiter salary data. Most workers in this role earn between $137,500.00 and $175,100.00 per year, depending on experience, location, and employer.

What are the key skills and qualifications needed to thrive in the data transformation position, and why are they important?

To thrive in a Data Transformation role, a strong background in data analysis, data modeling, and database management is essential, often supported by a degree in computer science, information systems, or a related field. Proficiency with data transformation tools like SQL, ETL platforms (such as Informatica or Talend), and cloud data services is typically required, and certifications in these areas can be advantageous. Strong problem-solving skills, attention to detail, and effective communication abilities are key for collaborating with cross-functional teams and addressing complex data challenges. These skills and qualities are important because they ensure accurate, efficient data transformations that support critical business decisions.

What are the typical daily responsibilities of someone in a data transformation role?

In a Data Transformation role, your daily responsibilities often include analyzing raw data from multiple sources, designing and executing processes to clean and reformat data, and collaborating with business and IT teams to ensure data meets project requirements. You’ll typically work with ETL (Extract, Transform, Load) tools to automate and streamline these processes, as well as perform quality checks to validate data accuracy. Coordinating with data engineers, data analysts, and stakeholders is a key part of the job to ensure projects align with business goals. Staying up-to-date with new data management technologies and best practices can also be a regular part of your routine, helping to drive ongoing improvements.

What is a data transformation?

A Data Transformation job involves converting, structuring, and optimizing raw data to make it useful for analysis, reporting, or other business processes. Professionals in this role use ETL (Extract, Transform, Load) tools, coding languages like SQL or Python, and cloud platforms to clean, aggregate, and reformat data. They ensure data integrity, improve accessibility, and support data-driven decision-making. This role is essential in industries that rely on accurate and efficient data processing, such as finance, healthcare, and e-commerce.

What are the most commonly searched types of Data Transformation jobs in Chicago, IL? The most popular types of Data Transformation jobs in Chicago, IL are:
What job categories do people searching Data Transformation jobs in Chicago, IL look for? The top searched job categories for Data Transformation jobs in Chicago, IL are:
Infographic showing various Data Transformation job openings in Chicago, IL as of July 2026, with employment types broken down into 1% As Needed, 83% Full Time, 12% Part Time, 1% Temporary, and 3% Contract. Highlights an 88% Physical, 3% Hybrid, and 9% Remote job distribution, with an average salary of $169,993 per year, or $81.7 per hour.

Data Transformation Manager

Strongpoint Partners

Chicago, IL • On-site

Full-time

Medical, Dental, Vision, Life, PTO

Posted 14 days ago


Job description

Who we are:
Strongpoint Partners is 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. With a coast-to-coast network of 19 leading firms including HowardSimon ("HSR"), Jocelyn Pension Consulting ("JPC"), Retirement Strategies Group ("RSG"), Retirement Planners and Administrators ("RPA"), Pension Financial Services ("PFS"), Pollard & Associates ("PA"), Carlson Quinn ("CQ"), SI GROUP ("SIG"), Retirement Planning Consulting Group ("RPCG"), Karel-Gordon & Associates ("KGA"), Cash Balance Actuaries ("CBA"), Pension Consultants, Inc. ("PCI"), Actuaries Unlimited ("AUI"), California Retirement Plans ("CRP"), Benefit Equity ("BEI"), United Benefit Pensions, Inc. ("UBP"), Creative Retirement Systems ("CRS"), Associated Pension Consultants ("APC"), Allied Consultants, Inc. ("ACI"), American Retirement Plan Services, LLC ("ARPS"), and SMS Retirement ("SMS"). Strongpoint Partners combines a relentless passion for service and innovation with the experience and expertise required to make retirement work for everyone. For more information, please visit: www.strongpointpartners.com.
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.
In addition to hands-on data transformation and migration work, this role is accountable for designing, building, and maintaining automated tools that monitor data quality, identify gaps, and improve overall data integrity. The ideal candidate combines strong technical expertise with an analytical mindset and is passionate about leveraging AI and automation to scale data operations across the organization.
PLEASE NOTE: 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.
  • Utilize SQL, Python, JavaScript, and other tools to manipulate, validate, and transform data.
  • 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.
  • Proficiency with SQL, PostgreSQL, Python, JavaScript, or similar programming languages.
  • 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.
At Strongpoint Partners, our salary ranges reflect the minimum and maximum base pay for the posted position applicable to all locations across the US. Within the posted salary range, individual pay is determined by the geographic location, job related skills, experience, education, and certifications. Our total compensation package includes base pay plus a comprehensive benefits program.
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.
  • Workplace Perks - Incentive bonus programs, flexible hours, & more.

**Specific benefits and programs may vary by partner and position.