PGIM Manager, Data Engineer (Hybrid, Newark, NJ)

Job Classification :

Technology - Engineering & Cloud

A GLOBAL FIRM WITH A DIVERSE & INCLUSIVE CULTURE

As the Global Asset Management business of Prudential, we’re always looking for ways to improve financial services. We’re passionate about making a meaningful impact - touching the lives of millions and solving financial challenges in an ever-changing world.

We also believe talent is key to achieving our vision and are intentional about building a culture on respect and collaboration.

When you join PGIM, you’ll unlock a motivating and impactful career all while growing your skills and advancing your profession at one of the world’s leading global asset managers!

If you’re not afraid to think differently and challenge the status quo, come and be a part of a dedicated team that’s investing in your future by shaping tomorrow today.

At PGIM, You Can!

What you will do

PGIM Operations and Innovation drives digital transformation, modern data analytics, and operational excellence across PGIM in partnership with our business and corporate functions.

We are aligned into seven verticals to drive innovative solutions and deliver operational services that contribute to PGIM being a world-class investment manager.

Our workstreams operate in a collaborative, agile manner and develop a successful community focused on most relevant emerging technologies and best-in-class solutions.

The Cloud Data Engineer role reports into VP, Data Officer, PGIM Operations and Innovation (O&I).

As a Data Engineer, you will bring a structured, organized approach, and a strategic mentality towards driving the organization’s data journey.

You will also be responsible for ingesting, transforming, and validating data into the data lake. In this role, you will evaluate and implement architecture and tools needed for data governance, data modeling, data transformation and support enterprise data.

The role is based in our office in Newark, NJ and will follow a hybrid schedule (2 / 3 days in office).

What you can expect

• Data ingestion from various on-prem and cloud sources, optimize data for large data processing
• Build ETL pipelines to collect, merge, transform raw data into suitable formats for analysis (hands on experience working with ETL tools like AWS Glue, Informatica etc.

and orchestrate transformation (using Airflow, other DAG tools)

• Create enterprise data models and define standards for data warehouse management adhering to data model definitions
• Collaborate with data analytics and reporting teams to understand how data needs to be structured for consumption.
• Configure and maintains MDM tools and system processes to ensure proper function of MDM mechanisms.
• Define master data quality validation criteria and implements automatic error detection schemes.
• Implement data lineage capability to understand data movement across the enterprise
• Implement data governance and standards including data definitions, data quality rules, data lineage, business glossary functions
• Support domain owners and data stewards to analyze quality issue root causes and remediation efforts.
• Monitor cross-BU data provisioning to ensure provisioning is done via official sources.

What you will bring

• Bachelors’ degree is required in a relevant field.
• 6+ years of experience working in a data engineering role supporting an on-prem Data Lake; experience within institutional asset management is a plus.
• 4+ years of solid experience with working on cloud platforms ( Azure preferred)
• Knowledge of Microsoft suite of tools is desired (Power BI, Synapse suite of analytics tools, Azure Data Factory)
• 2+ years of experience with Snowflake (SnowSQL, SnowPark)
• 5+ years of experience with any relational database (SQL, Store procedures, functions)
• 5+ years of experience with Python, Spark and SQL programming languages .
• Extensive hands-on experience in modern data lake architecture, database development, and data modeling.
• Knowledge of real-time data streaming and real-time analytics
• Strong implementation skills and working knowledge of data structures, algorithms and big data tools (Spark, Hadoop, Python, SQL, NoSQL, Hive);

Must have hands-on experience using Spark.

• Solid Linux OS and Shell Scripting experience.
• Experience working with big data technologies and data formats (e.g., Parquet, Delta, Iceberg)
• Extensive experience with at least one of the following RDMS : Oracle, SQL Server, Postgres or MySQL.
• Good communication skills : able to partner with technical and business stakeholders to drive innovative solutions.
• Prior experience using data governance technology tools.
• Experience working in an agile environment embracing collaboration within and across teams.
• Excellent written and verbal communication skills.

What will set you apart?

• Prior experience in a lead role
• Detail oriented; Analytical with strong problem-solving abilities.
• Professional and energetic self-starter. Comfortable with ambiguity, able to effectively take the conceptual to the pragmatic.
• We know not everyone will meet 100% of the requirements, however we encourage you to apply if you think your skills are a good fit for this role .

What we offer you

• Medical, dental, vision, life insurance and PTO (Paid Time Off)
• Retirement plans :
• 401(k) plan with generous company match (up to 4%)
• Company-funded pension plan
• Wellness Programs to help you achieve your wellbeing goals, including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs.
• Work / Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional health, and career development.
• Tuition Assistance to help finance traditional college enrollment, approved degrees, many accredited certificate programs, and industry designations.
2 days ago