Director, Systems Development - MS Fabric & Power BI (Hybrid - Newark, NJ or Tampa, FL) at Pgim in Newark, NJ | Kablio

Role

Description

power bi

dax calculations

data modeling

bi migration

data governance

geospatial viz

Partner with Sales, IT, and Operations teams to align BI solutions with business goals.
Develop advanced DAX calculations for KPIs, forecasting, and predictive analytics.
Collaborate with business stakeholders to gather requirements and deliver intuitive, impactful BI solutions.
Lead the end-to-end development of Power BI dashboards, paginated reports, and semantic data models within Microsoft Fabric.
Stay current with BI trends, Microsoft Fabric innovations, and emerging technologies.
Architect scalable data models using Star and Snowflake schemas.
Drive the migration of legacy BI platforms (Tableau, Cognos) to Power BI.
Maintain and enhance BI infrastructure for performance, scalability, and security.
Perform data preparation and analysis using SQL (T-SQL, PL/SQL), Power Query, and Power Pivot.
Lead Agile project execution, including sprint planning and documentation.
Mentor junior developers and offshore teams on Power BI best practices.
Document standards, best practices, and operating procedures.
Build geospatial visualizations using Power BI and ArcGIS.
Ensure data governance, accuracy, and secure access across BI solutions.

Requirements

power bi

dax

sql

azure

agile

leadership

IT/Analytics: 9+ years (Required)
Proven ability to lead cross-functional teams and manage stakeholder relationships.
DAX (Advanced)
Expert-level proficiency in Power BI, DAX, Power Query, and Power Pivot.
Familiarity with Microsoft Azure, Office365, SQL Server, and SharePoint.
Strong SQL skills (T-SQL, PL/SQL) and experience with large datasets and ETL processes.
Microsoft BI Stack (SQL Server, SSIS)
BI and Data Visualization: 6+ years (Required)
Experience in Agile/Scrum.
Advanced Dashboard Development & Data Modeling
Tableau or other BI tools (Nice to have)
Experience with Tableau, Cognos, Power Apps, and Power Automate.
Power BI (Expert)
9+ years of experience in IT/Analytics, with 6+ years in BI and Data Visualization.
SQL, Power Query, Power Pivot
Deep understanding of data modeling and performance optimization.

Benefits

Work/Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional and mental health, and career development.
Education Benefit to help finance traditional college enrollment toward obtaining an approved degree and many accredited certificate programs.
Medical, dental, vision, life insurance, disability insurance, Paid Time Off (PTO), and leave of absences, such as parental and military leave.
Market competitive base salaries, with a yearly bonus potential at every level.
Company-funded pension plan.
Employee Stock Purchase Plan: Shares can be purchased at 85% of the lower of two prices (Beginning or End of the purchase period), after one year of service.
401(k) plan with company match (up to 4%).
Wellness Programs including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs.

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Founded as the asset management arm of Prudential Financial, it has grown into one of the world’s largest investment managers.
With a strong presence in over 30 countries, it offers a wide range of investment strategies across equity, fixed income, real estate, and alternative investments.
Its expertise spans from commercial real estate to renewable energy investments, targeting sectors with high growth potential.
It is known for its data-driven approach, leveraging advanced analytics and insights to deliver superior results for its clients.
Its diverse portfolio includes projects in infrastructure, energy, residential and commercial properties, and more.
The real estate division is particularly noted for its global reach, managing significant assets across North America, Europe, and Asia.
The firm is also making significant strides in alternative investments, focusing on private equity, hedge funds, and other non-traditional asset classes.
With a blend of traditional and innovative investment strategies, it delivers tailored solutions designed to meet the needs of institutional investors, pension funds, and individual clients.

Culture + Values

Trust
Respect
Equity
Meritocracy and diversity of thought, perspective, and experience

Environment + Sustainability

Net Zero by 2050

Operational Carbon Emissions Target

Committed to achieving net zero operational carbon emissions by 2050, demonstrating long-term sustainability goals.

50% Emissions Reduction

Building Emissions Target

Aligned with ULI Greenprint goals, aiming to reduce building emissions by half by 2030.

Headquarters LEED Gold certified with rainwater retention, rooftop garden, green walls, and EV charging stations.
Signatory of UN PRI since 2009 and joined GRESB in 2013.
Engaged Verdani Partners for global ESG consulting.

Inclusion & Diversity

58% employees globally

From Under-Represented Groups

A significant portion of the company's global workforce is comprised of individuals from under-represented groups, reflecting a strong commitment to diversity.

29.9% senior roles held by women

Women in Leadership

Women occupy nearly 30% of senior roles globally, indicating progress toward gender parity in leadership positions.

41.8% female employees globally

Gender Representation

Just over 40% of the company's global workforce identifies as female, showcasing a balanced gender distribution.

Five‑pillar DEI strategy

Comprehensive DEI Approach

The company has implemented a five-pillar strategy covering Talent, Culture, Industry, Investing, and Community to advance diversity, equity, and inclusion across all aspects of its operations.

Ron Andrews DEI Scholarship launched in 2020 for students from under‑represented backgrounds
PGIM is among first 25 signatories to USA & Canada DEI Code and has also signed the UK DEI Code

