Power BI & Data Analytics Lead

Essent Guaranty, Inc.
Radnor, PA, United States
24 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Working hours
Regular working hours
Job source

Tech stack

Business Analytics Applications Data Analysis Business Logic Data Cleansing Information Engineering Data Integrity IBM Cognos Business Intelligence Performance Tuning Power BI SQL Databases User-Centered Design Backend
+7 more
Powerquery Data Analytics Star Schema Data Management Tools for Reporting Software Version Control Data Pipelines

Job description

The Power BI & Data Analytics Lead is responsible for designing, building, and stewarding enterprise analytics solutions that span Power BI, semantic modeling, and upstream data preparation. This role serves as a senior individual contributor and technical lead, operating across the full analytics stack-from backend data shaping and performance optimization to executive-facing dashboards and governed self-service reporting. The role partners closely with Operations, IT, and Data Management to translate business requirements into accurate, scalable, and sustainable analytics assets, while guiding architectural decisions, resolving complex data issues, and ensuring trust in enterprise reporting. This position plays a key role in analytics modernization efforts, including migration from legacy reporting tools and enablement of standardized, reusable data models., * Design and steward enterprise Power BI semantic models that centralize business logic, calculations, and KPIs to establish a single source of truth.

  • Define and enforce standards for metric definitions, calculations, and reuse, preventing duplication and reconciliation discrepancies across reports.
  • Collaborate with Data Management and IT teams on data sourcing, transformation, and schema design, including SQL-based preparation and star schema alignment.
  • Evaluate and determine where logic should reside (source systems, data products, Power Query, or semantic models) to improve performance, maintainability, and scalability.

Enterprise Analytics & Power BI Solution Ownership

  • Lead the end-to-end design, development, and support of Power BI analytics solutions, including shared semantic models, dashboards, and Power BI apps used across multiple business domains.
  • Ensure analytics solutions meet executive, operational, and regulatory reporting needs with a focus on accuracy, consistency, and usability.
  • Support and apply analytics governance practices, including workspace strategy, environment promotion (Dev/Test/Prod), access controls, documentation, and ownership models.
  • Contribute to enterprise discussions on version control, change management, and analytics lifecycle management to enable sustainable growth.

Business Partnership & Analytics Leadership

  • Contribute to the broader transition from Cognos to Power BI, supporting enterprise analytics modernization.
  • Translate business priorities and leadership questions into clear analytics requirements and technical designs, providing guidance on feasibility, risk, and trade-offs.
  • Act as a trusted analytics advisor, communicating technical decisions and data insights in business-focused language to non-technical and executive stakeholders.
  • Mentor and guide analysts and developers, promoting best practices across Power BI and enterprise analytics.

Performance Optimization, Complex Issue Resolution & Standards

  • Diagnose and resolve complex performance, refresh, and reconciliation issues across Power BI models and backend data sources.
  • Make informed architectural decisions regarding storage modes, query patterns, and data volume constraints, balancing performance with data integrity.
  • Support and apply analytics governance practices, including workspace strategy, environment promotion (Dev/Test/Prod), access controls, documentation, and ownership models.
  • Contribute to enterprise discussions on version control, change management, and analytics lifecycle management to enable sustainable growth.
  • Perform other duties as assigned.

Requirements

  • Bachelor’s degree required
  • 5-8 years’ of direct Power BI / enterprise analytics experience
  • 3-5 years’ operating at a lead / senior-individual-contributor level influencing architecture, standards, and cross-functional outcomes
  • Demonstrated ability to design, deliver, and steward enterprise analytics solutions that support executive decision-making, operational performance management, and regulated business processes
  • Strong expertise in Power BI architecture, including semantic models, datasets, reports, apps, storage modes, and workspace/environment design
  • Proven capability to define and govern enterprise metrics and KPIs, ensuring accuracy, consistency, reconciliation, and long-term trust in reporting
  • Working knowledge of data engineering and backend data concepts, including SQL-based transformations, star schema design, and upstream data dependencies
  • Ability to evaluate and implement analytics logic across the stack (data sources, transformations, semantic models), balancing performance, scalability, and maintainability
  • Demonstrated skill in diagnosing and resolving complex data, performance, and reconciliation issues across analytics and data pipelines
  • Strong ability to translate business requirements and leadership priorities into governed, scalable analytics solutions
  • Experience applying analytics governance and lifecycle practices, including promotion paths, access controls, documentation, and ownership standards
  • Ability to collaborate effectively across Operations, IT, Data Engineering, and Program teams to deliver shared enterprise outcomes
  • Strong communication skills, with the ability to explain technical concepts, risks, and design trade-offs in clear, business-focused language
  • Ability to prioritize analytics and data work based on business impact, risk exposure, and sustainability, not just delivery speed
  • Capability to support enterprise analytics modernization initiatives, including migration from legacy reporting tools and enablement of self-service analytics

Benefits & conditions

Pulled from the full job description

  • 401(k)
  • Health insurance
  • Paid time off
  • Vision insurance
  • Dental insurance, Our commitment to your success is enhanced by our competitive salary and comprehensive benefits package including paid time off, medical, dental, vision, 401(k) and disability benefits. We work to maintain a positive environment for our employees, where people can learn and grow with the company. Essent is an Equal Opportunity Employer.

About the company

Essent Group Ltd. (NYSE: ESNT) is a Bermuda-based holding company (collectively with its subsidiaries, ā€œEssentā€) which serves the housing finance industry by offering private mortgage insurance, reinsurance, risk management products and title insurance and settlement services to mortgage lenders, borrowers, and investors to support homeownership. We are focused on managing risk and dedicated to serving as a strong and fair counterparty. As a company, we bring strong private capital and a commitment to risk management to the mortgage insurance industry.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:52 min

Structuring and scaling the backend engineering team

Stefan Lingler Stefan Lingler +1 Ā· Coffee With Developers

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 Ā· WWC 2025

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou Ā· Coffee With Developers

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader Ā· WWC Europe 2026

1:42 min

Combining technical skills with strong business communication

Lukas Kölbl · LIVE

1:12 min

Choosing TypeScript for complex backend applications

Maximilian Otto Maximilian Otto Ā· WWC 2024

Videos

See all

Related articles

See all