Our Customer:
Our customer is migrating an existing People Analytics HRBI data platform from an on-premises Oracle environment to Azure Databricks. The project involves analyzing and documenting the existing HRBI solution, defining migration requirements across data domains, and supporting the transition to the target cloud data platform.
Your Tasks:
Lead business analysis activities for the migration of the existing People Analytics HRBI data platform from Oracle on-premises to Azure Databricks.
Analyze existing ETL processes, database objects, data models, transformation logic, dependencies, schedules, controls, and operational procedures.
Collaborate with HR data owners, subject-matter experts, technical teams, and architects to clarify and document the required behavior of the target data solution.
Break down the existing HRBI solution into data domains and define the detailed migration scope for assigned domains.
Create and maintain business requirements, functional specifications, user stories, acceptance criteria, data dictionaries, and source-to-target mappings.
Document both current-state and target-state data flows, including source systems, data ingestion processes, transformation rules, database entities, and downstream data interfaces.
Identify and document the facts, dimensions, historical data, calculations, business rules, and shared Core HR elements required for each migrated domain.
Ensure that existing HRBI logic is fully understood and documented before it is rebuilt or adapted in Azure Databricks.
Work closely with Data Engineers to translate business and data requirements into clear and implementable ETL and database development tasks.
Support the definition and review of target data models, database structures, data layers, naming conventions, and reusable data-processing patterns.
Define data-quality checks, reconciliation rules, control totals, and acceptance thresholds for migrated data.
Prepare test scenarios and expected results covering data ingestion, transformations, historical data, data quality, and reconciliation.
Support System Integration Testing (SIT), User Acceptance Testing (UAT), defect analysis, and validation of migrated ETL processes and database outputs.
Analyze data discrepancies between the existing Oracle HRBI solution and Azure Databricks, coordinate root-cause analysis, and follow identified issues through resolution.
Identify cross-domain dependencies, sequencing constraints, migration risks, and required prerequisites.
Support domain cutover planning, parallel-run activities, production-readiness reviews, and the controlled retirement of migrated Oracle ETL and database components.
Maintain the domain backlog, track outstanding requirements and decisions, and provide clear status updates on progress, risks, issues, and blockers.
Work independently across assigned domains while collaborating effectively with the second Business Analyst and the wider delivery team.
Required Experience and Skills:
5+ years of experience as a Business Analyst working on data warehouse, ETL, data lake, database migration, or enterprise data-platform projects.
Bachelor’s degree in Information Systems, Computer Science, Industrial Engineering, Business Administration, or a related field, or equivalent relevant professional experience.
Proven experience analyzing complex ETL processes, relational databases, data models, transformation logic, and data dependencies.
Hands-on experience creating functional specifications, source-to-target mappings, data dictionaries, user stories, test scenarios, and acceptance criteria.
Experience supporting data migration, data validation, reconciliation, SIT, UAT, and production cutover activities.
Experience working with cross-functional teams that include business stakeholders, Data Engineers, Data Architects, database specialists, QA, platform teams, Security, and Data Privacy.
Strong business analysis skills, with the ability to transla
