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

Prudential Financial

  • Newark, NJ
  • Permanent
  • Full-time
  • 1 month ago
Job Classification: Technology - Engineering & CloudA GLOBAL FIRM WITH A DIVERSE & INCLUSIVE CULTUREAs 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 doPGIM 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 (AWS, Azure) (CloudFormation Templates, IAM, Aurora, EventBridge, Lambda, CloudWatch);
  • 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
  • Knowledge of Microsoft suite of tools is desired (Power BI, Synapse suite of analytics tools, Azure Data Factory)
  • 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.
To find out more about our Total Reward package, visitNote: Prudential is required by state specific laws to include the salary range for this role when hiring a resident in applicable locations. The salary range for this role is from $1300,000 to $155,000. Specific pricing for the role may vary within the above range based on many factors including geographic location, candidate experience, and skills. Roles may also be eligible for additional compensation and/or benefits. Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance.About PGIM Operations and Innovation Group (PGIM O&I)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 foster a strong community focused on most relevant emerging technologies and best-in-class solutions.Prudential Financial, Inc. of the United States is not affiliated with Prudential plc. which is headquartered in the United Kingdom.Prudential is a multinational financial services leader with operations in the United States, Asia, Europe, and Latin America. Leveraging its heritage of life insurance and asset management expertise, Prudential is focused on helping individual and institutional customers grow and protect their wealth. The company's well-known Rock symbol is an icon of strength, stability, expertise and innovation that has stood the test of time. Prudential's businesses offer a variety of products and services, including life insurance, annuities, retirement-related services, mutual funds, asset management, and real estate services.We recognize that our strength and success are directly linked to the quality and skills of our diverse associates. We are proud to be a place where talented people who want to make a difference can grow as professionals, leaders, and as individuals. Visit to learn more about our values, our history and our brand.Prudential is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, sex, sexual orientation, gender identity, national origin, genetics, disability, marital status, age, veteran status, domestic partner status , medical condition or any other characteristic protected by law.The Prudential Insurance Company of America, Newark, NJ and its affiliates.Note that this posting is intended for individual applicants. Search firms or agencies should email Staffing at for more information about doing business with Prudential.PEOPLE WITH DISABILITIES:
If you need an accommodation to complete the application process, which may include an assessment, please email .Please note that the above email is solely for individuals with disabilities requesting an accommodation. If you are experiencing a technical issue with your application or an assessment, please email to request assistance.

Prudential Financial