2 results for Data Warehouse Analyst in Columbus, OH

QA Testing Analyst: IV (Lead) We are offering a long-term contract employment opportunity for a QA Testing Analyst: IV (Lead) based in Columbus, Ohio. In this role, you will be primarily responsible for leading the development of test strategies and plans for Data Warehouse projects, ensuring all IT SDLC processes are documented and executed. You will be working closely with various technology teams across the enterprise and will be expected to execute test cases while communicating status updates to project team members and key stakeholders. Responsibilities: • Actively engage in the review of project requirements, data mappings, and technical design specifications. • Develop and implement test strategies and plans for Data Warehouse projects, ensuring proper test coverage. • Execute test cases using both manual and automated testing processes. • Perform ETL validation according to data mapping, including data profiling, reconciliation of data, metadata validation, and initial and delta validation for different SCD types. • Coordinate test execution with other application teams and UAT partners, ensuring seamless performance across all platforms. • Execute database queries to support test execution in Azure DevOps. • Analyze data, identify and troubleshoot data issues, and develop action plans to address data quality issues. • Communicate testing statuses with project team members and stakeholders, ensuring all parties are kept informed of progress. • Identify, document, and communicate testing defects to the project team. • Collaborate with the project team on defect analysis and triage, ensuring issues are addressed promptly and effectively. • Contribute to continuous improvement initiatives by identifying and addressing opportunities to define or enhance QA processes.

HRIS Analyst (Snowflake) The Data Governance Steward III serves as a critical link between organizational business needs and data management, focusing on overseeing and safeguarding data assets to ensure they are utilized appropriately and maintained with high accuracy. This role actively participates in enterprise data governance initiatives, including a major implementation project migrating from PeopleSoft to Workday. Responsibilities:<ul><li>Collaborate with IT developers and business analysts to document and track information/data flows.</li><li>Gather and document business customer requirements for HR data.</li><li>Map core HR data (e.g., worker history, payroll, recruiting) for migration and align future hiring analytics.</li><li>Validate solutions through data quality assurance processes.</li><li>Facilitate meetings involving IT, business analysts, and data architects.</li><li>Translate requirements for data mapping during migration from PeopleSoft to Workday.</li><li>Engage with Workday systems to follow end-to-end data flow processes.</li><li>Update and refine data definitions.</li></ul> Performance Metrics:<ul><li>Progress tracking and ability to pinpoint improvement opportunities.</li><li>Maintaining high data quality, accuracy, and compliance.</li><li>Availability and attendance in virtual Teams meetings.</li></ul> Preferred Candidate Traits:<ul><li>Previous experience in data migration projects with Snowflake, Oracle, PeopleSoft, and Workday.</li><li>Proven success in enterprise-level settings handling large datasets.</li></ul> Team Interaction:<ul><li>Regular collaboration with IT, businesses analysts (reporting group), and a team directly linked to HR.</li><li>Interaction with external parties when necessary.</li></ul>