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 3 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...  ...Title : Corporate Development Senior Analyst     Location : Radnor, PA...  ...materials, tracking investor engagement, developing related metrics, and assisting with quarterly... 
    Senior
    Mortgage
    Full time

    Essent Guaranty, Inc.

    Radnor, PA
    a month ago
  •  ...finance industry by offering private mortgage insurance, reinsurance, risk management products...  ...mortgage insurance industry.   Title : Senior Accountant   Location: Radnor, PA...  ...process enhancements. Assist in developing and maintaining accounting policies... 
    Senior
    Mortgage
    Full time
    Work at office

    Essent Guaranty, Inc.

    Radnor, PA
    more than 2 months ago
  • $75k - $110k

     ...Position Title: CMBS Surveillance - Senior Analyst/Associate (PA)...  ...assigned portfolio of commercial mortgage-backed securities ( CMBS ) in...  ...of transaction reports. Develop detailed cash flow analysis...  ...the National Association of Insurance Commissioners as a Credit Rating... 
    Senior
    Mortgage
    Full time
    Temporary work
    Local area

    KBRA

    Dresher, PA
    1 day 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
    4 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
    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
  •  ...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
    1 day 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
    12 hours 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...  ...company, determine need to retain outside counsel, develop and carry out a plan to address the claim and... 
    Senior
    Remote work

    First American

    Berwyn, PA
    12 hours 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
    2 days ago
  •  ...clients with customized solutions across a range of insurance, reinsurance, payroll, benefits, cybersecurity, mortgage services and more. In the last twelve years,...  ...and departments. This role is ideal for a senior insurance professional who excels in client strategy... 
    Mortgage
    Immediate start
    Flexible hours

    Acrisure

    Wayne, PA
    1 day ago
  • $133k - $184k

     ...The Opportunity: A highly regarded, super-regional insurance company seeks an experienced  Senior Trial Attorney to join their legal team in Wayne,...  ...in court, including handling trials and appeals. Develop and implement defense strategies based on thorough legal... 
    Senior
    Work at office
    Remote work

    Frink Hamlett Legal Solutions, Inc.

    Wayne, PA
    7 days 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
    12 hours ago
  • $140k

     ...Outside Sales Senior Account Executive Join Toshiba America Business...  ...building relationships, developing new businesses, and creating...  ...experience in Technology, Finance, Mortgage/Real Estate, and/or...  ...match and company provided life insurance ~ Employee Assistance Programs... 
    Senior
    Mortgage
    Base plus commission
    Work experience placement
    Work at office

    Toshiba America Business Solutions

    Pottstown, PA
    4 days 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
    3 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
    4 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

    Marsh & McLennan

    King of Prussia, 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
    12 hours 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
    2 days ago
  •  ...settlement statements, closing disclosures, mortgages, deeds and title policies. Assist...  ...generating a high degree of respect and trust to develop, maintain strong relationships with...  .... ~ Employer-paid disability and life insurance. ~ Flexible spending accounts. ~401K... 
    Mortgage
    Work at office
    Flexible hours

    Ardn

    Plymouth Meeting, PA
    4 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
    2 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
    19 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
    21 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
    1 day ago
  • $65.9k - $102.2k

    A leading insurance company in the United States is seeking a Senior Group Underwriter who will evaluate and accept risk on group life and disability insurance. Candidates should have at least 3 years of underwriting experience, strong analytical skills, and the ability... 
    Senior

    Prudential Financial, Inc.

    Dresher, PA
    12 hours 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
    1 day 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
    12 hours ago
  •  ...performance ~ Competitive salary ~ Health insurance ~ Training & development...  ...building, and closing new opportunities: Develop referral pipelines through Centers of Influence...  ...is a plus (insurance, real estate, mortgage, or similar fields) Strong communication... 
    Mortgage
    Full time
    Work at office
    Local area

    Goosehead Insurance - Lee Plummer

    Bala Cynwyd, PA
    21 days ago
  •  ...officer and underwriter to prepare title insurance policy and binders and title commitments...  ..., and coordinate with loan officer, mortgage loan processor, and underwriter to be sure...  .../production metrics as set forth by the Senior Management Team. Performs other duties as... 
    Mortgage
    Local area
    Flexible hours

    Ardn

    Plymouth Meeting, PA
    1 day 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!