Job Description
- Perform business and data analysis for end user reports and ETL requests. Complete this objective through the utilization of SQL, and/or other reporting & data mining technology tools.
- Collaborate with various stakeholders, including business users, IT teams, and external vendors to gather, analyze, and document business requirements related to finance or investments and data integration solutions.
- Assist the development and delivery of ETL applications, adhoc / recurring reports. Assist with testing and implementation from a data lifecycle perspective.
- Acquire a strong understanding of the company's AI initiatives and assist in designing, building, and implementing AI solutions for investments, when required.
- Develop appropriate data requirements of documentation in line with PB's/PCS's SDLC framework including data requirements, data mapping, data analysis and test plans, workflows, and data integrations.
- Design & develop reports with corresponding dashboards to monitor the performance and effectiveness of finance / investment systems and to provide actionable insights for business users.
- Define data quality plans to address data quality issues; work with business partners to build business understanding of data issues.
- Coordinate user testing, training, and rollout activities for the implemented data analysis and data integration solutions. Ensure a smooth transition for end-users.
- Cultivate strong professional work-relationships with team members across the business as appropriate.
- Facilitate individual workload and deliver upon project milestones on time / within budget.
- 3-5 years of background knowledge as a Data Analyst or IT Business Analyst with a focus on finance or investments and data analysis / integration.
- Strong knowledge of relevant technology toolsets relative to data analysis and documentation including SQL, data modeling, metadata organization, data cleaning, and reporting tools. (i.e., business objects, or other data reporting / data mining tools.
- Require experience with large SQL databases.
- Adept within queries, report writing, and able to present findings.
- Familiarity with the application of Artificial Intelligence techniques in the finance or investment domain, is a plus.
- Possess the knowledge of compliance data experience, is a plus.