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.
ResponsibilitiesResponsibilities:
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 a global full-service clinical Contract Research Organization (CRO).
At Novotech, ambition meets opportunity. As a globally recognized leader in clinical research and scientific advisory services, we are proud to combine our position at the forefront of the industry with an award-winning workplace culture that values ambition, innovation, and growth. Named Employer of Choice, Great Place to Work and Employer of Choice for Gender Equality (EOCGE), we are committed to fostering an environment that reflects the life-changing work we do.
Since 1997, we have expanded our global footprint, now with 30+ offices across Asia-Pacific, the United States, and Europe. This growing network unites professionals from diverse backgrounds and disciplines to advance therapies that improve patient outcomes worldwide.
At Novotech, our employees are at the heart of our success. By offering trust, flexibility, and autonomy through programs like NovoLife, our flexible benefits framework, we empower team members to create an effective work-life balance that delivers professional satisfaction and maximum results for clients.
With access to mentorship opportunities, professional development programs, and a dynamic community, Novotech offers a platform for driven individuals to achieve personal growth while shaping the future of healthcare. Join us to be a part of a team that values your contributions and supports your ambition to make a global impact.
At Novotech we have advanced therapeutic and regulatory expertise, the ability to execute across markets and a client-centric service model, so that our clients get a trusted, long-term partner and an accelerated path to bring their life-changing advances to market. This gives our employees the opportunity to develop their careers by joining a diverse and supportive global organization with a collaborative culture, whilst working with clients on the cutting-edge of life sciences.
At Novotech you will work alongside empowered teams with a shared commitment to success.
- Strategic vs transactional mindset.
- Ability to gain insights and make proactive decisions quickly.
- Culture that fosters partnership and collaboration, where every voice is heard and valued.
- Ongoing support from senior stakeholders and leadership team.
Skills Required
- Degree in computer science, information technology, or information systems
- Experience preparing reports and dashboards across clinical trial systems, ERP, or other applications in a CRO or pharmaceutical industry
What We Do
Novotech is a leading Asia-Pacific biotech specialist CRO and consists of two operating brands, "Novotech" and "PPC". Novotech is a full-service clinical CRO with labs, phase I facilities, and drug development consulting services.









