Senior Power BI & Data Engineering Consultant

Emeryville, CA, US • Posted 4 days ago • Updated 28 minutes ago

Full Time

Part Time

On-site

Fitment

Dice Job Match Score™

🫥 Flibbertigibetting...

Job Details

Skills

Data Engineering
Management
Roadmaps
Data Cleansing
SQL
Decision-making
Scalability
Data Storage
Analytics
Microsoft SQL Server
Microsoft Power BI
Data Modeling
DAX
Dashboard
Microsoft SSIS
Extract
Transform
Load
Data Integration
MongoDB
Amazon Web Services
Microsoft Azure
Cloud Computing
Requirements Elicitation
Documentation
Data Architecture
ODS
Reporting
Data Governance
Performance Tuning
Analytical Skill
Problem Solving
Conflict Resolution
Soft Skills
Communication
Stakeholder Management
Collaboration

Summary

Job Title: Senior Power BI & Data Engineering Consultant

Location: Emeryville, California

Work Mode: Onsite

Employment Type: Contract

Role Overview

We are seeking a Senior Power BI & Data Engineering Consultant with strong expertise in SQL-based data engineering, Power BI reporting, cloud platforms (AWS/Azure), and data architecture. This role requires a blend of hands-on development, requirements gathering, and stakeholder-facing consulting skills to deliver high-quality reporting and analytics solutions.

Key Responsibilities

Lead and deliver Power BI reporting and dashboarding projects end-to-end.
Gather, analyze, and document business, reporting, and data requirements.
Design and manage ODS (Operational Data Store) planning, reporting structures, and data models.
Define Power BI project roadmaps, reporting timelines, and data delivery plans.
Analyze raw data and perform data cleansing, transformation, and processing using MS SQL.
Build and maintain SSIS-based ETL pipelines.
Retrieve, aggregate, and integrate data from multiple sources, including MongoDB.
Enable data-driven decision-making by transforming complex datasets into actionable insights.
Apply data architecture best practices to ensure scalability, performance, and reliability.
Work with AWS and/or Azure cloud services for data storage, processing, and analytics.
Collaborate closely with business users, product owners, and technical teams.

Mandatory Skills

Strong hands-on experience with MS SQL Server
Advanced expertise in Power BI (data modeling, DAX, dashboards, reports)
Experience with SSIS for ETL and data integration
Working knowledge of MongoDB
Experience with AWS and/or Azure cloud services
Strong requirements gathering and documentation skills
Solid data architecture and reporting framework knowledge

Good-to-Have Skills

Experience with enterprise ODS and reporting environments
Exposure to data governance and performance optimization
Strong analytical and problem-solving skills

Soft Skills

Excellent communication and stakeholder management skills
Ability to translate business needs into technical solutions
Strong collaboration skills in cross-functional environments

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91018020
Position Id: PDT - 10108-11243-1767966647
Posted 4 days ago

Company Info

About Purple Drive Technologies LLC

Founded in 2007, Purple Drive started as a tech solutions firm and has grown into a full-service consulting and talent partner. We help businesses navigate complex technology challenges while connecting top professionals with career-defining opportunities.

We believe in transforming businesses through smart IT solutions and empowering technologists to grow their expertise through challenging projects and meaningful partnerships. Built on over 20 years of trusted relationships, we create success stories for both our clients and the talented professionals who drive innovation forward.

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.