IT Developer SQL
– Who loves data and the connections it creates between people, processes, and systems
We are currently looking for a specialist who knows T-SQL inside out and takes pride in optimizing the existing solutions, ranging from simple statements to frameworks built-in SQL. You also know of VB scripts in Excel and Access, and you have a positive approach to teamwork and networking with internal customers, taking joy in delivering your best within the constraints given. If this is you, you might be our new colleague.
About the job
At Orifarm you will be part of a professional and international environment, where you will work closely with key business partners and, together, optimize their work. Our IT Business Application OLTP team is responsible for the flow and presentation of data used for the daily business in Orifarm. You will help streamline the business processes by transferring data between internal and external systems. You will also maintain a legacy data warehouse with multiple business-critical reports, cubes, and applications on top. We provide services to the entire Orifarm group, including all processes from the conception of new business opportunities, to purchase, to production, to sales, spread over 9 countries.
You will service the day-to-day business, including on-call duties, deliver small changes and fixes, and participate in projects of varying sizes together with your colleagues in our office in Odense, Denmark.
Who are you?
You're a positive team player who has graduated an IT-related education or maybe gained a high level of SQL knowledge during your work. You appreciate contact with internal business users, to help optimize their processes, train them in the developed systems, and sometimes reverse engineering solutions to answer very specific questions.
It is important that you:
- are highly motivated to work with SQL and have a lot of experience and/or flair for it
- are familiar with VB script in Excel and Access
- can be physically present in our headquarters in Odense.
- can perform T-SQL optimizations at many levels of complexity
- are a quick learner and enjoy expanding your skillset
- can communicate fluently in Danish and English, both written and orally
It is an advantage if you have knowledge in:
- Excel & Access
- Microsoft Dynamics Ax 2009
- GxP / Gamp5 / GDPR
- the workflow in a Sales and Production company
- have worked with SSIS, SSRS, and SSAS and can maintain existing solutions
- Microsoft Azure SQL Database
Who are we?
Group IT is located in Odense, with sub-departments in Czech and Germany. We are more than 30 specialists working with IT from Operations and Support to Software development and Reporting. The Business Application team consists of 8 people, working with OLTP and design and implementation of applications to our business. We support over 90 ‘systems’; from simple reports to applications that support pricing and allocation of products, assist with the registration of products alongside the medical authorities, the process regarding expanding our product pool and following through with new launches, among others.
In the OLTP sub-team, currently consisting of 4 people, we help optimize the processes in the business by analyzing and developing the data infrastructure for the applications they use. We are an energetic team who meet challenges with enthusiasm. We come from different backgrounds and constantly strive to deliver useful solutions to our businesses that bring value, and that our users love.
As a pharmaceutical company, we live up to Gamp5 and GxP and document our changes accordingly. We coordinate the implementation of changes with our other teams, like Operations, AX and BI, for optimal process flow.
Orifarm is the largest parallel importer of pharmaceuticals in Europe and the largest supplier of pharmaceuticals in Denmark. Orifarm was founded in 1994 by Hans and Birgitte Bøgh-Sørensen and, through our main businesses areas, parallel imported pharmaceuticals and generics, we create competition and provide large savings for society and consumers. The explorer spirit still characterizes the company, as we are constantly looking for new opportunities and business areas to invest in. Our mission is to make important savings for society and to ensure that the consumers get better value for money. We strive to make this happen while insisting on being good colleagues, improving together, helping each other and innovating.
In Orifarm we place great emphasis on both your professional and personal development and on giving you the opportunity to bring all of your skills into play.
We are located in Odense, where you will work with our dedicated colleagues in an open office environment, which allows us to have a friendly and informal atmosphere.
We offer a competitive compensation & benefits package and our staff canteen offers a variety of healthy menus every day, and physiotherapy will also be at your disposal.
Feel free to apply in Danish or English.
If you need further information about the job, please contact Team Manager Steen Palle, StPal@Orifarm.com
As soon as possible
If you experience problems applying with Internet Explorer, we recommend trying it in a different browser.