Senior Power BI Developer - Mortgage Insurance

Essent; Radnor (Delaware County); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Paid time off

Medical benefits

Dental benefits

Vision benefits

401(k) and disability benefits

Job summary

Essent seeks a Senior Power BI Developer to lead design, development, and scaling of enterprise BI solutions. You will migrate from legacy Cognos/AWS QuickSight to Power BI, build robust semantic models, and optimize queries against Redshift while partnering with stakeholders to deliver high‑performance analytics.

The role requires 5+ years of Power BI and SQL experience, Cognos migration skills, and strong communication. On‑site at Radnor, PA with a comprehensive benefits package.

Qualifications

• Bachelor's degree or equivalent.
• 5+ years of end-to-end Power BI development (DAX, modeling, data gateway).
• 5+ years of advanced SQL with Amazon Redshift.
• Experience migrating from IBM Cognos to Power BI.
• Mortgage/financial industry experience preferred.
• Certification in PL-300 or AWS certified preferred.

Responsibilities

• Design, build, and deploy enterprise Power BI reports, dashboards, and paginated reports.
• Lead Cognos-to-Power BI migration with data parity and accuracy.
• Write optimized SQL queries against Redshift and transform data.
• Administer Power BI Service tenant, security, dataflows, and deployment pipelines.
• Mentor junior team members on advanced Power BI modeling and visualization.

Skills

Communication

Leadership

Mentoring

Analytical thinking

Time management

Education

Bachelor’s degree in Computer Science, Finance, Data Analytics, Information Systems, or related field

Microsoft Certified: PL-300 (Power BI Data Analyst) or AWS Certified Data Engineer/Cloud Practitioner

Tools

Power BI

SQL

IBM Cognos Analytics

Amazon Redshift

Azure DevOps / GitHub

Git Repos

Job description

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.

Title

Senior Power BI Developer

Location

Radnor, PA

Description

This is an individual contributor position which works under general supervision and leads the design, development, and scaling of enterprise Power BI capabilities. This role drives the modernization of business intelligence by leading the strategic migration from legacy reporting platforms (IBM Cognos/AWS QuickSight) to Power BI. The position is responsible for designing enterprise-grade dashboards, writing optimized queries against Amazon Redshift, constructing robust semantic models, and partnering with business stakeholders to translate complex financial data into interactive, high-performance analytics solutions.

Power BI Development & Architecture

• Design, build, and deploy enterprise-grade Power BI reports, interactive dashboards, and paginated reports mapped to executive-level metrics.
• Construct robust semantic models and write complex, optimized DAX calculations and advanced Power Query (M) scripts.
• Administer the Power BI Service tenant environment, managing workspaces, security (RLS/OLS), dataflows, fabric capacities, and automated deployment pipelines.
• Administer Source Control and DevOps pipelines for code deployment.

Cognos-to-Power BI Migration & Support

• Lead the active, phased migration away from IBM Cognos by auditing legacy Framework Manager models and Report Studio definitions.
• Map legacy reporting logic into modern Power BI semantic layers, guaranteeing strict data parity and calculation accuracy.
• Provide ongoing maintenance and administration support for existing Cognos reports to ensure business continuity during the transition phase.

AWS & Amazon Redshift Optimization

• Query, transform, and ingest high-volume financial data directly from cloud data warehouse ecosystem, prioritizing Amazon Redshift.
• Write and tune advanced, high-performance SQL queries to optimize data extraction, minimizing Redshift cluster load and report latency.
• Collaborate with ETL Team to align data warehouse schemas with front-end reporting requirements.

Strategic Business Partnership

• Collaborate directly with business stakeholders to map out KPIs unique to operations (e.g., loan performance, delinquency risk, premiums, and pipeline metrics).
• Maintain comprehensive documentation regarding report lineage, data dictionaries, and migration tracking.
• Mentor junior team members on advanced Power BI modeling techniques and data visualization standards.
• Perform other duties as assigned by management.

Minimum Education & Experience Requirements

• Bachelor’s degree in Computer Science, Finance, Data Analytics, Information Systems, or a related field, or the equivalent combination of education and experience.
• Minimum of five (5) + years of dedicated, hands‑on experience developing end-to-end enterprise Power BI solutions (DAX, modeling, connections, and data gateway administration).
• Minimum of five (5) + years of advanced SQL experience with a proven track record of writing optimized queries against data warehouses, specifically Amazon Redshift.
• Hands‑on experience with IBM Cognos Analytics (Framework Manager, Report Studio), with the ability to diagnose legacy logic and support reports during a migration.
• Experience in mortgage insurance, mortgage banking, or broader lending industries preferred.
• Microsoft Certified: PL-300 (Power BI Data Analyst) or AWS Certified Data Engineer / Cloud Practitioner preferred.
• Experience utilizing Git Repos in Azure DevOps or GitHub for report version control.
• Direct experience building enterprise reports sourced from AWS (Amazon Web Services) data sources.
• Strong understanding of enterprise Power BI development including semantic models, DAX calculations, Power Query (M) scripts, and data gateway administration.
• Experience administering Power BI Service tenant environments, managing workspaces, security (RLS/OLS), dataflows, fabric capacities, and automated deployment pipelines.
• Experience administering Source Control and DevOps pipelines for code deployment.
• Proven ability to lead phased migrations from legacy platforms (IBM Cognos, AWS QuickSight) to Power BI, including auditing Framework Manager models and Report Studio definitions.
• Ability to map legacy reporting logic into modern Power BI semantic layers, guaranteeing strict data parity and calculation accuracy.
• Experience querying, transforming, and ingesting high-volume financial data from cloud data warehouse ecosystems, prioritizing Amazon Redshift.
• Ability to write and tune advanced, high-performance SQL queries to optimize data extraction, minimizing Redshift cluster load and report latency.
• Experience collaborating with ETL teams to align data warehouse schemas with front-end reporting requirements.
• Ability to collaborate directly with business stakeholders to map KPIs (e.g., loan performance, delinquency risk, premiums, and pipeline metrics).
• Exceptional communication skills with a proven ability to translate complex financial reporting transitions into universal language for business stakeholders.
• Experience maintaining comprehensive documentation regarding report lineage, data dictionaries, and migration tracking.
• Ability to mentor junior team members on advanced Power BI modeling techniques and data visualization standards.
• Demonstrated ability to manage concurrent deliverables on time and with quality in a fast‑paced environment.
• Excellent analytical, problem‑solving, communication, documentation, and collaboration skills.
• Advanced proficiency with Microsoft Office applications required.
• Excellent time management skills with the ability to manage multiple priorities with conflicting deadlines.

Benefits

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.

EEO Statement

Essent is an Equal Opportunity Employer.