Senior Data Engineer

Microsoft Fabric Architect / Engineer (Remote) Location: Remote (U.S.) Pay Range: $70-$75/hour Duration: 3-Month Contract (Potential Extension) Schedule: Monday–Friday, 8:00 AM–4:30 PM MT Position Overview We are seeking an experienced Microsoft Fabric Architect / Engineer to support one of our enterprise public-sector clients's analytics modernization initiative. This consultant will partner with the Business Technologies Division to assess, design, implement, and optimize Microsoft Fabric capabilities while establishing scalable architecture, governance, and best practices across the enterprise. This is a hands-on technical consulting role requiring deep expertise across Microsoft Fabric, Power BI, modern data engineering, governance, and enterprise analytics. Responsibilities Microsoft Fabric Architecture • Assess and validate the organization's Microsoft Fabric architecture, including tenant configuration, workspaces, capacities, domains, OneLake, and Power BI integration. • Design scalable architecture for Lakehouses, Warehouses, semantic models, Direct Lake, Data Factory pipelines, and enterprise reporting. • Recommend best practices for enterprise analytics and data platform modernization. Data Engineering • Design and implement reusable ingestion, transformation, and orchestration patterns using: • Microsoft Fabric Data Factory • Dataflows Gen2 • Notebooks • Lakehouses • Warehouses • Develop medallion architecture (Bronze, Silver, Gold) where appropriate. • Support integration with enterprise applications, APIs, operational systems, Microsoft 365, Azure services, and file-based data sources. Governance & Administration • Define governance standards across Microsoft Fabric. • Configure and recommend: • Tenant settings • Workspace administration • Role-based security (RBAC) • Capacity administration • Sensitivity labels • Endorsements • Lineage • Microsoft Purview integration • Establish development, testing, and production environment standards. Performance & Capacity Optimization • Evaluate Fabric capacity sizing and workload placement. • Optimize refresh strategies, query performance, storage utilization, and cost management. • Design operational dashboards, monitoring, alerts, and runbooks to support ongoing platform management. DevOps & Deployment • Establish source control and deployment best practices. • Design release management and environment promotion processes. • Define naming conventions, documentation standards, and repeatable deployment patterns for: • Semantic Models • Reports • Pipelines • Notebooks • Lakehouses • Warehouses • Shared Datasets Knowledge Transfer • Conduct technical workshops and working sessions with internal teams. • Produce architecture documentation, implementation standards, governance recommendations, and operational procedures. • Present findings, recommendations, risks, and next steps to technical stakeholders. Required Qualifications • 5+ years of experience designing and implementing Microsoft data and analytics platforms. • Hands-on experience with Microsoft Fabric in enterprise environments. • Strong experience with: • Microsoft Fabric • Power BI • OneLake • Lakehouse • Warehouse • Fabric Data Factory or Azure Data Factory • Semantic Models • Direct Lake • Experience designing enterprise data architectures. • Strong SQL skills and experience building scalable data pipelines. • Experience implementing governance, security, and deployment standards. • Experience with Git-based source control and CI/CD practices. • Excellent communication and documentation skills. Preferred Qualifications • Experience with Azure Synapse Analytics. • Experience with Microsoft Purview. • Experience with Delta Lake, Spark, or PySpark. • Experience implementing enterprise data governance frameworks. • Microsoft Fabric or Microsoft Azure certifications. • Previous consulting experience delivering architecture assessments and implementation roadmaps. Deliverables The selected consultant will help deliver: • Microsoft Fabric Technical Assessment • Enterprise Reference Architecture • Implementation Roadmap • Governance & Operating Standards • Proof of Concept or Prototype • Knowledge Transfer Documentation • Final Executive Presentation Ideal Candidate We're looking for a senior consultant who combines architecture expertise with hands-on engineering experience. The ideal candidate has successfully implemented Microsoft Fabric in enterprise environments, understands modern data platform design, and can establish governance, scalability, and best practices while mentoring internal teams. EEO Statement: Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Pay Disclaimer: The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law. Benefits & Perks: Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, and sick time. Paid company holidays are subject to hour requirements and completion of the new hire period (13 weeks). We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.