Senior BI Developer and Data Engineer

Provoke Solutions; United States; On-site; USD 96,432 - 151,536; Part time

Job summary

Provoke is seeking a Senior BI Developer and Data Engineer to own end-to-end client reporting engagements, from ingestion to dashboards, using Microsoft Fabric and Power BI. This hands-on role demands strong data engineering and reporting skills, with a client-focused, collaborative mindset.

The successful candidate will work in the US Time Zone, travel up to 50%, and operate as a W2 hourly employee. Provoke values innovation, growth, and curiosity, and emphasizes practical data-driven solutions

Qualifications

• Bachelor's degree in computer science, business, or related field; equivalent experience considered.
• 4+ years of data engineering with 1.5 years of Microsoft Fabric or comparable Synapse/Databricks.
• 4+ years of Power BI development with advanced data modeling and DAX.
• Strong PySpark and SQL skills; experience with medallion architecture and Delta Lake.
• Experience with cloud-native data services and Entra ID security models.
• Strong communication and ability to lead through influence; Jira and SCRUM experience.
• Ability to explain complex data issues to non-technical stakeholders.

Responsibilities

• Builds and maintains Fabric pipelines, Lakehouse/warehouse objects, and PySpark notebooks across Bronze, Silver, and Gold layers.
• Writes and troubleshoots T-SQL and PySpark transformations; diagnoses data quality issues.
• Resolves production data incidents across AWS ingestion, Fabric, Power BI, and SharePoint.
• Designs and deploys Power BI reports; writes DAX measures; manages the report lifecycle.
• Implements Row-Level Security and documents data flows for governance.
• Authors runbooks and deployment docs for RLS validation and handoff.
• Translates client requirements into data models and report designs; supports backlog estimation.

Skills

Power BI development

PySpark

SQL

DAX

Data modeling

Entra ID security concepts

Stakeholder management

Communication

SCRUM

Education

Bachelor's degree in CS/related field

Tools

Power BI

Microsoft Fabric

Synapse/Databricks

Jira

Delta Lake

Entra ID

Job description

Provoke is a global consulting firm building AI-native solutions that transform how work gets done. Founded on a culture of innovation, growth, and curiosity, we partner with global clients to design and deploy agentic AI embedded directly into workflows so teams move faster, think smarter, and scale with purpose.

Overview

We're seeking a Senior BI Developer and Data Engineer to own end-to-end delivery on client reporting engagements, from raw data ingestion through the dashboards end users see. This hands-on role spans Microsoft Fabric data engineering and Power BI report development. We're looking for versatile problem solvers who thrive in a fast-paced, collaborative environment and are client-focused.

Key Responsibilities

• Builds and maintains Fabric pipelines, Lakehouse/Warehouse objects, and PySpark notebooks across Bronze, Silver, and Gold layers
• Writes and troubleshoots T-SQL and PySpark transformations, and diagnoses data quality issues back to their source
• Diagnoses and resolves production data incidents end to end, tracing failures across the AWS ingestion path (DynamoDB Streams, Lambda, Firehose, S3), Fabric, Power BI, and SharePoint back to their root cause
• Designs and deploys Power BI reports from Fabric Gold-layer data, writes DAX measures for enterprise KPIs, and owns the report lifecycle from requirements through end-user testing
• Configures and supports Power BI reports embedded in SharePoint Online with Entra ID token passthrough

Security & Governance

• Implements Row-Level Security via Entra ID, and documents data flows and KPI definitions for governance and documentation
• Authors operational runbooks and as-built documentation for deployment, RLS validation, and handoff

Stakeholder Management

• Translates client business requirements into data models and report designs, and supports backlog triage and estimation

Required Skills & Experience

• Bachelor's degree in computer science, business, or related field preferred; equivalent experience considered
• 4+ years of data engineering experience with 1.5 years of Microsoft Fabric (Lakehouse, Warehouse, pipelines, Notebooks, OneLake) or comparable Synapse/Databricks environment
• 4+ years of Power BI development, including advanced data modeling and DAX
• Strong PySpark and SQL skills; experience with medallion architecture and Delta Lake
• Working knowledge of cloud-native data services (streaming, serverless compute, object storage)
• Experience with RLS/CLS design and Entra ID-based security models
• Strong communication skills and ability to lead through influence; experience with Jira and SCRUM
• Act as a trusted technical advisor to client stakeholders, explaining complex data and reporting issues in plain, non-technical language
• Operates within client-controlled environments and approval gates, and adapts to each client's tools and processes
• Produces client-ready deliverables and leads knowledge transfer so client teams can operate and support the solution once handed over

Desirable Qualifications

• Microsoft certifications: DP-600, DP-203, or equivalent
• Experience with Power BI CI/CD and deployment pipelines
• Background in regulated industries (healthcare, telecom, finance)

Working Hours

US time zone alignment with PT. Flexibility to accommodate client schedules is part of the role.

Location

US. Travel 25-50% required.

Role Type & Work Authorization

This role is offered as W2 hourly employment. Candidates must be authorized to work in the U.S. without VISA sponsorship.

No agencies, please. We're conducting this search internally and are not partnering with external recruiting agencies for this role. We kindly ask that agencies refrain from contacting us regarding candidate submissions.