> Markdown version of [/jobs/ext/1327734-senior-power-bi-data-architect](https://www.wearedevelopers.com/jobs/ext/1327734-senior-power-bi-data-architect). 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). --- # Senior Power BI Data Architect - **Company:** Essent Guaranty, Inc. - **Location:** Radnor, PA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Business Analytics Applications, Microsoft Azure, Cloud Database, Cloud Engineering, Information Systems, Databases, Data Architecture, Data Auditing, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Systems, Data Warehousing, Relational Databases, Github, IBM Cognos Business Intelligence, PostgreSQL, Meta-Data Management, Microsoft SQL Server, MySQL, Oracle (Applications), Query Optimization, Power BI, Git, Powerquery, Information Technology, Data Lineage, Collibra, Data Analytics, Software Version Control, Amazon Redshift - **Published:** July 18, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=1b04eecb0db1a644 ## About the Role * Bachelor's or Master's degree in computer science, Information Systems, Data Analytics, or a related discipline (or equivalent practical experience) * 5+ years of experience in BI architecture and data engineering, with 10+ years of overall IT experience * Expert-level proficiency in Power BI, including DAX, Power Query, advanced data modeling techniques, and Fabric Capacities * Expert-level proficiency in relational databases and SQL, including Oracle, Postgresql, MySQL, SQL Server, and Redshift * Expert-level proficiency in AWS Cloud Architecture, Services, and RDS databases * Experience with Data Governance tools like Informatica IDMC Cloud Data Catalog and Governance * Strong understanding of cloud-based data warehousing, analytics platforms, and ETL/ELT processes * Proven experience designing and managing large-scale self-service Semantic Models for diverse business user communities * Excellent analytical, problem-solving, and troubleshooting skills * Strong oral and written communication skills, with the ability to engage effectively with both business and technical stakeholders * Demonstrated ability to collaborate across cross-functional teams in complex enterprise environments * Experience with Power BI Source Control and CI/CD Pipeline deployments using Git Repos and Azure DevOps or GitHub * Experience in IBM Cognos architecture and report development a plus * Experience with Vibe Coding IDEs like AWS Kiro ## Description The Senior Power BI Data Architect is responsible for designing and implementing enterprise-scale analytics solutions that support the organization's data and analytics strategy. This role focuses on developing scalable, secure, and high-performing Power BI self-service semantic models, leveraging a Kimball Bus Architecture data warehouse built on AWS Redshift. This position combines deep technical expertise with strong leadership and collaboration skills to establish and promote best practices in data modeling, governance, and reporting. The Sr. Power BI Data Architect partners with cross-functional stakeholders to ensure data solutions are aligned with business needs, enabling consistent, reliable, and accessible analytics that drive data-informed decision-making across the organization. As a dynamic and resourceful professional, we will rely on you to perform the following duties: * Architect, design, and develop scalable, enterprise-grade Semantic Models for self-service Power BI analytics. * Work extensively with Data Architects and ETL Team to ingest, transform, and prepare large and complex Semantic Models for analytics consumption. * Implement and manage data governance, access controls, and security policies. * Collaborate closely with business stakeholders to understand analytical requirements and translate them into effective BI and reporting solutions. * Ensure optimal Power BI report and dataset performance through efficient data modeling, DAX optimization, and query tuning best practices. * Monitor Workspaces and Fabric Capacities to ensure solutions are efficient and performant. * Troubleshoot Reports and Dashboards that don't render quickly. * Establish and enforce standards, guidelines, and best practices for Power BI development across the organization. * Lead initiatives around metadata management, data lineage, documentation, and data quality assurance. * Provide technical leadership and mentorship to IT Staff and Business Users. * Support enterprise reporting strategies, ensuring scalability, reliability, and consistency across analytics platforms. * Perform other duties as assigned by management. ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)