Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior Power BI Developer - Mortgage Insurance

Essent Guaranty

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

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.

As a dynamic and resourceful professional, we will rely on you to perform the following duties:

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

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.
Vacancy posted 5 days ago
Similar jobs that could be interesting for youBased on the Senior Power BI Developer - Mortgage Insurance in Wayne, PA vacancy
  •  ...finance industry by offering private mortgage insurance, reinsurance, risk management products...  ...industry.     Title : Investor Relations Senior Analyst     Location : Radnor, PA...  ...the Manager, Investor Relations in developing and executing the company's investor... 
    Senior
    Mortgage
    Full time

    Essent Guaranty, Inc.

    Radnor, PA
    a month ago
  •  ...finance industry by offering private mortgage insurance, reinsurance, risk management products...  ...insurance industry.   Title : Senior Power BI Data Architect   Location: Radnor...  ...analytics strategy. This role focuses on developing scalable, secure, and high-performing... 
    Senior
    Mortgage

    Essent Guaranty, Inc.

    Wayne, PA
    2 days ago
  •  ...finance industry by offering private mortgage insurance, reinsurance, risk management products...  ...Title : Corporate Development Senior Analyst     Location : Radnor, PA...  ...materials, tracking investor engagement, developing related metrics, and assisting with quarterly... 
    Senior
    Mortgage

    Essent Guaranty, Inc.

    Wayne, PA
    2 days ago
  •  ...virtual behavioral health services, an insurance offering, a physician network and various...  ...and talented Sr. Software Engineer - Epic BI Developer. The Sr. Software Engineer - Epic BI...  ...and other reporting applications such as power BI. Responsible for conducting data discovery... 
    Senior
    Work at office
    Local area
    Remote work

    Universal Health Services

    King of Prussia, PA
    2 days ago
  •  ...the company’s success. As a Senior Wealth Strategist within PNC'...  ...research, as appropriate, and develops tax, estate and financial analyses...  ...and spouse/child life insurance; short and long-term disability...  ...Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE... 
    Senior
    Mortgage
    Full time
    Temporary work
    Part time
    Work experience placement
    Work at office

    The PNC Financial Services Group

    Wayne, PA
    4 days ago
  • ## Senior Insurance Defense AttorneyLocation: King of Prussia, PACategory: Legal JobsDirect Link: Now---Tweet This JobExcellent opportunity for an experienced (7+ years) Insurance Defense Associate to work at a terrific defense firm. Work is a mix of auto liability, premises... 
    Senior
    Flexible hours

    Alevistarjobs

    King of Prussia, PA
    12 hours ago
  •  ...which serves the housing finance industry by offering private mortgage insurance, reinsurance, risk management products and title insurance...  ...experience, with significant experience in leadership, managerial, or senior HR Business Partner role. ~ Strategic thinker with strong... 
    Mortgage
    Local area

    Essent Guaranty

    Wayne, PA
    4 days ago
  •  ...which serves the housing finance industry by offering private mortgage insurance, reinsurance, risk management products and title insurance...  ...services organization. This role analyzes financial performance, develops forecasts, and provides actionable insights to support... 
    Mortgage
    Full time

    Essent Guaranty, Inc.

    Radnor, PA
    more than 2 months ago
  • Join Vanguard’s Fixed Income team as a Senior Quantitative MBS Research Analyst, where...  ...agency residential (MBS) and commercial mortgage-backed securities (ACMBS). This is an opportunity...  ...data sources, and communicates results.Develops business acumen to bring an informed... 
    Senior
    Mortgage
    Full time
    Work experience placement

    Vanguard

    Malvern, PA
    5 days ago
  •  ...which serves the housing finance industry by offering private mortgage insurance, reinsurance, risk management products and title insurance...  ...legislation. Support employee development plans and assist with developing and monitoring career path programs. Assist in the... 
    Mortgage
    Work at office
    Local area

    Essent Guaranty

    Wayne, PA
    3 days ago
  • $129.3k - $172.3k

     ...for a change with an in-house opportunity? The Senior Claims Counsel position with First American Title Insurance Company provides an excellent opportunity for counsel...  ..., determine need to retain outside counsel, develop and carry out a plan to address the claim and manage... 
    Senior
    Full time
    Remote work

    First American Financial Company

    Berwyn, PA
    4 days ago
  •  ...and grow what matters, including Insurance, Reinsurance, Cyber Services, Mortgage Origination and more. Acrisure...  ...consistently meeting or exceeding quota. Develop and execute strategic growth plans...  ..., predictive analytics, and AI-powered tools to prioritize high-value... 
    Mortgage
    Temporary work
    Flexible hours

    Acrisure

    Wayne, PA
    3 days ago
  • $120k - $210k

     ...Treasury market and fixed income regulatory developments, and trading counterparty documentation....  ...markets debt;agency and non-agency mortgage-backed securities (RMBS/CMBS);asset-backed...  ...to traders, portfolio managers, and senior management.Nice To Haves:Experience directly... 
    Senior
    Mortgage
    Full time

    Vanguard

    Malvern, PA
    2 days ago
  •  ...available for qualified candidates. No Prior Insurance experience required! - Some of our...  ..., restaurants, hospitality, insurance, mortgage, real estate, B2B, retail leadership,...  ...is designed for individuals who want to develop leadership skills, build business acumen... 
    Mortgage
    Traineeship
    Local area
    Afternoon shift

    Robert Wichert Farmers Insurance

    King of Prussia, PA
    a month ago
  • $150k - $200k

     ...Senior Counsel | Insurance Defense | Pennsylvania | Remote You’ve Built the Experience. Now Put It to Work Somewhere That Values It. Tyson...  ...attorneys have the opportunity to own their matters, develop strategy, take and defend depositions, work with experts,... 
    Senior
    Full time
    Work at office
    Remote work
    Flexible hours

    Tyson & Mendes

    Bryn Mawr, PA
    2 days ago
  •  ...TechnologyFT/PT Status:Full TimeJob Title: Senior Database AdministratorLocation: Wayne,...  ...the opportunity to shape the future of insurance andmake a meaningful impact.Your Role:As...  ...performance and efficiencyBackupand recovery: Develop and implement backup (full,differential... 
    Senior
    Full time
    Part time

    USLI

    Wayne, PA
    3 days ago
  •  ...'s leading luxury home builder, seeks a Senior Video Production Manager to join our team...  ...with creative teams to brainstorm and develop concepts for video projects. Translate ideas...  ...discounted stock purchase, discounts on mortgages, homes, and much more!Come see why Toll... 
    Senior
    Mortgage
    Full time
    Work at office
    Local area
    3 days per week

    Toll Brothers

    Fort Washington, PA
    2 days ago
  • $100k - $120k

     ...Senior Account Manager Marsh McLennan Agency's East Region is a leader in the Business Insurance and Employee Benefits marketplace. Our associates simplify employee health and...  ...and underwriting guidelines, regulatory developments, emerging risks, and industry trends.... 
    Senior
    Work at office
    Flexible hours
    Night shift

    Oliver Wyman

    King of Prussia, PA
    5 days ago
  •  ...Senior Home Lending Advisor Join our fun, high-energy team as...  ...other marketing efforts. Develops a strong partnership with the...  ...assigned retail branches to promote mortgage loan originations (in...  ...Section 19 of the Federal Deposit Insurance Act. As such, an employment... 
    Senior
    Mortgage
    Work experience placement
    Local area
    Immediate start
    Relocation

    Chase

    Souderton, PA
    5 days ago
  •  ...Agency specializing in Home, Life, and Auto insurance. We take our job seriously and tailor...  ...objectives as established. ·       Develop insurance quotes, makes sales presentations...  ...relationships with Real Estate Agents, Mortgage Lenders,          Title Companies, Auto... 
    Mortgage
    Work from home
    Flexible hours

    JLB Agency

    Willow Grove, PA
    6 days ago
  •  ...of luxury homes, seeks an experienced Senior Business Intelligence Analyst to join...  ...strategic decision-making.Design, develop, and maintain Power BI reports, dashboards, and semantic models...  ...stock purchase, discounts on mortgages, homes, appliances, and much more!APPLY... 
    Senior
    Mortgage
    Full time
    Work at office
    Local area
    3 days per week

    Toll Brothers

    Fort Washington, PA
    4 days ago
  •  ...Senior Sales Associate Become a part of the Pilates movement with Club Pilates! Spartan...  ...for growth and development, health insurance benefits, 401K matching opportunities, free...  ...awareness. Assist in onboarding and developing new front desk and sales staff as directed... 
    Senior
    Hourly pay
    Temporary work
    Work at office
    Shift work
    Afternoon shift

    Spartan Fitness Holdings

    Wayne, PA
    2 days ago
  •  ...Job Description Job Description Leadling is actively searching for seeking experienced Mortgage Loan Officers ready to increase earnings, scale nationally, and gain full control of their business with a National Mortgage Lender. *****This is a 100% Commission... 
    Senior
    Mortgage
    Local area
    Remote work
    Flexible hours

    Leadling

    Norristown, PA
    6 days ago
  •  ...virtual behavioral health services, an insurance offering, a physician network and various...  ...department is seeking a dynamic and talented Senior Auditor. In collaboration with the Lead...  ...and selection process of SOX audits. Develop audit testing procedures relevant to... 
    Senior
    Work experience placement
    Work at office
    Local area
    Work from home
    Flexible hours

    Universal Health Services

    King of Prussia, PA
    2 days ago
  •  ...Senior Revenue Cycle Analyst Billing Headquartered in King of Prussia, PA, Universal Health Services, Inc. is one of the nation's...  ...facilities, nationwide virtual behavioral health services, an insurance offering, a physician network and various related services with... 
    Senior
    Work at office
    Local area

    Universal Health Services

    King of Prussia, PA
    4 days ago
  •  ...Job Description Job Description Insurance Agency Manager - Job Description        Because...  ...goals and objectives as established. Develop and implement new marketing and sales...  ...relationships with Real Estate Agents, Mortgage Lenders, Title Companies, Auto Dealers,... 
    Mortgage
    Full time
    Work at office

    Johanna James-Allstate

    Skippack, PA
    21 days ago
  • Software Guidance & Assistance, Inc., (SGA), is searching for a Senior Server Engineer for a CONTRACT assignment with one of our premier Financial Services clients in Jersey City, NJ. The principle objective of this position is to architect and provide expert... 
    Senior
    Contract work
    Weekend work
    Day shift

    Software Guidance & Assistance

    Wayne, PA
    4 days ago
  •  ...performance ~ Competitive salary ~ Health insurance ~ Training & development Licensed...  ...of Influence (COIs) including realtors, mortgage lenders, and local business...  ...strong and sustainable book of business Develop high-value referral partnerships Maximize... 
    Mortgage
    Full time
    Work at office
    Local area

    Goosehead Insurance - Lee Plummer

    Bala Cynwyd, PA
    23 days ago
  • $84.38k - $135k

     ...Illness, and Hospital Indemnity) products. You'll assess risk, develop pricing recommendations, and support profitable growth and customer...  ...to financial security, with products including annuities, life insurance, group protection, and retirement plan services. With our 120-... 
    Senior
    Work experience placement
    Work at office
    Remote work
    Work from home
    Relocation package

    Lincoln Financial Group

    Radnor, PA
    5 days ago
  •  ...Senior Principal Statistician Join a talented and committed team at GSK, where your expertise will help shape the future of healthcare. In this Senior Principal role, you will lead complex projects by collaborating closely with cross-functional teams to deliver scientific... 
    Senior
    Local area
    Remote work

    GSK LLP

    Newtown Square, PA
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior Power BI Developer - Mortgage Insurance. Be the first to apply!