Job Classification:

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

Our Technology Solutions Group is a dynamic, fast-paced environment, with exciting changes on the horizon under new senior leadership. We are looking for an astute, determined professional like you to fulfil a Database Developer role within our Technology Solutions Group. You will showcase your success in an Agile environment through collaboration, ownership and innovation. Your expertise in emerging trends and practices will evoke stimulating discussions around optimization and change to help keep our competitive edge. This rewarding opportunity will enable you to make a big impact in our organization, so if this sounds exciting, then PGIM might be the place

What you can expect

• Design, develop, and maintain SQL code to process data from various data pipelines

• Create and maintain data storage solutions, such as data warehouses, data lakes, and databases. Optimize data storage structures for performance and cost-effectiveness.

• Integrate and merge data from different sources while ensuring data quality, consistency, and accuracy.

• Manage and optimize data warehouses to store and organize data for efficient retrieval and analysis.

• Cleanse, preprocess, and transform data to meet business requirements and maintain data quality.

• data pipelines and database performance to ensure data processing efficiency.

• Implement and maintain security measures to protect sensitive data and ensure compliance with data privacy regulations.

• Align with the Product Owner and Scrum Master in assessing business needs and transforming them into scalable applications.

• Build and maintain code to manage data received from heterogenous data formats including web-based sources, internal/external databases, flat files, heterogenous data formats (binary, ASCII).

• Build new enterprise Datawarehouse and maintain the existing one.

• Design and support effective storage and retrieval of very large internal and external data set and be forward think about the convergence strategy with our AWS cloud migration

• Assess the impact of scaling up and scaling out and ensure sustained data management and data delivery performance.

• Build interfaces for supporting evolving and new applications and accommodating new data sources and types of data.

What you will bring

• 5 years of experience as a database developer
• Strong knowledge of various Snowflake development features such as SnowPipe, Streams, SQL REST API, Procedures, User Defined Functions, External Functions, Tagging, Masking, Data Lineage, SnowPark
• Proficiency in SQL, data querying, and performance optimization techniques
• Proficiency in procedural languages such as MSSQL TSQL, Postgres pl/sql
• Experience in developing Datawarehouse and OLTP applications
• Proficiency in data modeling, database design, and SQL.
• 3 years of experience developing and deploying applications in Snowflake
• Familiarity with AWS services like S3, DMS, EC2, Glue, Lambda
• Proficiency in Aurora Postgres database clusters on AWS
• Familiarity with Orchestration tools like Airflow, Autosys, etc
• Ability to communicate the status, challenges and proposed solution with the team.
• Demonstrating the ability to learn new skills and work as a team.
• Knowledge of data security and privacy best practices.
• Working knowledge of data governance and ability to ensure high data quality is maintained throughout the data lifecycle of a project.
• Knowledge of data visualization and business intelligence tools (e.g., Tableau, Power BI).
• Ability to prioritize multiple tasks and projects and work effectively under pressure; exceptional organizational and administrative skills; at ease with abundance of details, yet mindful of big picture at all times.
• Strong analytical and problem-solving skills, with ability to conduct root cause analysis on system, process or production problems and ability to provide viable solutions.
• Experience working in an Agile environment with Scrum Master/Product owner and ability to deliver.

What will set you apart?

• Good understanding of Snowflake infrastructure – account structure, warehouses, roles, connectivity patterns, AD integration, S3 integration, KMS integration, Cost Governance
• Python API Development/Snowflake snowpark coding experience
• Streaming or messaging knowledge with Kafka or Kinesis is desirable.
• Understanding of capital markets within Fixed Income

*PGIM welcomes all applicants, even if you don't meet every requirement. If your skills align with the role, we encourage you to apply.

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, visit Work Life Balance | Prudential Careers

Note: 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 $110,000 to $140,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 Fixed Income Group PGIM Fixed Income is a global asset manager offering active solutions across all fixed income markets. With approximately 1000 employees and $793bn assets under management, the company has offices in Newark, London, Letterkenny, Amsterdam, Munich, Zurich, Tokyo, Hong Kong, and Singapore. Our business climate is a safe inclusive environment, centered around mutual respect, intellectual honesty, transparency, and teamwork. Our leaders are focused on talent & culture; dedicated to fostering growth & development at all levels to develop the industry leaders of tomorrow. 

About PGIM – Global Asset Management

PGIM is the global asset management business of Prudential Financial, Inc. (NYSE: PRU), a leading global investment manager with nearly US$1.27 trillion in assets under management as of June 30th, 2023 With offices in 18 countries, PGIM’s businesses offer a range of investment solutions for retail and institutional investors around the world across a broad range of asset classes, including public fixed income, private fixed income, fundamental equity, quantitative equity, real estate and alternatives.

With a history dating back 145 years, and experience through more than 30 market cycles, PGIM takes a long-term view, not only in our investment philosophy, but also in how we develop our talent. We want to see our employees excel from their first day with the firm and throughout their tenure with PGIM. We will inspire you, support you, and help you reach your greatest personal and professional aspirations. If PGIM sounds like the place for you, join us. For more information about PGIM, visit PGIM.com.

Prudential Financial, Inc. of the United States is not affiliated with Prudential plc. which is headquartered in the United Kingdom.

Our Commitment to Diversity, Equity, and Inclusion

Prudential Financial, Inc. is focused on creating a fully inclusive culture, where all employees feel comfortable bringing their authentic selves to work. We don’t just accept difference—we celebrate it, support it, and thrive on it. At Prudential, employees have a unique opportunity to build their career path by owning their development, their career, and their future. We encourage employees to hone their skills and explore continued opportunities within Prudential.

#LI-MM1