Data Engineering & BI/Analytics
About this role
Role Summary Moves and transforms data across the County's legacy-to-modern data landscape: legacy mainframe/file-based data conversion into target systems, enterprise BI and reporting (Power BI, Databricks, SSRS/SSIS), and Oracle-based data warehousing and financial-systems integration. Reflects a County mid-migration — still operating legacy pipelines while building a modern BI layer. Expect continued growth in Databricks/modern-stack reqs. Core 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 Requirements Skills Required Power BI (Dashboards, Paginated Reports, Gateway, RLS/OLS); Azure Databricks; Azure Data Factory SQL Server / Oracle: T-SQL, PL/SQL, SSIS, SSRS DAX/MDX data modeling (SSAS, Databricks, Azure Synapse) Legacy/mainframe data formats, flat files, data dictionaries, ETL and reconciliation Oracle Planning & Budgeting Cloud Service (PBCS) / EPM Automate / Oracle Integration Cloud (for financial-systems variants) Azure DevOps, Git/GitHub, Python, JSON Experience Required 5+ years experience in Power BI and Azure environments (BI-focused roles), or 3+ years supporting field mapping/crosswalk/data validation during conversion (Data Engineer 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 Education / Training Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, or closely related field Additional qualifying experience may substitute for education on a year-for-year basis
Frequently Asked Questions
Is the salary disclosed for the Data Engineering & BI/Analytics position at advanc?
The salary for this Data Engineering & BI/Analytics role at advanc is not publicly listed. Click "Apply Now" to learn more about the compensation package on their official careers page.
Where is the Data Engineering & BI/Analytics position at advanc located?
This Data Engineering & BI/Analytics role at advanc is based in Downey, California, United States. The position is listed as on-site or hybrid. Check the full job description or apply directly to confirm the work arrangement.
Is the Data Engineering & BI/Analytics role at advanc full-time or part-time?
This is listed as a Full time position. It is posted as a Data Engineering & BI/Analytics role at advanc.
How do I apply for the Data Engineering & BI/Analytics position at advanc?
Click the "Apply Now" button on this page. You will be redirected to advanc's official application portal hosted on zohorecruit where you can submit your application directly.
When was the Data Engineering & BI/Analytics job at advanc posted?
This Data Engineering & BI/Analytics position at advanc was posted on Sep 25, 2026. Apply as soon as possible — early applications are often reviewed first.
Data Engineering & BI/Analytics
advanc
You'll be redirected to advanc's official application page on zohorecruit.