Oracle Data Architect

Avance Consulting
Leeds
1 day ago
Create job alert

Role – Principal Consultant

Technology – Data Architect, Oracle HCM Cloud, Oracle EBS

Location – Leeds, UK

Duration - Permanent


Job Description


Lead the design and execution of data strategy and large-scale HR data migrations to Oracle HCM Cloud and Microsoft Azure, ensuring security, performance, and compliance.


Your role


As a Senior Data Architect, you will lead the definition of data strategy and design robust, scalable solutions to support large-scale migration initiatives to Oracle HCM Cloud and Microsoft Azure Fabric. You will architect and implement frameworks that ensure secure, high-performance data flows across complex ecosystems, leveraging modern cloud technologies to deliver efficient and compliant solutions.

In this role, you will drive the end-to-end execution of data migration for high-volume HR datasets—including Core HR, Talent, Recruiting, Compensation, Benefits, Absence, and Payroll—while ensuring data quality, auditability, and regulatory compliance. You will establish governance standards, optimize performance, and guide teams through architecture reviews, solution design, and delivery processes. Your leadership will be pivotal in shaping strategies that enable seamless integration and empower clients to meet evolving business needs.


Responsibilities.

  • Define data migration approach from heterogeneous source systems (EBS + non-EBS HR/payroll/benefits systems) to Oracle HCM Cloud and Microsoft Fabric
  • Define/validate data migration approach for large & complex analytics platform in HCM
  • Create & track cutover tasks for Data Migrations for multi-phased cutovers for HCM cloud, Parallel Payroll runs and Analytic platforms.
  • Ability to communicate and coordinate data migration aspects with multiple stakeholders (PMO, Client & End customer)
  • Design canonical data models to consolidate data from multiple sources into HCM Cloud.
  • Establish cross-system mapping rules, including handling duplicate records, conflicting identifiers, and data harmonization.
  • Implement data standardization for non-EBS sources like CSV, flat files, APIs. Ensure referential integrity across merged datasets
  • Define data cleansing strategy for non-EBS sources & implement deduplication logic for employees appearing in multiple systems
  • Create validation dashboards for multi-source reconciliation
  • Experience in handling large data integration with productions like Azure, OIC, Fabric is an added advantage

Required

  • 20+ years of experience in data architecture/data engineering, with at least 5+ years leading migrations to HCM.
  • Proven experience in multi-source HR data migration (e.g., Oracle EBS and legacy HR/Payroll systems).
  • Strong knowledge of Oracle HCM Cloud modules and migration tools (HDL, REST APIs).
  • Hands-on experience with PL/SQL and data integration frameworks.
  • Expertise in data harmonization, canonical modeling, and duplicate resolution.
  • Experience in migrating data for large and complex business transformation programs.
  • Familiar with modern cloud data technologies (e.g., Microsoft Azure Fabric, OCI).
  • Exposure to performance optimization techniques for high-volume HR datasets.

Related Jobs

View all jobs

Senior Data Architect — Oracle HCM Cloud & EBS Migrations

Principal Consultant- Data Architect, Oracle HCM Cloud, Oracle EBS

Snowflake Data architect

Senior Data Architect: Scalable Data & Governance

Senior Data Architect

Integration & Data Architect

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.

Neurodiversity in Data Science Careers: Turning Different Thinking into a Superpower

Data science is all about turning messy, real-world information into decisions, products & insights. It sits at the crossroads of maths, coding, business & communication – which means it needs people who see patterns, ask unusual questions & challenge assumptions. That makes data science a natural fit for many neurodivergent people, including those with ADHD, autism & dyslexia. If you’re neurodivergent & thinking about a data science career, you might have heard comments like “you’re too distracted for complex analysis”, “too literal for stakeholder work” or “too disorganised for large projects”. In reality, the same traits that can make traditional environments difficult often line up beautifully with data science work. This guide is written for data science job seekers in the UK. We’ll explore: What neurodiversity means in a data science context How ADHD, autism & dyslexia strengths map to common data science roles Practical workplace adjustments you can request under UK law How to talk about your neurodivergence in applications & interviews By the end, you’ll have a clearer sense of where you might thrive in data science – & how to turn “different thinking” into a real career advantage.

Data Science Recruitment Trends 2025 (UK): What Job Seekers Need To Know About Today’s Hiring Process

Summary: UK data science hiring has shifted from title‑led CV screens to capability‑driven assessments that emphasise rigorous problem framing, high‑quality analytics & modelling, experiment/causality, production awareness (MLOps), governance/ethics, and measurable product or commercial impact. This guide explains what’s changed, what to expect in interviews & how to prepare—especially for product/data scientists, applied ML scientists, decision scientists, econometricians, growth/marketing analysts, and ML‑adjacent data scientists supporting LLM/AI products. Who this is for: Product/decision/data scientists, applied ML scientists, econometrics & causal inference specialists, experimentation leads, analytics engineers crossing into DS, ML generalists with strong statistics, and data scientists collaborating with platform/MLOps teams in the UK.