BI Developer
Our Vision
P\S\L Group is a global organisation dedicated to putting information at the service of medicine. The companies and people of the P\S\L Group aim to improve medical care by serving those who need it, those who provide it and those who seek to improve it.
To this end, we want our information and education services to contribute to the goals we share with our clinicians, clients and supporters, namely: to accelerate the advancement of medicine and help people enjoy better, longer lives.
Purpose
Our key contribution to society is to help clinicians and those who support them provide state-of-the-art medical care.
Our primary business purpose is to help clients and supporters increase the effectiveness of activities pertaining to scientific communication, medical education and the maintenance of clinician audience intimacy.
Position Summary
Responsible for delivering business insights and enterprise-wide reporting to support data-driven decision-making and performance oversight. Key responsibilities include designing and developing interactive visualizations and analytics using Tableau, and creating robust reporting datasets through Snowflake for both internal and external stakeholders. The position plays a vital role in optimizing reporting processes by automating client report delivery and establishing a consolidated metrics repository to ensure consistency across all reports. Additionally, the role requires maintaining accurate and comprehensive technical documentation to support ongoing analytics and reporting initiatives.
Key Responsibilities
- Delivering business insights and reporting across the enterprise to support decision making and performance oversight including:
- Using Tableau to build interactive visualizations and analytics.
- Creating reporting data sets to be used internally and externally using Snowflake.
- Optimizing reporting processes - such as automated delivery of client reports.
- Developing a consolidated metrics repository to drive consistency across reports.
- Technical documentation.
Key Skills, Knowledge & Professional Education
- Bachelor’s degree or in final term in an IT/Math/Quantitative discipline
- Excellent analytical and problem solving skills
- Excellent attention to detail
- Experience with programming and data analysis using SQL
- Understanding of database models and design (both SQL and noSQL)
- Experience with data profiling, data cleansing, data wrangling, data quality, standardizations, transformations etc
- Experience with BI tools such as Tableau, Power BI, Domo, among others.
- Experience with relational SQL, including PostgreSQL Snowflake, and MSSQL
- Advanced working SQL knowledge and experience working with relational databases - both operational DBs and data warehouses
- Strong analytic skills related to working with unstructured datasets.