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 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, data profiling, validation, reconciliation, and investigation of data defects. * Experience defining and documenting source-to-target mappings, including cleansing, derivation, transformation, aggregation, and validation rules. * Ability to analyze large and complex legacy solutions, uncover undocumented logic, and structure requirements by data domain and migration wave. * Understanding of data-quality principles, reconciliation methods, control totals, exception handling, and auditability. * Ability to facilitate requirements workshops and communicate effectively with both business and technical stakeholders. * Strong analytical and problem-solving skills, with the ability to produce clear documentation, prioritize work, and track decisions. * Ability to manage multiple domains or workstreams simultaneously and collaborate closely with another Business Analyst. * High attention to detail and a strong commitment to keeping migrated data and business logic accurate, complete, and traceable.
Would Be a Plus: * Experience in HR, HRBI, People Analytics, SuccessFactors, or other Human Capital Management data domains. * Familiarity with Azure Databricks. * Experience with Azure Data Factory. * Knowledge of Delta Lake. * Familiarity with Medallion Architecture. * Understanding of cloud data-platform concepts.
