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.