Data Engineer: Legacy-to-Modern BI & Data Warehouse

Advancio Inc.; Downey (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

Advancio Inc. in Downey, CA seeks a data engineer to move and transform data across a legacy-to-modern landscape, building BI pipelines with Power BI, Databricks, and Oracle integration.

Role involves designing dashboards, building Azure Data Factory and Databricks pipelines, tuning SQL queries, and modeling data with DAX/MDX across Power BI, SSAS, and Azure Synapse. Strong collaboration and knowledge transfer are required.

Qualifications

• 5+ years experience in Power BI and Azure environments (BI-focused roles)
• 3+ years designing Power BI Paginated Reports or Data Warehouse work with Databricks/SQL Server/Oracle
• 2+ years designing data models using DAX/MDX
• 3+ years working with legacy/relational data technologies (mainframe, DB2, FOCUS, Oracle, SQL Server)
• For Oracle PBCS variants: 7+ years implementing/supporting Oracle Planning & Budget Cloud Services, 3+ in a lead capacity

Responsibilities

• Profile, cleanse, transform, validate, and load data from legacy systems into target solutions
• Support data mapping and crosswalk analysis across organizations and vendors
• Design and develop Power BI dashboards, paginated reports, and row/object-level security
• Build and support Azure Data Factory / Databricks data pipelines and data warehouse solutions
• Develop and tune Oracle PL/SQL and SQL Server queries, stored procedures, and jobs
• Design data models using DAX/MDX across Power BI, SSAS, Databricks, or Azure Synapse
• Support data loading and integrations using REST APIs and EPM Automate (for Oracle PBCS/EPM variants)
• Document extraction logic, validation rules, and data-retention/compliance requirements
• Facilitate knowledge transfer so business users can work independently with converted data

Skills

Power BI

Azure Databricks

Azure Data Factory

SQL Server

Oracle PL/SQL

SSIS/SSRS

DAX/MDX

Mainframe/Legacy data

PBCS/EPM Automate

Azure DevOps

Git/GitHub

Python

JSON

Education

Bachelor's degree in Computer Science/Information Systems/Data Science/Engineering

Tools

SSAS

Databricks

Azure Synapse

Oracle PBCS

Job description

Advancio Inc. in Downey, CA seeks a data engineer to move and transform data across a legacy-to-modern landscape, building BI pipelines with Power BI, Databricks, and Oracle integration.

Role involves designing dashboards, building Azure Data Factory and Databricks pipelines, tuning SQL queries, and modeling data with DAX/MDX across Power BI, SSAS, and Azure Synapse. Strong collaboration and knowledge transfer are required.