Senior Specialist Business Intelligence

We are growing, grow with us!
Are you looking for a dynamic company with daily new challenges and opportunities?
Then, Pharmalex (now part of Cencora) is your next career move! Pharmalex is one of the leading service companies for the Pharmaceutical Industry globally and is specialized in all aspects of drugs and medical devices approval, of the market development and any action of effective product maintenance.
Senior Specialist Business Intelligence
We are seeking qualified BI Specialists to build and verify new data models that will help in decision-making.
You will be responsible for designing, developing, and deploying business analytics dashboards using Microsoft BI technologies, such as the Azure suite of technologies, SQL, Power BI, etc., as well as develop both physical and logical data models.
On top of it, we expect you to take a leading role in evaluating new data warehouse applications, architecture, and technology choices, and maintain plus develop various database scripts and tools to facilitate automation process.
Your Job

• Analyse all data warehouse architecture goals and identify skill requirement for same
• Prepare design for all metadata according to various ETL processes.
• Perform troubleshoot on all ETL processes and resolve issues effectively.
• Define meta data standards for the data warehouse.
• Develop various ETL processes and prepare OLAP cubes (probably in the future).
• Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more.
• Designs and implements highly scalable ETL processes with complex data transformations and data formats including error handling and monitoring.
• Maintains and supports the data model by implementing and managing strategies for tuning and optimization for stability and performance.
• Convert raw data into meaningful analysis with the help of interactive, easy-to-understand dashboards and reports.
• Build automated reports and dashboards with the help of Power BI and other reporting tools.
• Understand business requirements to set functional specifications for reporting applications.
• Be able to quickly shape data into reporting and analytics solutions.

Your Profile

• Very good command of English
• Autonomous, concentrated, and high-quality work
• Ability to work in a team (highly valued)
• Previous experience on international projects
• Agile methodology implementation knowledge
• Capacity to create documentation, technical but functional documents even
• Azure DevOps knowledge
• Knowledge on the following technologies
  • MS SQL Server BI Stack
  • Power Query
  • MDX
  • Understanding of PowerBI
  • DAX
  • DevOps
    • Releases
    • Pipelines
  • Microsoft Azure Ecosystem
    • Azure SQL
    • Synapse
    • Familiarity with Fabric
    • SQL DW
    • Data Factory
    • Azure Data Lake
• Expertise connecting to data sources, importing data, and transforming data for Business Intelligence

Desiderable skills:

• Familiarity with JavaScript, CSS, and other JavaScript libraries
• Sincerity and assertiveness are highly valued.

If you are interested in joining our Pharmalex team taking over this challenging job opportunity in our future-oriented company, we are looking forward to receive your application documents stating your earliest possible starting date, any visa requirements and salary expectations on-line.
For further information please don’t hesitate to contact us.

Agencies only by prior agreement for the specific job opportunity.