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