Senior BI Developer & Data Engineer

Provoke Solutions; Denver (CO); On-site; USD 86,000 - 110,000; Full time

Job summary

Provoke Solutions is hiring a Senior Data Engineer and BI Developer to own a client data platform from source ingestion through reporting models.

You will build data pipelines, design gold-layer datasets, and develop Power BI reports using Fabric. This role emphasizes engineering rigor and client collaboration, with 25–50% travel and Pacific Time alignment.

Qualifications

• Bachelor's degree in computer science, business, or a related field preferred; equivalent experience may be considered.
• 4+ years of data engineering experience with Fabric or Azure Synapse/Databricks environment and ramp-up on Fabric.
• 2+ years of Power BI development; advanced data modeling and DAX.
• Strong PySpark and SQL skills with Delta Lake.
• Experience with cloud-native data services and streaming, serverless compute, object storage.
• Experience designing RLS/CLS and Entra ID-based security models.
• Strong communication and influence, Jira and Agile/SCRUM.
• U.S. work authorization without visa sponsorship.
• Willingness to travel 25–50%.
• Preferred: AWS services (S3, DynamoDB, Lambda, Firehose) and event-driven ingestion.
• Preferred: SharePoint, Entra ID, external partner reporting.
• Preferred: Microsoft DP-600/DP-203 certificates.
• Preferred: Power BI CI/CD and deployment pipelines.
• Preferred: background in regulated industries.

Responsibilities

• Build and maintain pipelines ingesting data from DynamoDB, InfluxDB, and S3 into Microsoft Fabric.
• Create Bronze, Silver, and Gold transformations with incremental processing, CDC, and schema evolution.
• Flatten and model semi-structured data for reliable downstream use.
• Design dimensional models for enterprise Gold-layer datasets and optimize performance.
• Develop and troubleshoot T-SQL and PySpark transformations; enforce data quality.
• Operate the production data platform end to end and troubleshoot AWS/Fabric issues.
• Implement automated data-quality validation, reconciliation, monitoring, and observability.
• Develop and deploy Power BI reports using Fabric Gold-layer data; create DAX measures.
• Configure Power BI reports embedded in SharePoint Online with Entra ID passthrough.
• Implement Entra ID-based RLS and document data flows for governance.
• Prepare runbooks and as-built docs for deployment and handoff.
• Translate client requirements into data models and dashboards; assist backlog.
• Advise client stakeholders and explain complex data issues clearly.
• Work in client-controlled environments and adapt to clients’ tools and procedures.
• Produce client-ready deliverables and lead knowledge transfer after handoff.

Skills

Power BI

PySpark

SQL

DAX

Jira

Agile/SCRUM

Data modeling

Fabric

Azure Synapse

Security (RLS/CLS)

Entra ID

CI/CD

SharePoint

DynamoDB

S3

Delta Lake

Education

Bachelor's degree in CS or related field

Equivalent experience considered

Tools

AWS

SharePoint

Entra ID

Microsoft Fabric

Job description

Salary: $86,000 - 110,000 per year

Requirements:

• Bachelors degree in computer science, business, or a related field preferred; equivalent experience may be considered
• At least 4 years of data engineering experience, including hands‑on work with Microsoft Fabric or an equivalent Azure Synapse/Databricks environment and the ability to ramp up quickly on Fabric
• 2 or more years of Power BI development preferred, including advanced data modeling and DAX
• Strong PySpark and SQL skills, with experience in medallion architecture and Delta Lake
• Working knowledge of cloud‑native data services, such as streaming, serverless compute, and object storage
• Experience designing Row‑Level Security (RLS)/Column‑Level Security (CLS) and Entra ID‑based security models
• Strong communication skills and the ability to lead through influence; experience with Jira and Agile/SCRUM
• U.S. work authorization without visa sponsorship
• Willingness to travel 25–50%
• Preferred: Experience with AWS services such as S3, DynamoDB, Lambda, and Firehose, and with event‑driven ingestion
• Preferred: Familiarity with SharePoint, Microsoft Entra ID, and external partner reporting
• Preferred: Microsoft certification such as DP‑600, DP‑203, or equivalent
• Preferred: Experience with Power BI CI/CD and deployment pipelines
• Preferred: Background in a regulated industry, such as healthcare, telecommunications, or finance

Responsibilities:

• Build and maintain pipelines that ingest data from sources such as DynamoDB, InfluxDB, and S3 into Microsoft Fabric
• Create Bronze, Silver, and Gold transformations, including incremental processing, change data capture, and schema evolution
• Flatten and model semi‑structured data, including DynamoDB documents, for reliable downstream use
• Design dimensional models for enterprise‑ready Gold‑layer datasets and optimize pipeline and query performance
• Develop and troubleshoot T‑SQL and PySpark transformations, enforce data quality, and trace data issues to their source
• Operate the production data platform end to end, troubleshoot across AWS ingestion services and Fabric, identify root causes, and resolve issues
• Implement automated data‑quality validation, reconciliation, monitoring, alerting, and pipeline observability
• Develop and deploy Power BI reports using Fabric Gold‑layer data, create DAX measures for enterprise KPIs, and manage the reporting lifecycle from requirements through end‑user testing
• Configure and support Power BI reports embedded in SharePoint Online with Entra ID token passthrough
• Implement Entra ID‑based Row‑Level Security and document data flows and KPI definitions for governance
• Prepare operational runbooks and as‑built documentation for deployment, RLS validation, and handoff
• Translate client business requirements into data models and report designs, and support backlog triage and estimation
• Advise client stakeholders on technical matters and explain complex data and reporting issues in accessible, non‑technical language
• Work within client‑controlled environments and approval processes, adapting to each clients tools and procedures
• Produce client‑ready deliverables and lead knowledge transfer so client teams can operate and support the solution after handoff

Technologies:

• Agentic AI
• AI
• AWS
• Lambda
• Azure
• CI/CD
• Cloud
• Databricks
• DAX
• Embedded
• Fabric
• Support
• JIRA
• Power BI
• PySpark
• SQL
• Security
• Serverless
• SharePoint

More:

We are Provoke, a global consulting firm that builds AI-native solutions to transform how work gets done. Our culture values innovation, growth, and curiosity, and we partner with global clients to design and deploy agentic AI within their workflows. We are hiring a Senior Data Engineer and BI Developer for a hands‑on, engineering‑first role owning a client data platform from source ingestion through reporting models; Power BI development is part of the work but secondary to data engineering. Were looking for adaptable problem solvers who thrive in fast‑paced, collaborative, client‑focused settings. The role is based in the U.S., requires alignment with Pacific Time and flexibility for client schedules, and involves 25–50% travel. Employment is W‑2 hourly. last updated 41 week of 2026