Job Detail

Job Title: Power BI expert and Azure Data Engineer

Location: San Ramon ,CA

Visa: No OPT/CPT

Years of experience: 7-9  years

Locals prefered

USC/GC and H1B must have reason to 

relocate

Job description:

Power BI Expert with 1.5+ years’ experience in creating compelling dashboard reports using advanced Power BI and Data Analysis Expressions (DAX).

Deliverables:

· Design and develop of reporting data module for CPF Plant Turnaround Analytics

· Creating Row level security with Power BI and integration with Power BI service portal

· Develop Materials Management reports to determine PR/PO reconciliation of outstanding line items

· Work on all types of transformations that are available in Azure Analysis Service and Power BI query editor

· Schedule automatic refresh and scheduling refresh in Power BI service

· Develop event-drive analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions

· Create custom visualization for Power BI, if needed

· Create reports using time intelligence calculations and functions

· Execute dashboard setups and data manipulation using DAX

Azure Data Engineer with 2+ years’ experience in consulting on data factory pipeline and transformation services

Deliverables:

· Data engineer Azure data flows for CPF Plant Turnaround Analytics using Azure services: Data Factory, Databricks, Functions, Logic Apps

· Implement row level security in Azure SQL DB and Azure Analysis Services

· Implement CI/CD via Azure DevOps

· Ingest data into a data lake from an Azure Service Bus

· Create Databricks jobs to operationalize data flows

· Schedule automatic refresh and scheduling refresh of AAS models

· Write Ansible playbooks to deploy into Azure resources