PGIM Fixed Income - Analyst, Business Intelligence

PGIM•Newark, NJ

32d•$90,000 - $105,000

About The Position

In PGIM Fixed Income, our technology group is a dynamic, fast-paced environment, with exciting changes on the horizon under new senior leadership. We are looking for a senior business intelligence resource to support senior leaders in building all new visualization and data analytics within the various departments in Fixed Income. Our ideal candidate will have proven experience in building dynamic analytics report/dashboards for financial end-users. The right candidate for this role will identify this challenge as a unique and valuable opportunity to help drive our global technology transformation, so if this sounds interesting, then PGIM could be the place for you.

Requirements

2+ years of Power BI application development experience including visualizations, parameters, and report optimization
3+ years working in Python, Pandas Data Frames, Machine Learning, and API-driven workflows.
2+ years of hands-on SQL Experience
2+ Years working with AI and understanding Ai Frameworks.
Expertise across multiple BI platforms and data visualization tools include Tableau and Power BI
Strong experience with performance tuning business intelligence and database platforms for maximum performance in each technical configuration
Expertise with multiple database platforms including relational databases (ie. SQL Server and Oracle) as well as cloud-based data warehouses such as Microsoft Fabric and Snowflake
Experience with both server and desktop-based data visualization tools
Expertise managing and mining very large internal and external data sets
Experience with sourcing external data sets to meet business needs
Demonstrated experience with testing business hypotheses, asking the right questions to provoke thoughts from business users and ultimately using data to test and validate hypothesis
Very strong experience with quickly building data visualization worksheets and dashboards to analyze, view and interpret data sets
Hands-on experience with Python for building automations for business processes
Demonstrated experience with using predictive, prescriptive and descriptive data analytics to test, question and solve business problems
Have a consulting mindset when working with internal clients across multiple departments of the organization
Bachelor's degree in computer science or equivalent, with a strong preference in a Data-centric major.

Nice To Haves

Ideally familiar with financial services datasets across investment, product and distribution functions - not essential but highly desirable

Responsibilities

Create Power BI Dashboards to meet complex user requirements and demand.
Integration of Parameters, Parameterized Queries, and Query Folding to optimize data source connectivity and refreshes.
Performance tuning, Semantic Model Optimization, and creating Power BI workbooks that are able to intelligently aggregate data from large data sources.
Develop and modify Python Scripts to optimally transform data frames for both output files for data sources, but also to leverage machine learning and advanced statistical analytics.
Schedule, deploy, and put Python scripts through version control.
Test, Research, and Implement AI driven frameworks to augment reporting and analytics across the firm.
Implement strategies for Outlier Detection, Insight Generation, and push-analytics to stakeholders.
Creation and Deployment of Custom Python Driven Visuals and Open-Source Visualization Capabilities.
Transform complex reporting needs into technical specifications, including calculations, custom groups, parameters, filtering criteria, aggregations etc.
Develop and Test Python and Custom API-related Workflows to build on the capabilities of the Power BI Platform.
Work with Tableau for support, ticket resolution, feature requests and defect tracking.
Demonstrate strong backend platform expertise and front-end consultancy capability
Recommend best practices from both a technical and process perspective as related to Power BI and Tableau development.
Groom large datasets for optimal performance and maintainability
Troubleshoot issues as they occur, identify criticality and impact, and provide appropriate workarounds

Benefits

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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume