Analytics and Reporting Senior Developer

Regulatory Data Office (RDO)

Macclesfield / Luton (Hybrid)

As an Analytics and Reporting Senior Developer and member of the RDO Analytics and Reporting team you will be responsible for the development and maintenance of reports and dashboards, as well as providing ad hoc expertise and advice in support of regulatory stakeholders, ensuring delivery of analytical and reporting services in support of the Regulatory business, with a specific focus on regulatory compliance and data quality as well as strategic-enabling support to the wider enterprise stakeholders.

As an Analytics and Reporting Senior Developer You will also be driving innovation and the deployment of analytical solutions that address business challenges and needs, ensuring Regulatory business can gain full value from the available information to enable compliance and deliver competitive advantage.

You do this by providing critical information in support of business strategy and performance, enterprise-wide regulatory compliance tracking, data quality improvement, externalisation, benchmarking, trend analysis, process improvements and decision support.

As an Analytics and Reporting Senior Developer we think you will have a robust understanding of regulated procedures, systems and data, and an ability to interpret, integrate and present complex data analysis to a broad range of customers, preferably in the pharmaceutical industry.

As an Analytics and Reporting Senior Developer your responsibilities can also include:

Data model design in relation to the analytics platform with respect to the Veeva Enterprise Regulatory Vault (ERV) implementation, including query and report optimisation, data quality and compliance.

Change Management of the analytics platform, with respect to ERV, including impact assessments on the Oracle data model and existing reports, GxP documentation changes and the development and execution of system test scripts.

Development of data integration workflows using ETL platforms such as Snap Logic and/or Snowflake procedures.

Rapid development of tactical solutions to solve acute business problems, such as data quality or compliance issues using Microsoft Power Apps or similar “low code” frameworks.

Development of advanced SQL (in Oracle or Snowflake) and PL/SQL scripts to respond to business requirements.

Maintenance and development of existing portfolio of reports/dashboards and KPIs across various technical platforms (Spotfire, Power BI, Power Apps, Excel VBA, Python), providing continuous improvement and customer support.

Analytical input where required to key performance metrics, internal and external benchmarks, compliance and data quality issues, as well as responding to ad hoc business requirements, including requests in support of internal/external audits and health authority inspections.

Provide data modelling expertise, specifically with a view to integrating data across Regulatory Information Management (RIM) systems including, but not limited to Applications and Registrations, Submissions and Documents and Publishing.

In liaison with quality managers develop and maintain robust business and technical documentation, including GxP documentation, analytical outputs, visualization, data models, data flows and training material (as required).

Foster an Agile approach and lean methodology in the development of new and existing solutions and services.

As an Analytics and Reporting Senior Developer the Essential skills for the role:

In-depth knowledge of data model design and advanced SQL, preferably in Snowflake or Oracle environment (PL/SQL).

Data visualisation experience with Power BI.

Experience from working in a regulated environment with proven ability of interpreting and integrating complex data sets and communicating them effectively.

Experience in managing regulated systems (GxP) and the associated procedures and documentation.

Experience in performance metrics & KPI’s

Knowledge and experience in Agile methodologies for solutions implementation and system development.

Highly developed conceptual and analytical thinking, with ability to understand multiple, sophisticated business needs, and convert these requirements into data products.

Experience working in a global matrix organisation

As an Analytics and Reporting Senior Developer what is Desirable for the role:

Experience from working with Veeva Vault solutions, including its configuration and data model.

Understanding of the procedures, processes and standards governing the submission and exchange of electronic information (documents and data) with health authorities worldwide, including familiarity with regulatory data-driven initiatives such as EVMPD and IDMP.

Experience in using artificial intelligence (e.g. ML, NLP) to enable analytics services and interpreting complex data sets.

Advanced experience in Power BI DAX scripting.

Osirian Consulting is committed to working with our clients to promote equality and diversity in the workplace. We encourage and welcome applicants from all backgrounds and all sections of the community, and will never discriminate on the basis of race, gender, disability, or any other protected characteristic.

Please be aware that due to the high number of applications we receive, unfortunately we cannot respond to each application individually. If you do not hear back from one of our consultants within 14 days, then unfortunately you have not been shortlisted for this role.

Osirian Consulting is acting as a recruitment business in relation to this role