Senior Business Analyst - People Analytics Cloud Migration

How You’ll Spend Your Day

• Lead business analysis activities for the migration of the existing People Analytics HRBI data platform from Oracle on-premises to Azure Databricks.
• Analyze the existing ETL processes, database objects, data models, transformation logic, dependencies, schedules, controls, and operational procedures.
• Work with HR data owners, subject-matter experts, technical teams, and architects to clarify and document the required behavior of the target data solution.
• Decompose the current HRBI solution into data domains and define the detailed migration scope for the assigned domains.
• Create and maintain business requirements, functional specifications, user stories, acceptance criteria, data dictionaries, and source-to-target mappings.
• Document current-state and target-state data flows, including source systems, ingestion processes, transformation rules, database entities, and downstream data interfaces.
• Identify the facts, dimensions, history, 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 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 for data ingestion, transformation, history, data quality, and reconciliation.
• Support System Integration Testing, User Acceptance Testing, defect analysis, and validation of migrated ETL processes and database outputs.
• Analyze data differences between the Oracle HRBI solution and Azure Databricks, coordinate root-cause analysis, and follow 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 controlled retirement of migrated Oracle ETL and database components.
• Maintain the domain backlog, track open 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.

Your Qualification and Experience

• Experience in the pharmaceutical or manufacturing industry, combined with hands-on experience in AI, is required.
• Bachelor’s degree in Information Systems, Computer Science, Industrial Engineering, Business Administration, or equivalent relevant experience.
• Minimum 5 years of experience as a Business Analyst in data warehouse, ETL, data lake, database migration, or enterprise data-platform projects.
• Proven experience analyzing complex ETL processes, relational databases, data models, transformation logic, and data dependencies.
• Experience preparing 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 including business stakeholders, data engineers, data architects, database specialists, QA, platform teams, Security, and Data Privacy.
• Experience in HR, HRBI, People Analytics, SuccessFactors, or other Human Capital Management data domains is preferred.

Skills and Capabilities

• Strong business analysis skills with the ability to translate business processes and legacy-system behavior into precise data and ETL requirements.
• Strong understanding of ETL/ELT concepts, relational databases, data warehousing, data lakes, facts, dimensions, history management, and data lineage.
• Ability to read and analyze SQL, database schemas, mapping documents, ETL specifications, and technical data-flow documentation.
• Practical SQL skills for data analysis, profiling, validation, reconciliation, and investigation of data defects.
• Experience with source-to-target mapping and documentation of cleansing, derivation, transformation, aggregation, and validation rules.
• Ability to analyze large and complex legacy solutions, identify undocumented logic, and structure requirements by data domain and migration wave.
• Understanding of data-quality principles, reconciliation methods, control totals, exception handling, and auditability.
• Familiarity with Azure Databricks, Azure Data Factory, Delta Lake, Medallion Architecture, and cloud data-platform concepts is preferred.
• Ability to facilitate requirement workshops and communicate effectively with both business and technical stakeholders.
• Strong analytical, problem-solving, documentation, prioritization, and decision-tracking capabilities.
• Ability to manage multiple domains or workstreams simultaneously and collaborate closely with another Business Analyst.
• High attention to detail and commitment to ensuring that migrated data and business logic remain accurate, complete, and traceable.