Business Analyst, Quality and Oversight

JOB SUMMARY

This position requires in-depth process knowledge of planning and execution of regulatory submissions to Health Authorities, business process metrics, Key Performance Indicators (KPIs), Objective Key Results (OKRs) reports and visualizations.

This position is also accountable for identifying end to end process trends, opportunities for improvement, formulating projects and specifics plans necessary for corrective and preventive actions of the designated business needs.

JOB RESPONSIBILITIES
- Conduct analyses and build, supervise, and update reports in Excel of portfolio data and regulatory dossier processes and trends to measures, controls and assess KPI’s to improves business decision making through creation, provision and maintenance of periodic and adhoc analytics and dashboards, aggregating and interpreting data into meaningful and timely information, proposing options, recommendations and actions.
- Ad hoc reporting as the need arises by the business. Build and maintain tools to help team with analytics of metrics.
- Pivotal elements of this role include critical analysis of regulatory dossier (submission) trending, resource demands against capacity to enable decisions and practical interpretations.
- Provide operational support to Hub Submission team execute designated tasks associated with business process improvement activities for assigned regulatory procedures as appropriate.
- Development efficiency process improvements through technological tools.
- Create workflow and step-by-step process documentation related to develop tools in submission management.
- Adhere to the appropriate use of technical tools, through use of working practices and QC/QA regimes, such that regulatory and internal compliance is preserved.
- Create, review, and revise documentation procedure according to standard operating procedures.
- Data analysis according with business purposes.
- Regularly track performance alongside KPI goals and targets.
- Escalate, inform, and/or resolve any issues that may impact timeline, quality, or compliance regulatory operations systems.
- Commit to completing required on-the-job training courses to ensure training compliance is preserved.

QUALIFICATIONS / SKILLS

Qualifications:

- B.S./B.Sc is in engineering, computer science, Business or Information Technology.
- A minimum of 2+ years of related work experience in Business analytics or a combination of education and experience.
- Proficient in writing, reading, listening, and speaking in English with good communication skills.
- Proven technical aptitude and ability to quickly learn and use new software, regulations, and quality standards.
- Familiarity with pharmaceutical organizational structures, systems, and culture is preferred.
- 2 to 3 years of experience in Microsoft Excel software in creating macros, pivot, Power Query usage, etc.
- Working effectively with multicultural and cross functional teams.
- Must be able to consistently meet quality standards and complete projects in a timely manner.
- Ability to plan, monitor and execute multiple projects simultaneously.

**Skills**:

- Coordination and execution of activities in a highly regulated environment.
- Aptitude in project management and logistics.
- Demonstration of experience working in a challenging customer service environment.
- Proven experience managing or delivering through others in a team environment.
- Demonstrated attention to detail
- Understanding of applicable filing regulatory guidelines and fluency regarding order and presentation of regional and national regulatory dossiers.
- Developing dashboards by using Macros or other tools, ensuring business requirements.
- Strong knowledge on Excel Charts, Pivots, Slicers, Excel formulas, Dashboard views, Index Match, VLOOKUP & H-Lookup, Offset, named ranges, data sorting and filtering.
- Working on Dash Boards development by using Advanced Excel and its features like Pivot Tables, Charts, and reports.
- A MIS and Excel Macros and Power Bi professional experience in reporting, has successfully managed Operations and management reporting.
- Creating decision making reports by using Excel, automation in VBA.
- Having proficiency knowledge with VBA macros.
- Automation of various reports needs of the assigned projects such as SQL Server, Excel, and VBA Macros.
- Maintain existing reporting process using Access, Excel, and VBA & Macros
- Excellent interpersonal and oral communication skills.
- Experience in research analysis, data analysis, and data management.
- Technological Savvy.
- Knowledge in SharePoint On-line, Power automate and Power apps.
- Excellent interpersonal and oral communication skills.
- Good creative and critical thinking skills.
- Strong problem-solving and troubleshooting abilities.
- Able to operate at pace with agile decision-making skills. Uses evidence and applies judgement to balance pace, rigor and risk.
- Demonstrate experience of influencing through data storytelling, with t