Senior BI Developer and Data Engineer

Who We AreProvoke 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.OverviewWe are seeking a Senior Data Engineer and BI Developer to own the client data platform end to end, from raw source ingestion through the curated data models that power reporting. This is a hands-on, engineering-first role. The core of the work is building and operating ingestion pipelines and medallion-layer transformations in Microsoft Fabric. Report development in Power BI is part of the role, but it is secondary to the data engineering responsibilities. We are looking for versatile problem solvers who thrive in a fast-paced, collaborative, client-focused environment.Key ResponsibilitiesData EngineeringBuilds and maintains ingestion pipelines that bring data from sources such as DynamoDB, InfluxDB, and S3 into Microsoft FabricDesigns and builds Bronze, Silver, and Gold transformations, including incremental processing, change data capture, and schema evolutionWorks with semi-structured data such as DynamoDB documents, flattening and modeling it for reliable downstream useDesigns the Gold layer using dimensional modeling to build enterprise-ready datasets, and tunes pipeline and query performanceWrites and troubleshoots T-SQL and PySpark transformations, enforces data quality, and diagnoses data issues back to their sourceOwns 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 resolutionBuilds automated data quality validation, reconciliation, and monitoring, with alerting and observability across the pipelines to keep the production platform reliableReporting & DashboardsDesigns 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 testingConfigures and supports Power BI reports embedded in SharePoint Online with Entra ID token passthroughSecurity & GovernanceImplements Row-Level Security via Entra ID and documents data flows and KPI definitions for governanceAuthors operational runbooks and as-built documentation for deployment, RLS validation, and handoffStakeholder ManagementTranslates client business requirements into data models and report designs, and supports backlog triage and estimationActs as a trusted technical advisor to client stakeholders, explaining complex data and reporting issues in plain, non-technical languageOperates within client-controlled environments and approval gates, and adapts to each client's tools and processesProduces client-ready deliverables and leads knowledge transfer so client teams can operate and support the solution once handed overRequired Skills & ExperienceBachelor's degree in computer science, business, or related field preferred; equivalent experience considered4+ 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 Fabric2+ years of Power BI development desired, including advanced data modeling and DAXStrong PySpark and SQL skills; experience with medallion architecture and Delta LakeWorking knowledge of cloud-native data services (streaming, serverless compute, object storage)Experience with RLS/CLS design and Entra ID-based security modelsStrong communication skills and ability to lead through influence; experience with Jira and Agile/SCRUM methodologyDesirable QualificationsExperience with AWS services such as S3, DynamoDB, Lambda, and Firehose, and with event-driven ingestionFamiliarity with SharePoint, Microsoft Entra ID, and external partner reportingMicrosoft certifications: DP-600, DP-203, or equivalentExperience with Power BI CI/CD and deployment pipelinesBackground in regulated industries (for example: healthcare, telecom, finance)Working HoursUS time zone alignment with PT. Flexibility to accommodate client schedules is part of the role.LocationUS. Travel 25-50% required.Role Type & Work AuthorizationThis role is offered as W2 hourly employment. Candidates must be authorized to work in the U.S. without VISA sponsorship.Direct applicants only. No agencies, recruiters, or third-party submissions.To be considered, you must apply through this job posting.Please do not contact our CEO or team members directly regarding this opportunity. Applications submitted outside of our hiring process will not be considered.