Senior BI/Data Architect & Data Engineering Consultant

Senior BI/Data Architect & Data Engineering Consultant

CXC Downey, CA

We are seeking a Senior Consultant – BI / Databricks to support enterprise-level data, reporting, and analytics initiatives. This role is ideal for a highly experienced professional with expertise in Power BI, Azure Databricks, Data Warehousing, and Azure Cloud technologies.

Title: Senior BI/Data Architect & Data Engineering Consultant

Location: Downey, CA (Remote- Candidate must reside in CA)

Duration: Contract 12–24+ Months

Key Responsibilities

Design, develop, and support Power BI dashboards, reports, and paginated reports.

Build and maintain data pipelines using Azure Data Factory and Azure Databricks.

Design and optimize data warehouse solutions using SQL Server and Oracle.

Develop data models using DAX, MDX, SSAS, Databricks, and Azure Synapse.

Implement Row-Level Security (RLS) and Object-Level Security (OLS) in Power BI.

Perform SQL query development, debugging, and performance tuning.

Collaborate with business and technical teams to deliver scalable enterprise solutions.

Support DevOps, CI/CD, and source control processes using Azure DevOps and Git.

Required Qualifications

7+ years of Enterprise Architecture experience, including 5+ years in a lead capacity.

5+ years of Power BI and Azure environment experience.

3+ years of Azure Databricks and Data Warehouse experience.

Strong expertise in Power BI, SQL Server, Oracle, Azure Data Factory, Azure Databricks, and Azure Synapse.

Experience with DAX, MDX, RLS/OLS, SSIS, SSRS, and Azure DevOps.

Knowledge of Agile methodologies, CI/CD, and software development practices.

Bachelor's degree in IT, Engineering, or a related field (or equivalent experience).

If you're open to exploring new opportunities, I'd be happy to share additional details.

Please reply with:

Your updated resume

Current location

Work authorization status

Best contact number

Looking forward to connecting.