We are the company that cares for our staff, for our clients, for our partners and for the quality of the work we do. A dynamic, global company founded in 1995, we bring together more than 2,000 driven, dedicated and passionate individuals.
We work on the frontline of medical science, changing lives, and bringing new medicines to those who need them.
As part of the newly established analytics team you will be shaping our global data infrastructure and enabling employees across the business to transform data into meaningful insights and profitable decisions.
You will collaborate with an inspired team of analytics specialists and work with a wide array of internal and external data sources to power innovative data solutions that help optimise clinical trials and accelerate the development of new medicines.
Office based in Bucharest
You will :
Design, develop, deploy and maintain new business intelligence solutions
Partner with the Senior Data Architect to create a hybrid data warehouse
Consult with the business to ensure that the data warehouse meets evolving business requirements
Build ETL and ELT pipelines to migrate data from internal and external sources
Translate business needs into technical solutions and specifications
Gather requirements, design / deliver reporting and automation solutions
Develop a data environment that facilitates accurate and consistent reporting
Maintain pre-production, UAT deployment and live environments
Develop technical documentation and implement change requests
Monitor, troubleshoot and debug BI solutions
Respond to and resolve issues that impact data quality
Collaborate closely with the Data Governance and Information Security team to drive data quality and regulatory compliance
Collaborate with IT and Systems Development to integrate new tools and data models into a digital ecosystem
Establish and support self-service analytical and reporting capabilities across all departments, including facilitating training of end-users for new applications
Passionate about data quality with expert knowledge of the Microsoft Business Intelligence stack. You will build the required structures to extract, transform and deliver data to stakeholders using MS SQL DB, SSIS, SSRS and SSAS
Experience in data warehouse design
Extensive ETL development experience
Experience in querying and structuring relational databases using SQL
Knowledge of dimensional design, database structures and query optimization
Hands-on experience of BI Platforms such as QlikSense, Tableau, PowerBI, Spotfire or similar
Experience working in an agile framework development model
Proven ability of partnering with stakeholders across all levels including analytics professionals, operational staff and executives to build required data models and reports
Ability to work independently, self-directed and solutions oriented
Nice to have :
Experience in Azure SQL Data Warehouse and Azure Data Factory
Comfortable working with various heterogeneous data sources to build visualizations (e.g. SQL, NoSQL, Files, Data Lakes and Warehouses, Streaming Data)
Interaction with REST APIs and web services
Experience in a pharma or clinical research setting, would be an advantge
You are also likely to hold a degree in a quantitative field such as Computer Science, Statistics, Math, Physics, Finance, Economics, or other similar
Realize your full career potential by joining our team and work on projects that positively impact the life of patients across the world.