Data & BI Analyst
Description
Brief Position Description:
The Data & BI Analyst develops business intelligence (BI) reports/dashboards for Clinical Systems, IT and other ERP applications via CRM analytics (and/or PowerBI) tool that support the quality and timely delivery of reports and visualizations required per company standard and study specific data analysis requirements. The Data & BI analyst works with operation teams to analyse relevant application data, develop and prepare reporting on potential process gaps, as well as develop new reports and processes to drive efficiencies within various departments.
Responsibilities:
The responsibilities will vary day to day and may include:
Optimize CRM Analytics recipes, dataflows, and SAQL queries for better performance.
Review existing dashboards and datasets to identify optimization opportunities.
Monitor scheduled data refreshes and resolves failures.
Perform root cause analysis for data discrepancies and dashboard performance issues.
Maintain technical documentation for dashboards, datasets, recipes, and dataflows.
Collaborate with cross-functional stakeholders to gather requirements and develop reporting around relevant Clinical Systems, IT and other ERP applications.
Own the design of analytics dashboards and KPI reports in Novotech BI tool starting from requirements gathering across departments, system owners and senior leadership teams to the delivery of final, polished reports/dashboards in the production.
Design, develop, test, manage and maintain data models, workflows, reports, tools, templates and processes to simplify the analysis process as well as drive work optimization through report automation and stakeholder education.
Support standard and ad-hoc analytic requests, providing accurate and timely data, analysis and insightful interpretations via ServiceNow and JIRA.
Import data from various application like Veeva Vault, SalesForce, Oracle Fusion, Excel, .csv, Web, Share Point, One drive etc.
Create ‘Row Level Security’ within PowerBI to provide restricted access to internal/external report consumers and integration with PowerBI service portal.
Execute dashboard setups and data manipulation using DAX and Power queries.
Willing to learn new BI tools and contribute to reports development as per company requirements.
Provide inputs in tools and concepts of Business Intelligence, Data Warehouse (Snowflake), ETL, data modelling, reporting and analytics to key stakeholders.
Remain abreast of new developments in the BI systems and suggest improvements to drive efficiencies that benefit Novotech and end User as well as client services.
Understand company processes in areas relevant to a Data Analyst and be quality minded in performance of duties. Adhere to Novotech policies and be mindful of the role of Novotech ambassador when carrying out the role.
Understand the responsibilities of Novotech as a service provider in the pharmaceutical industry and ensure all communications with external parties present a positive professional image of the company.
Degree in a computer science, information technology and/or information systems
Experience in preparing reports/dashboard across various clinical trial systems, ERP or other applications in a CRO and/or Pharmaceutical industry is advantageous.
Minimum Qualifications & Experience:
Degree in a computer science, information technology and/or information systems
Experience in preparing reports/dashboard across various clinical trial systems, ERP or other applications in a CRO and/or Pharmaceutical industry is advantageous.
Novotech is proud to offer a great workplace. We are committed to being an employer of choice for gender equality and providing an inclusive work environment where everyone is treated fairly and with respect. Our team members are passionate about what we do, but we understand work is only one of the things that is important to them. We support our team members with flexible working options, paid parental leave for both parents, flexible leave entitlements, wellness programs and ongoing development programs. We are looking for people who are passionate about working clinical research and biotech, including people who identify as LGBTIQ+, have a disability or have caring responsibilities. We are a Circle Back Initiative Employer and commit to respond to every application. We look forward to talking to you about working at Novotech.
Responsibilities:
The responsibilities will vary day to day and may include:
Optimize CRM Analytics recipes, dataflows, and SAQL queries for better performance.
Review existing dashboards and datasets to identify optimization opportunities.
Monitor scheduled data refreshes and resolves failures.
Perform root cause analysis for data discrepancies and dashboard performance issues.
Maintain technical documentation for dashboards, datasets, recipes, and dataflows.
Collaborate with cross-functional stakeholders to gather requirements and develop reporting around relevant Clinical Systems, IT and other ERP applications.
Own the design of analytics dashboards and KPI reports in Novotech BI tool starting from requirements gathering across departments, system owners and senior leadership teams to the delivery of final, polished reports/dashboards in the production.
Design, develop, test, manage and maintain data models, workflows, reports, tools, templates and processes to simplify the analysis process as well as drive work optimization through report automation and stakeholder education.
Support standard and ad-hoc analytic requests, providing accurate and timely data, analysis and insightful interpretations via ServiceNow and JIRA.
Import data from various application like Veeva Vault, SalesForce, Oracle Fusion, Excel, .csv, Web, Share Point, One drive etc.
Create ‘Row Level Security’ within PowerBI to provide restricted access to internal/external report consumers and integration with PowerBI service portal.
Execute dashboard setups and data manipulation using DAX and Power queries.
Willing to learn new BI tools and contribute to reports development as per company requirements.
Provide inputs in tools and concepts of Business Intelligence, Data Warehouse (Snowflake), ETL, data modelling, reporting and analytics to key stakeholders.
Remain abreast of new developments in the BI systems and suggest improvements to drive efficiencies that benefit Novotech and end User as well as client services.
Understand company processes in areas relevant to a Data Analyst and be quality minded in performance of duties. Adhere to Novotech policies and be mindful of the role of Novotech ambassador when carrying out the role.
Understand the responsibilities of Novotech as a service provider in the pharmaceutical industry and ensure all communications with external parties present a positive professional image of the company.
Degree in a computer science, information technology and/or information systems
Experience in preparing reports/dashboard across various clinical trial systems, ERP or other applications in a CRO and/or Pharmaceutical industry is advantageous.
Minimum Qualifications & Experience:
Degree in a computer science, information technology and/or information systems
Experience in preparing reports/dashboard across various clinical trial systems, ERP or other applications in a CRO and/or Pharmaceutical industry is advantageous.
Skills
Sign in to read and join the discussion.