Global Business Intelligence Consultant

Deadline: May 24, 2024
Ambitious Global Business Intelligence Consultant
your role
As the Global Business Intelligence Consultant, you have the overall responsibilities for development and maintenance of the in-house elements of Pharmacosmos’ Business Intelligence and data platform in our US affiliate. At Pharmacosmos our aim is to take advantage of modern data platforms and build on the existing success within reporting and data usage.

In the initial phase of the job, your role will primarily involve gaining a detailed overview of and analyzing the current extensive US data setup, the data landscape and data flows and technologies employed. Today, the setup is developed and maintained by an external vendor. Based on careful analysis of feasibility, pros and cons, you will identify those parts of the BI and data platform that can be meaningfully transitioned in-house. Once the intended in-house scope has been defined and agreed, the transition project is planned and executed – with external expert support for building data solutions in Azure. You will work closely with your US colleagues and the vendor during all aspects of this development. This will be a challenging project requiring a full employment of your data understanding and project management skills.

Later on, your role may evolve into a more hands-on and developmental role building data solutions (backend and frontend) for US, head quarter and other affiliates, but it will also depend on your preferences for personal growth. In this position, you will be the main driver of BI excellence in Pharmacosmos US, and you significantly impact the data vision and strategy of “how we use data” in Pharmacosmos.

The role requires a good business acumen on top of extensive experience with Business Intelligence, and a profound understanding of both the frontend and backend aspects. You should be prepared to be persistent in analytical work, but also able to think strategically and provide recommendations for "best practice" based on your technical understanding and architectural skills.

You will be part of the Strategic Projects and Systems group and will report directly to the Director of this group.

your tasks
Ownership of Pharmacosmos’ data warehouse (Azure Data Factory/SQL-based) for use in Pharmacosmos US. Responsible for establishing, developing and maintaining the platform.

• Project lead in the building and developments of the platform, typically using external providers.
• Continual improvement of our data availability and data insights based on the needs of the organization.
• Daily/monthly monitoring of data loads and error-finding.
• Fluent collaboration with the external vendor; ensuring responsibilities are clearly defined and in-house / outsourced data resources and processes are integrated and operational.
• Ensure all parts of the BI and data platform are properly documented by you and external vendor.

Consulting responsibility for the Power BI front end and other reporting

• Expert support to US colleagues in Strategy and Operations in terms of report development. Translate business reporting needs to technical specifications for Power BI reports.
• Oversee the building of Power BI by external providers. Act as expert reviewer.
• Pro-active data services to senior business managers and the management team. Lend your expertise in guiding the further optimization of the reporting landscape.

Data integrity

• Evaluate and ensure a very high level of data integrity across the data platform.
• Quality control checking and testing of developed data solutions.

Communication and visibility

• Ensure visibility and knowledge of the in-house BI and data platform. Clarify how this serves us and how it may be meaningfully developed.
• Enablement – assist key US colleagues in understanding the data sources and flows, heightening our collective control of the platform.

who are you
You are an experienced Business Intelligence Consultant with a good understanding of both business and technology, and you are willing to take the lead. You are accustomed to taking the lead and being responsible for ensuring efficient data integration and processing for our business analysis and reporting.

Your skills and experience are within:

• Advanced user of Microsoft Power BI
• Proficient in SQL (T-SQL is an advantage)
• Familiar with ETL/ELT/Integration/Workflow/Task Automation tool (e.g., Azure Data Factory, Logic Apps, Azure Functions, SSIS etc.)
• Experience with Databricks would be an advantage.
• Analytical skills – can dive into new problem areas and data domains and understand the architecture and data flows
• Motivated by improving business performance with insights from data.
• Experience working with data typical of pharmaceutical sales in the US would be an advantage.

Specific requirements:

• Fluency in spoken and written English
• Danish resident

personal competencies
With excellent analytical skills and an open-minded approach to communication, combined with your natural ability to connect with others, you adeptly tackle complex challenges. You're known for your strong sense of accountability, consistently delivering on agreements in a timely manner. As a self-driven and systematic individual with a keen eye for detail, you're always seeking ways to enhance the platform and processes. Your robust interpersonal skills enable you to collaborate effectively with others, exuding natural authority while maintaining an easy-going demeanor. You're a pragmatic and operationally minded thinker, always seeking practical solutions to challenges.

Additional information
Place of work is Pharmacosmos HQ in Holbæk. We offer flexible work from home opportunities which can be arranged with your direct manager. Limited travel may be required (5-10 days per year).

Contact and Application
We process applications and arrange interviews continually. Hence, we recommend that you apply as soon as possible here. This recruitment process is handled by our partner, consulting firm Sylvest+. Please feel free to contact HR Business Partner Thomas Sylvest on tel. +45 60 57 65 00 or e-mail at [email protected] if you have questions about the position. Note that you can write your application in either Danish or English according to your preference.