Senior Power BI Data Architect Enterprise Analytics Leader

Page Mechanical Group, Inc.; Radnor (Delaware County); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

paid time off

medical

dental

vision

401(k)

disability benefits

Job summary

Essent Group Ltd. in Radnor, PA seeks a Senior Power BI Data Architect to design and deliver enterprise-scale analytics, focusing on scalable semantic models and secure, high-performance BI solutions built on a Kimball-style data warehouse on AWS Redshift.

You will lead cross-functional collaboration, enforce BI development standards, and mentor IT staff and business users while ensuring analytics align with business needs and governance policies.

Qualifications

• 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

Responsibilities

• 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.

Skills

Power BI

DAX

Power Query

Data modeling

SQL

AWS

Data governance

CI/CD

Git

IBM Cognos

AWS Kiro

Education

Bachelor’s or Master’s in CS/IS/Data Analytics

Equivalent practical experience

Tools

Fabric Capacities

Informatica IDMC Cloud Data Catalog

Job description

Essent Group Ltd. in Radnor, PA seeks a Senior Power BI Data Architect to design and deliver enterprise-scale analytics, focusing on scalable semantic models and secure, high-performance BI solutions built on a Kimball-style data warehouse on AWS Redshift.

You will lead cross-functional collaboration, enforce BI development standards, and mentor IT staff and business users while ensuring analytics align with business needs and governance policies.