Data Analyst - Finance

Data Analyst Role Summary

This candidate should have experience in data analysis and data integration to contribute to the development of the data-driven and artificial intelligence solutions for our company objectives. The successful candidate will be responsible for understanding business requirements, translating them into actionable insights using thorough data analysis, and working alongside the development team to ensure seamless integration of systems and data. The candidate will interpret and analyse data to transform it into information for all business areas to support their decision making. Responsibilities span the full lifecycle activities including requirements analysis and design, development of analysis and reporting capabilities, and continuous monitoring of performance and quality control plans to identify improvements.

Responsibilities

• 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.

Technical Qualifications

• 6 – 8. 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.
• Good to have knowledge on MicroStrategy, is a plus
• Adept within queries, report writing, and able to present findings.
• Familiarity with the Pharma or Med Tech domain, is a plus.