PGIM Manager, Data Engineer (Hybrid, Newark, NJ)
Prudential Financial
- Newark, NJ
- Permanent
- Full-time
- 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.
- 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.
- 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.
- 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.
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.