Senior Power BI Developer

Essent Guaranty, Inc.

Radnor, PA

JOB DETAILS
SKILLS
Administrative Skills, Alliance/Partner Management, Amazon Web Services (AWS), Analysis Skills, Architectural Design, Auditing, Business Intelligence, Cloud Computing, Communication Skills, Computer Science, Data Analysis, Data Migration, Data Modeling, Data Visualization, Data Warehousing, Database Extract Transform and Load (ETL), Delivery Management, DevOps, Documentation, Ecosystems, Establish Priorities, Finance, Financial Analysis, Git, GitHub, IBM Cognos, IBM Product Family, Identify Issues, Information Technology & Information Systems, Insurance, Leadership, Loans, Mentoring, Metrics, Microsoft Office, Microsoft Windows Azure, Migration Strategy, Mortgage, Mortgage Insurance, Mortgage Lending, Multitasking, Past Due Accounts, Performance Analysis, Performance Metrics, Power BI, Problem Solving Skills, Query Optimization, Reinsurance, Reporting Dashboards, Risk, Risk Management, SQL (Structured Query Language), Security Monitoring, Software Engineering, Source Code/Configuration Management (SCM), Time Management, User Interface (UI) Requirements, User Interface/Experience (UI/UX)
LOCATION
Radnor, PA
POSTED
8 days ago

Senior Power BI Developer - Radnor PA Skip To ContentBrightMove JobsReturn to Essent.usCareersInterested in joining a fast-paced results-focused company that cares about its employees and is helping shape Americas housing finance industry Essent is currently interviewing for the following open positionsToggle navigationPortal HomeCreate Profile Share This Job Senior Power BI Developer Job Title Senior Power BI Developer Job ID 27781252 Location Radnor PA 19087 Other Location 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 DeveloperLocation Radnor PAThis 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 CognosAWS 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 dutiesPower 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 RLSOLS 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 Bachelors degree in Computer Science Finance Data Analytics Information Systems or a related field or the equivalent combination of education and experienceMinimum of five 5 years of dedicated hands-on experience developing end-to-end enterprise Power BI solutions DAX modeling connections and data gateway administrationMinimum of five 5 years of advanced SQL experience with a proven track record of writing optimized queries against data warehouses specifically Amazon RedshiftHands-on experience with IBM Cognos Analytics Framework Manager Report Studio with the ability to diagnose legacy logic and support reports during a migrationExperience in mortgage insurance mortgage banking or broader lending industries preferredMicrosoft Certified PL-300 Power BI Data Analyst or AWS Certified Data Engineer Cloud Practitioner preferredExperience utilizing Git Repos in Azure DevOps or GitHub for report version controlDirect experience building enterprise reports sourced from AWS Amazon Web Services data sourcesStrong understanding of enterprise Power BI development including semantic models DAX calculations Power Query M scripts and data gateway administrationExperience administering Power BI Service tenant environments managing workspaces security RLSOLS dataflows fabric capacities and automated deployment pipelinesExperience administering Source Control and DevOps pipelines for code deploymentProven ability to lead phased migrations from legacy platforms IBM Cognos AWS QuickSight to Power BI including auditing Framework Manager models and Report Studio definitionsAbility to map legacy reporting logic into modern Power BI semantic layers guaranteeing strict data parity and calculation accuracyExperience querying transforming and ingesting high-volume financial data from cloud data warehouse ecosystems prioritizing Amazon RedshiftAbility to write and tune advanced high-performance SQL queries to optimize data extraction minimizing Redshift cluster load and report latencyExperience collaborating with ETL teams to align data warehouse schemas with front-end reporting requirementsAbility to collaborate directly with business stakeholders to map KPIs e.g. loan performance delinquency risk premiums and pipeline metricsExceptional communication skills with a proven ability to translate complex financial reporting transitions into universal language for business stakeholdersExperience maintaining comprehensive documentation regarding report lineage data dictionaries and migration trackingAbility to mentor junior team members on advanced Power BI modeling techniques and data visualization standardsDemonstrated ability to manage concurrent deliverables on time and with quality in a fast-paced environmentExcellent analytical problem-solving communication documentation and collaboration skillsAdvanced proficiency with Microsoft Office applications requiredExcellent time management skills with the ability to manage multiple priorities with conflicting deadlinesOur commitment to your success is enhanced by our competitive salary and comprehensive benefits package including paid time off medical dental vision 401k 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. Option 1 Login and Apply UsernamePassword Submit Option 2 Create a New Profile Create Profile and Apply to Job Return to Essent.usReturn to Essent.us Engineered by BrightMove 2026

About the Company

E

Essent Guaranty, Inc.