Data & BI Analyst

Posted 5 Hours Ago
2 Locations
In-Office or Remote
Entry level
Biotech
The Role
Develops and maintains business intelligence dashboards, reports, data models, workflows, and automated analytics processes. Optimizes CRM Analytics and Power BI datasets, dataflows, queries, refreshes, and row-level security. Collaborates with stakeholders to gather reporting requirements, analyze clinical, ERP, and IT application data, resolve discrepancies, and deliver accurate standard and ad hoc insights. Uses tools including DAX, Power Query, Snowflake, ETL processes, ServiceNow, and JIRA while supporting reporting improvements in a pharmaceutical CRO environment.
Summary Generated by Built In

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

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. 

Qualifications

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. 

About Us

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.

About the Team

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
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Sydney
1,524 Employees

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.

Similar Jobs

Hilton Logo Hilton

Commis I

Events • Food • Travel • Hospitality • Hotels & Resorts
Remote
2 Locations
500000 Employees

Mondelēz International Logo Mondelēz International

Platform Engineer

Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Remote or Hybrid
India
90000 Employees

Rubrik Logo Rubrik

Sales Specialist Identity, APJ

Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Cybersecurity • Data Privacy
Remote
India
3000 Employees

LogicMonitor Logo LogicMonitor

Senior Technical Writer

Artificial Intelligence • Cloud • Information Technology • Machine Learning • Software
Easy Apply
Remote or Hybrid
Pune, Maharashtra, IND
1100 Employees

Similar Companies Hiring

Formation Bio Thumbnail
Artificial Intelligence • Big Data • Healthtech • Biotech • Pharmaceutical
New York, NY
150 Employees
SOPHiA GENETICS Thumbnail
Software • Healthtech • Biotech • Big Data • Artificial Intelligence
Boston, MA
450 Employees
Pfizer Thumbnail
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
New York, NY
121990 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account