[Hiring] BI & Analytics Developer @uMed

Role Description

The BI & Analytics Developer is responsible for developing and maintaining uMed's business intelligence and analytics solutions, enabling teams across the business to access accurate, reliable, and useful information. The role will primarily work within Zoho Analytics, building and maintaining data preparation processes, data models, query tables, datasets, pipelines, reports, and dashboards to support operational, product, clinical research, and management reporting.

This is a hands-on role combining BI development with ad hoc data analysis. The BI & Analytics Developer will work with stakeholders to understand their questions and reporting needs, determine the most appropriate way to address them, and translate those requirements into effective reporting or analytical solutions. This may range from developing a new dashboard or reusable dataset to performing ad hoc analysis directly against underlying data.

The role requires someone who is comfortable working with data beyond the visualization layer. They should be able to use SQL to investigate underlying data, understand relationships between datasets and how data moves through reporting solutions, troubleshoot discrepancies, and determine whether issues originate within the BI layer or upstream.

Qualifications

• Experience working with healthcare or clinical research data, with an understanding of the complexity and sensitivity of healthcare data.
• Experience developing BI and analytics solutions using Zoho Analytics, Power BI, Tableau, Looker, or a comparable BI platform.
• Strong SQL skills, with experience querying, joining, transforming, and validating data.
• Strong understanding of relational data modeling, including table relationships, keys, joins, cardinality, and the impact of data model design on reporting and aggregation.
• Experience building and maintaining datasets and data preparation or transformation workflows for reporting and analytics.
• Experience developing reports and dashboards for operational, analytical, and management use.
• Experience performing ad hoc data analysis to answer business questions.
• Understanding of good data management practices and the ability to apply them when developing BI and analytics solutions.
• Ability to investigate data discrepancies systematically and trace issues through different layers of a data solution.
• Experience modifying existing BI solutions safely, with an understanding of dependencies and downstream impact.
• Strong attention to detail and a commitment to data accuracy and quality.
• Ability to understand business requirements and translate them into effective analytical and reporting solutions.
• Strong problem-solving skills and the ability to work independently through complex data questions.
• Strong communication and collaboration skills, with the ability to work effectively with both technical and non-technical stakeholders.

Requirements

• Design, build, and maintain datasets, reports, and dashboards within Zoho Analytics.
• Build and maintain data preparation processes, pipelines and other transformations within Zoho Analytics to support reporting and analytics.
• Create and maintain query tables, using SQL to combine, transform, and prepare data for reporting and analysis.
• Design and maintain data models within Zoho Analytics, including defining appropriate relationships between tables and selecting the correct relationship fields and cardinality.
• Understand the impact of table relationships and data model changes on calculations, aggregation, and downstream reporting.
• Develop calculated fields, formulas, filters, and other reporting logic to produce accurate, meaningful outputs.
• Build clear, intuitive dashboards that enable users to understand and explore data effectively.
• Develop reusable datasets and reporting solutions where appropriate, reducing duplication and enabling greater self-service across the business.
• Apply good data modeling, transformation and data management practices when developing BI and analytics solutions.
• Perform ad hoc analysis to answer business, operational, and research-related questions using available data.
• Use SQL to interrogate underlying datasets and warehouse data.
• Investigate discrepancies or unexpected results within reports and dashboards.
• Regularly monitor BI datasets, data preparation processes, pipelines, scheduled refreshes, reports and dashboards to ensure data remains current and reliable.
• Implement appropriate data quality checks and monitoring within the BI environment.
• Help maintain a well-structured, reliable, and efficient Zoho Analytics environment.
• Maintain clear and up-to-date documentation for data models, datasets, data preparation processes, query tables, pipelines, reports and dashboards.
• Troubleshoot BI-related issues including failed refreshes, broken reports, incorrect calculations, and unexpected data.
• Work with stakeholders across Product, Operations, Clinical, Commercial and other areas of the business to understand reporting and analytical requirements.

Benefits

• Private Health Insurance to keep you covered.
• Pension Plan to help you secure your future.
• 25 days of paid time off for your well-deserved breaks.
• Work From Home equipment budget for a comfortable working space.
• Flexible Benefits platform tailored to your needs.
• Enjoy your Birthday Day Off on us!
• Eye-test vouchers for Specsavers to look after your eyesight.
• Coworking policy – catch up with the team as regularly as once a week.
• Enhanced Parental Leave.