Principal Data Analyst

Apex Systems; Cincinnati (OH); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading technology solutions provider is seeking a Principal Data Analyst in Cincinnati, Ohio. The role involves documenting and analyzing legacy data solutions for migration to a modern platform, with a focus on Dynamic SQL and data flow documentation. Ideal candidates will have advanced skills in impact analysis and communication, able to work independently and collaboratively in a fast-paced environment.

Qualifications

• Advanced proficiency in Dynamic SQL and query optimization.
• Experience documenting complex data flows and transformation logic.
• Strong capability in performing impact analysis on architectural changes.

Responsibilities

• Analyze and document the current legacy data solution.
• Develop documentation on how Dynamic SQL queries work.
• Create comprehensive data flow diagrams for migration planning.

Skills

Dynamic SQL proficiency

Impact analysis

Data flow documentation

Communication skills

Collaborative work

Job description

Overview

Principal Data Analyst at Apex Systems. Lead the documentation and analysis of a legacy data solution as part of a strategic migration to a modern data platform. Focus on understanding and mapping current data flows, identifying dependencies, and supporting the planning of modularizing the solution into distinct, manageable components. The ideal candidate will bring expertise in Dynamic SQL, data flow documentation, and impact analysis.

Job Responsibilities

• Analyze and document the current legacy data solution, focusing on how data moves, transforms, and integrates across the system
• Develop and maintain documentation on how Dynamic SQL queries extract, validate, and trace data across the legacy environment
• Create comprehensive data flow diagrams and documentation to support migration and modularization planning
• Identify and assess the impact of splitting the solution into multiple components, including technical dependencies and business implications
• Collaborate with data engineers, architects, and business stakeholders to ensure accurate understanding of current-state architecture
• Provide recommendations for sequencing, risk mitigation, and transition planning
• Support the creation of migration playbooks and technical documentation for future-state implementation

Job Requirements

• Advanced proficiency in Dynamic SQL and query optimization
• Proven experience in documenting complex data flows, including transformation logic and system interactions
• Strong ability to perform impact analysis on architectural changes, especially in modularization or phased migration contexts
• Excellent communication and documentation skills, with the ability to translate technical findings for diverse audiences
• Experience working independently and collaboratively in fast-paced environments

Equal Opportunity

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you require an accommodation in using our website for a search or application, please contact our Employee Services Department.

Apex Systems is part of the Commercial Segment of ASGN Incorporated. NYSE: ASGN