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

Role

Description

data modeling

bi infrastructure

dax development

dashboard development

platform migration

data governance

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

Requirements

power bi

dax

sql

tableau

azure

agile

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

Benefits

401(k) plan with company match (up to 4%).
Education Benefit to help finance traditional college enrollment toward obtaining an approved degree and many accredited certificate programs.
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.
Market competitive base salaries, with a yearly bonus potential at every level.
Company-funded pension plan.
Wellness Programs including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs.
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.
Medical, dental, vision, life insurance, disability insurance, Paid Time Off (PTO), and leave of absences, such as parental and military leave.

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

data modeling

bi infrastructure

dax development

dashboard development

platform migration

data governance

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

Requirements

power bi

dax

sql

tableau

azure

agile

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

Benefits

401(k) plan with company match (up to 4%).
Education Benefit to help finance traditional college enrollment toward obtaining an approved degree and many accredited certificate programs.
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.
Market competitive base salaries, with a yearly bonus potential at every level.
Company-funded pension plan.
Wellness Programs including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs.
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.
Medical, dental, vision, life insurance, disability insurance, Paid Time Off (PTO), and leave of absences, such as parental and military leave.

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