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.
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.
* Provide Datamodelling expertise, specifically with a view to integrating data across Regulatory Information Management (RIM) systems.
* 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.
* Foster an Agile approach and lean methodology in the development of new and existing solutions and services.
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 to interpret and integrate complex data sets.
* 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 the ability to understand multiple, sophisticated business needs.
* Experience working in a global Matrix organisation.
Desirable skills for the role:
* Experience from working with Veeva Vault solutions.
* Understanding of the procedures, processes and standards governing the submission and exchange of electronic information with health authorities worldwide.
* Experience in using artificial intelligence (e.g., ML, NLP) to enable analytics services.
* Advanced experience in Power BI DAX Scripting.
Osirian Consulting is committed to promoting equality and diversity in the workplace. We encourage and welcome applicants from all backgrounds and will never discriminate on the basis of race, gender, disability, or any other protected characteristic.
#J-18808-Ljbffr