Senior BI Developer and Data Engineer

Provoke Solutions is hiring a Senior BI Developer and Data Engineer to own a client data platform from source ingestion through curated data models. The role focuses on building and operating Microsoft Fabric pipelines and transformations, with secondary responsibility for Power BI reporting, platform reliability, security, governance, and client collaboration.

Responsibilities:

• Builds and maintains ingestion pipelines that bring data from sources such as DynamoDB, InfluxDB, and S3 into Microsoft Fabric
• Designs and builds Bronze, Silver, and Gold transformations, including incremental processing, change data capture, and schema evolution
• Works with semi-structured data such as DynamoDB documents, flattening and modeling it for reliable downstream use
• Designs the Gold layer using dimensional modeling to build enterprise-ready datasets, and tunes pipeline and query performance
• Writes and troubleshoots T-SQL and PySpark transformations, enforces data quality, and diagnoses data issues back to their source
• Owns the data platform in production and troubleshoots issues end to end across both the AWS ingestion path (DynamoDB Streams, Lambda, Firehose, S3) and Fabric, tracing failures back to their root cause and driving them to resolution
• Builds automated data quality validation, reconciliation, and monitoring, with alerting and observability across the pipelines to keep the production platform reliable
• 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
• Implements Row-Level Security via Entra ID and documents data flows and KPI definitions for governance
• Authors operational runbooks and as-built documentation for deployment, RLS validation, and handoff
• Translates client business requirements into data models and report designs, and supports backlog triage and estimation
• Acts 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

Requirements:

• equivalent experience considered
• 4+ years of data engineering experience with hands-on experience with Microsoft Fabric or an equivalent Azure Synapse/Databricks environment with the ability to ramp up quickly on Fabric
• 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 Agile/SCRUM methodology
• Candidates must be authorized to work in the U.S. without VISA sponsorship
• Bachelor's degree in computer science, business, or related field preferred
• 2+ years of Power BI development desired, including advanced data modeling and DAX
• Experience with AWS services such as S3, DynamoDB, Lambda, and Firehose, and with event-driven ingestion
• Familiarity with SharePoint, Microsoft Entra ID, and external partner reporting
• Microsoft certifications: DP-600, DP-203, or equivalent
• Experience with Power BI CI/CD and deployment pipelines
• Background in regulated industries (for example: healthcare, telecom, finance)