Articles

Role

Description

power bi

dax calculations

data modeling

bi migration

data governance

geospatial viz

Partner with Sales, IT, and Operations teams to align BI solutions with business goals.
Develop advanced DAX calculations for KPIs, forecasting, and predictive analytics.
Collaborate with business stakeholders to gather requirements and deliver intuitive, impactful BI solutions.
Lead the end-to-end development of Power BI dashboards, paginated reports, and semantic data models within Microsoft Fabric.
Stay current with BI trends, Microsoft Fabric innovations, and emerging technologies.
Architect scalable data models using Star and Snowflake schemas.
Drive the migration of legacy BI platforms (Tableau, Cognos) to Power BI.
Maintain and enhance BI infrastructure for performance, scalability, and security.
Perform data preparation and analysis using SQL (T-SQL, PL/SQL), Power Query, and Power Pivot.
Lead Agile project execution, including sprint planning and documentation.
Mentor junior developers and offshore teams on Power BI best practices.
Document standards, best practices, and operating procedures.
Build geospatial visualizations using Power BI and ArcGIS.
Ensure data governance, accuracy, and secure access across BI solutions.

Requirements

power bi

dax

sql

azure

agile

leadership

IT/Analytics: 9+ years (Required)
Proven ability to lead cross-functional teams and manage stakeholder relationships.
DAX (Advanced)
Expert-level proficiency in Power BI, DAX, Power Query, and Power Pivot.
Familiarity with Microsoft Azure, Office365, SQL Server, and SharePoint.
Strong SQL skills (T-SQL, PL/SQL) and experience with large datasets and ETL processes.
Microsoft BI Stack (SQL Server, SSIS)
BI and Data Visualization: 6+ years (Required)
Experience in Agile/Scrum.
Advanced Dashboard Development & Data Modeling
Tableau or other BI tools (Nice to have)
Experience with Tableau, Cognos, Power Apps, and Power Automate.
Power BI (Expert)
9+ years of experience in IT/Analytics, with 6+ years in BI and Data Visualization.
SQL, Power Query, Power Pivot
Deep understanding of data modeling and performance optimization.

Benefits

Work/Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional and mental health, and career development.
Education Benefit to help finance traditional college enrollment toward obtaining an approved degree and many accredited certificate programs.
Medical, dental, vision, life insurance, disability insurance, Paid Time Off (PTO), and leave of absences, such as parental and military leave.
Market competitive base salaries, with a yearly bonus potential at every level.
Company-funded pension plan.
Employee Stock Purchase Plan: Shares can be purchased at 85% of the lower of two prices (Beginning or End of the purchase period), after one year of service.
401(k) plan with company match (up to 4%).
Wellness Programs including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs.

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Founded as the asset management arm of Prudential Financial, it has grown into one of the world’s largest investment managers.
With a strong presence in over 30 countries, it offers a wide range of investment strategies across equity, fixed income, real estate, and alternative investments.
Its expertise spans from commercial real estate to renewable energy investments, targeting sectors with high growth potential.
It is known for its data-driven approach, leveraging advanced analytics and insights to deliver superior results for its clients.
Its diverse portfolio includes projects in infrastructure, energy, residential and commercial properties, and more.
The real estate division is particularly noted for its global reach, managing significant assets across North America, Europe, and Asia.
The firm is also making significant strides in alternative investments, focusing on private equity, hedge funds, and other non-traditional asset classes.
With a blend of traditional and innovative investment strategies, it delivers tailored solutions designed to meet the needs of institutional investors, pension funds, and individual clients.

Culture + Values

Trust
Respect
Equity
Meritocracy and diversity of thought, perspective, and experience

Environment + Sustainability

Net Zero by 2050

Operational Carbon Emissions Target

Committed to achieving net zero operational carbon emissions by 2050, demonstrating long-term sustainability goals.

50% Emissions Reduction

Building Emissions Target

Aligned with ULI Greenprint goals, aiming to reduce building emissions by half by 2030.

Headquarters LEED Gold certified with rainwater retention, rooftop garden, green walls, and EV charging stations.
Signatory of UN PRI since 2009 and joined GRESB in 2013.
Engaged Verdani Partners for global ESG consulting.

Inclusion & Diversity

58% employees globally

From Under-Represented Groups

A significant portion of the company's global workforce is comprised of individuals from under-represented groups, reflecting a strong commitment to diversity.

29.9% senior roles held by women

Women in Leadership

Women occupy nearly 30% of senior roles globally, indicating progress toward gender parity in leadership positions.

41.8% female employees globally

Gender Representation

Just over 40% of the company's global workforce identifies as female, showcasing a balanced gender distribution.

Five‑pillar DEI strategy

Comprehensive DEI Approach

The company has implemented a five-pillar strategy covering Talent, Culture, Industry, Investing, and Community to advance diversity, equity, and inclusion across all aspects of its operations.

Ron Andrews DEI Scholarship launched in 2020 for students from under‑represented backgrounds
PGIM is among first 25 signatories to USA & Canada DEI Code and has also signed the UK DEI Code

Articles