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
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.
- 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.
- 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.
- 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.
- 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.
- 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...SeniorMortgageFull time
- ...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...SeniorMortgageFull time
- ...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...SeniorMortgageFull timeWork at office
$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...SeniorMortgageFull timeTemporary workLocal area- ## 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...SeniorFlexible hours
- ...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...SeniorMortgageLocal areaRemote workFlexible hours
- ...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...MortgageFull time
- ...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...MortgageWork at officeLocal area
- ...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...SeniorWork at officeLocal areaRemote work
$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...SeniorRemote work- ...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...SeniorMortgageFull timeTemporary workPart timeWork experience placementWork at office
- ...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...MortgageImmediate startFlexible hours
$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...SeniorWork at officeRemote work$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,...SeniorFull timeWork at officeRemote workFlexible hours$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...SeniorMortgageBase plus commissionWork experience placementWork at office- 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...SeniorMortgageFull timeWork experience placement
- ...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...MortgageWork from homeFlexible hours
$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....SeniorWork at officeFlexible hoursNight shift$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...SeniorMortgageFull time- ...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...SeniorWork at officeLocal area
- ...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...MortgageWork at officeFlexible hours
- 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...SeniorContract workWeekend workDay shift
- ...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,...MortgageFull timeWork at office
- ...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...MortgageFull timeWork at officeLocal area
- ...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...SeniorLocal areaRemote work
$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- ...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...SeniorFull timePart time
- ...'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...SeniorMortgageFull timeWork at officeLocal area3 days per week
- ...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...MortgageFull timeWork at officeLocal area
- ...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...MortgageLocal areaFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Power BI Developer - Mortgage Insurance. Be the first to apply!
Related searches
- senior living Wayne, PA
- senior accountant remote Wayne, PA
- senior devops engineer remote Wayne, PA
- international tax senior Wayne, PA
- senior activities Wayne, PA
- srs Wayne, PA
- senior net developer remote Wayne, PA
- senior financial analyst fp&a Wayne, PA
- senior commercial counsel Wayne, PA
- senior international accountant Wayne, PA




