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.

Контакты работодателя (email/phone/telegram) скрыты из публичного превью — отправьте резюме, чтобы мы связали вас напрямую.