> Markdown version of [/jobs/ext/1921073-bi-infrastructure-engineer](https://www.wearedevelopers.com/jobs/ext/1921073-bi-infrastructure-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # BI Infrastructure Engineer - **Company:** Ancora Education - **Location:** United States (Remote available) - **Salary:** $75,000.0 - $85,000.0 - **Contract:** Permanent contract - **Skills:** Data Architecture, Data Governance, Data Infrastructure, Data Transformation, Python (Programming Language), Microsoft SQL Server, Query Optimization, Power BI, Student Information Systems, SQL Stored Procedures, SQL Databases, Azure Data Factory, Data Layers, Build Management, Microsoft Fabric, Data Lakes, Pyspark, Data Pipelines - **Published:** August 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=0d7c7050ac27a050 ## About the Role * Hands-on experience with Microsoft Fabric, including Lakehouses, Delta Lake, and OneLake. * Proficiency in SQL - complex joins, CTEs, window functions, and query optimization. * Experience building and maintaining Azure Data Factory pipelines. * Familiarity with Medallion Architecture (Bronze, Silver, and Gold layers). * Power BI experience, including semantic model design and DAX measure development. * Ability to communicate technical concepts clearly to non-technical audiences. * Comfort working independently in a small team environment with minimal supervision. * Strong attention to data quality and validation. Experience and Education Preferred * Experience with Python or PySpark for data transformation. * Microsoft certifications such as PL-300, DP-700, or AZ-900. * Experience with SQL Server, including stored procedures, views, and replication. * Familiarity with Direct Lake mode in Power BI semantic models. * Experience with incremental load patterns and watermark-based pipeline strategies. * Prior work in education, nonprofit, or mission-driven organizations. ## Description Reporting to the Data Architect, the BI Infrastructure Engineer is a core contributor to the modern analytics ecosystem Ancora Education is building on Microsoft Fabric. This is a ground-floor opportunity to help design, build, and maintain the pipelines, lakehouses, and semantic models that power reporting and analytics across the entire organization. Rather than maintaining existing systems, this role helps shape an ecosystem that is being built now, making decisions that will influence how data is used at Ancora for years to come. The BI Infrastructure Engineer also helps reporting staff transition to the new platform, translating complex technical concepts into clear, approachable guidance for non-technical users. The data infrastructure built in this role directly supports Ancora's mission. The BI Infrastructure Engineer must uphold the Ancora core values at all times., * Design and build data pipelines using Azure Data Factory to ingest data from the student information system into a Microsoft Fabric Lakehouse. * Develop and maintain Bronze and Gold layer Delta tables following Medallion Architecture principles. * Build and optimize Power BI semantic models, including relationships, DAX measures, and row-level security across multiple business domains. * Create denormalized SQL views on SQL Server to pre-stage data for Lakehouse ingestion. * Maintain and improve incremental load patterns using watermark-based pipeline strategies. * Collaborate with the Data Architect to design Gold layer table structures that support clean, maintainable reporting. * Assist in retraining reporting staff on Power BI and the new Fabric environment alongside the Data Architect. * Contribute to data governance standards, including naming conventions, documentation, and model design guidelines. * Support the future development of conversational AI agents built on top of the Fabric data layer. * Monitor pipeline health, troubleshoot failures, and maintain data quality across the Lakehouse. ## Related Videos - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)