<div id='hrsky-content' style='margin-bottom:5px'> <h1>IT Developer SQL</h1><h3><strong>&ndash; Who loves data and the connections it creates between people, processes, and systems</strong></h3> <p><em>Are you a specialist who knows T-SQL inside out and take pride in optimizing the existing solutions, ranging from simple statements to frameworks built in SQL? Do 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, then you might be our new colleague.</em></p> <p><strong>About the job</strong></p> <p>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. We help streamline the business processes by transferring data between internal and external systems. We also maintain a legacy data warehouse with multiple business critical reports, cubes, and applications on top. Our customers are the entire Orifarm group, including all processes from the conception of new business opportunities, to purchase, to production, to sales, spread over 9 countries.</p> <p>You will service the day-to-day business, including on-call duties, deliver small changes and fixes, and participate in projects of varying sizes.</p> <p><strong>Who are you?</strong></p> <p>You&#39;re a positive team player who has graduated with 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.</p> <p>It is important that you:</p> <ul> <li>are highly motivated to work with SQL and have a lot of experience and/or flair for it</li> <li>can be physically present in our headquarters in Odense</li> <li>can perform T-SQL optimizations at many levels of complexity</li> <li>have worked with SSIS, SSRS, and SSAS and can maintain existing solutions</li> <li>are a quick learner and enjoy expanding your skill set</li> <li>can communicate fluently in Danish and English, both written and orally</li> </ul> <p>It is an advantage, if you have knowledge in:</p> <ul> <li>C#</li> <li>Excel</li> <li>VB (and VB script)</li> <li>Microsoft Dynamics Ax 2009</li> <li>GxP / Gamp5 / GDPR</li> <li>the workflow in a Sales and Production company</li> </ul> <p><strong>Who are we?</strong></p> <p>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.</p> <p>The Business Application team consists of 8 people, working with OLTP and design and implementation of applications to our business. We support over 90 &lsquo;systems&rsquo;; from simple reports to applications that support pricing and allocation of products, assist with the registration of products with the medical authorities, and the process regarding expanding our product pool and following through with new launches, among others.</p> <p>In the OLTP sub team, currently consisting of 3 people, we help optimize the processes in the business by analyzing and developing the data infrastructure for the applications they use.</p> <p>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 brings value, and they love to use.</p> <p>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.</p> <p><strong>Our values</strong></p> <p>The explorer spirit still characterizes Orifarm, although we have now become a large, international company since Hans and Birgitte B&oslash;gh-S&oslash;rensen founded the company in 1994. Our mission is to make important savings for the society via parallel imported and generic pharmaceuticals and to ensure that the consumers get better value for money. Seriously and determined, we strive to make this happen while insisting on being good colleagues, improving together, helping each other and innovating. This attitude may be of benefit to you.</p> <p><strong>We offer</strong></p> <p>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.</p> <p>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.</p> <p>We offer a competitive compensation &amp; benefits package and our staff canteen offers a variety of healthy menus every day, and physiotherapy will also be at your disposal.</p> <p> </p> <p>If you need further information about the job please contact:</p> <p><strong>Steen Palle</strong><br> Team Manager<br> <a href="mailto:stpal@Orifarm.com">stpal@Orifarm.com</a></p> <div class="block"> <p style="margin-bottom: 5px !important"> <strong>Application deadline:</strong> </p> As soon as possible </div> <div class='contacts' style='margin-top:20px'> </div> <script> var rollState = 'down'; window.addEventListener( "message", function (e) { if(e.origin !== 'https://hr-skyen.dk'){ return; } if(e.data == 'rollup'){ $('#hrsky-content').slideUp(); rollState = 'up'; } if(e.data == 'rolldown'){ $('#hrsky-content').slideDown(); rollState = 'down'; } if(e.data == 'toggle'){ if(rollState == 'up') { $('#hrsky-content').slideDown(); rollState = 'down'; } else { $('#hrsky-content').slideUp(); rollState = 'up'; } } }, false); </script> <span style="clear:both;display:block">If you experience problems applying with Internet Explorer, we recommend trying it in a different browser.</span> <script src="https://hr-skyen.dk/hr/frame-api/hr.js" type="text/javascript"></script> <div id="hrskyen"></div> <script type="text/javascript"> getScript(HR_WEB_ROOT+'js/easyXDM/easyXDM.min.js', function() { hrsky = new HRSkyen({ companyId:67, persistent:{ theme:'orifarm-api', joblisturl:location.href }, locale:'en_US', container:'hrskyen', queryKey:'hr', search:'hr=show-job|50814', action:'show-job|50814' }); }); </script> <br> <div style="display:none;" class="application" style="clear:both;" id="applyposition"> <span style="cursor:pointer;text-decoration:underline;" class="toggleDescription"></span><br> <br> <br><form method="post" class="formular validateonsubmit" action="frame-api/pages/iframe.show.job.php?version=1&amp;locale=en_US&amp;jobid=50814&amp;xdmframe=2&amp;theme=orifarm-api&amp;companyid=67&amp;filters=en_US"> <input type="hidden" name="formApplication" value="1"><div class="tabs"><div class="tabcontent"> <input type="hidden" name="Application[f0][locale]" value="en_US"><input type="hidden" name="Application[f0][companyid]" value="67"><input type="hidden" name="Application[f0][jobpostid]" value="50814"><input type="hidden" name="Application[f0][referrer]" value="none"><input type="hidden" name="CV[f0][origin]" value="form"><input type="hidden" name="Application[f0][departmentid]" value="702"><input type="hidden" name="jobid" value="50814"><input type="hidden" name="CV[f0][departmentid]" value="702"><div class="tab selected"> <h2 class="tabtitle">Basic information</h2> <div> <fieldset class="fieldset fieldSet1"><h2></h2></fieldset> <fieldset class="fieldset fieldSet2"> <h2>Basic information</h2> <div class="inputrow name"> <label><span class="requireddot">*</span><span class="label-text">Name</span></label><input type="text" autocomplete="off" name="CV[JobApplicant][f0][name]" class="required" value="" onblur='fieldValidate(this, "JobApplicant", "name")'> </div> <div class="inputrow dateofbirth"> <div class="helpmsg">Four digits - e.g. 1977</div> <label><span class="label-text">Year of birth</span></label><input type="text" autocomplete="off" name="CV[JobApplicant][f0][dateofbirth]" value="" onblur='fieldValidate(this, "JobApplicant", "dateofbirth")'> </div> <div id="imagefield-id-JobApplicant-image" class="inputrow"> <label><span class="label-text">Picture</span></label><div id="imagefield-id-JobApplicant-imagec" class="imageuploadercontent"> <input type="hidden" name="CV[JobApplicant][f0][image]" id="id-JobApplicant-image" value=""><img style="display:none"><div class="imagename"></div> <iframe src="https://hr-skyen.dk/hr/attachment.upload.php?type=image&amp;file=%20%20&amp;fieldname=imagefield-id-JobApplicant-image&amp;theme=orifarm-api&amp;theme=orifarm-api&amp;locale=en_US" class="imageuploadframe" scrolling="no" frameborder="0" allowtransparency="true" style="height:50px;width:260px;"></iframe> </div> <div style="display:block;clear:both;line-height:1px;font-size:1px;height:1px;overflow:hidden;"></div> </div> </fieldset> <fieldset class="fieldset fieldSet3"> <h2>Your address</h2> <div class="inputrow road"> <label><span class="requireddot">*</span><span class="label-text">Address</span></label><input type="text" autocomplete="off" name="CV[JobApplicant][Location][f0][road]" class="required" value="" onblur='fieldValidate(this, "Location", "road")'> </div> <div class="inputrow address_zip zip"> <label><span class="requireddot">*</span><span class="label-text">Postal code</span></label><input type="text" autocomplete="off" name="CV[JobApplicant][Location][f0][zip]" class="required" value="" onblur='fieldValidate(this, "Location", "zip")'> </div> <div class="inputrow city"> <label><span class="requireddot">*</span><span class="label-text">City</span></label><input type="text" autocomplete="off" name="CV[JobApplicant][Location][f0][city]" class="required" value="" onblur='fieldValidate(this, "Location", "city")'> </div> <div class="inputrow email"> <label><span class="requireddot">*</span><span class="label-text">E-mail</span></label><input type="text" autocomplete="off" name="CV[JobApplicant][Contact][f0][email]" class="required" value="" onblur='fieldValidate(this, "Contact", "email")'> </div> <div class="inputrow phone"> <label><span class="label-text">Phone</span></label><input type="text" autocomplete="off" name="CV[JobApplicant][Contact][f0][phone]" value="" onblur='fieldValidate(this, "Contact", "phone")'> </div> <div class="inputrow mobile"> <label><span class="label-text">Mobile</span></label><input type="text" autocomplete="off" name="CV[JobApplicant][Contact][f0][mobile]" value="" onblur='fieldValidate(this, "Contact", "mobile")'> </div> </fieldset> </div> </div> <div class="tab"> <h2 class="tabtitle">Application and CV</h2> <div> <fieldset class="fieldset fieldSet4"><h2></h2></fieldset> <fieldset class="fieldset fieldSet5"> <h2>Profile overview</h2> <div class="inputrow title"> <label><span class="requireddot">*</span><span class="label-text">CV Title</span></label><input type="text" autocomplete="off" name="CV[f0][title]" class="required" value="" onblur='fieldValidate(this, "CV", "title")'> </div> <div class="inputrow experience"> <label><span class="label-text">Years of experience</span></label><select name="CV[f0][experience]"><option value="0">Select <option value="0-2 years">0-2 years <option value="3-5 years">3-5 years <option value="6-10 years">6-10 years <option value="more"> more</select> </div> <div class="inputrow eduname"> <label><span class="label-text">Education name</span></label><input type="text" autocomplete="off" name="CV[f0][eduname]" value="" onblur='fieldValidate(this, "CV", "eduname")'> </div> <div class="inputrow eduyear"> <label><span class="label-text">Graduation year</span></label><input type="text" autocomplete="off" name="CV[f0][eduyear]" value="" onblur='fieldValidate(this, "CV", "eduyear")'> </div> <div class="inputrow edulevel"> <label><span class="label-text">Level of education</span></label><select name="CV[f0][edulevel]"><option value="0">Select <option value="Basic education">Basic education <option value="Secondary school">Secondary school <option value="Short higher education">Short higher education <option value="Higher education">Higher education <option value="PhD">PhD</select> </div> </fieldset> <fieldset class="fieldset fieldSet6 fieldSet7 fieldSet8"> <h2>Your CV</h2> <div style="padding:0px;padding-left:20px;height:24px;clear:both;line-height:24px;" class="switch"> <input type="radio" onclick='displaybox("box29",this);' checked="" name="radio29" style="vertical-align:middle;margin:0px;margin-right:5px;">I want to upload my CV</div> <div style="padding:0px;padding-left:20px;height:24px;clear:both;line-height:24px;" class="switch"> <input type="radio" onclick='displaybox("box33",this);' name="radio29" style="vertical-align:middle;margin:0px;margin-right:5px;">I want to write my CV</div> <fieldset class="fieldset" id="box29" style="display:block"><div id="filefield-id-CV-cvfile" class=" cvtemplatefieldid-"> <div class="filenames filesrequired"></div> <label><span class="requireddot">*</span><span class="label-text">Upload your CV</span></label><iframe src="https://hr-skyen.dk/hr/attachment.upload.php?type=file&amp;fieldname=filefield-id-CV-cvfile&amp;varname=CV%5Bf0%5D%5Bcvfile%5D&amp;theme=orifarm-api&amp;locale=en_US" class="fileuploadframe" scrolling="no" frameborder="0" allowtransparency="true" style="height:61px;width:260px;"></iframe> </div></fieldset> <fieldset class="fieldset" id="box33" style="display:none"><div class="inputrow textarearequired"> <label style="display:block;clear:both;float:none;" class="longlabel"><span class="requireddot">*</span><span class="label-text">Write your CV here</span></label><div class="textareawrapperbig"><textarea name="CV[f0][about]" class="ckeditorBasic" id="CKE667c3f2d519e72e1e54c983a13082c74"></textarea></div> </div></fieldset> </fieldset> <fieldset class="fieldset fieldSet9 fieldSet10 fieldSet11"> <h2>Your application</h2> <div style="padding:0px;padding-left:20px;height:24px;clear:both;line-height:24px;" class="switch"> <input type="radio" onclick='displaybox("box37",this);' checked="" name="radio37" style="vertical-align:middle;margin:0px;margin-right:5px;">I want to upload my application</div> <div style="padding:0px;padding-left:20px;height:24px;clear:both;line-height:24px;" class="switch"> <input type="radio" onclick='displaybox("box41",this);' name="radio37" style="vertical-align:middle;margin:0px;margin-right:5px;">I want to write my application</div> <fieldset class="fieldset" id="box37" style="display:block"><div id="filefield-id-Application-applicationfile" class=" cvtemplatefieldid-"> <div class="filenames filesrequired"></div> <label><span class="requireddot">*</span><span class="label-text">Application</span></label><iframe src="https://hr-skyen.dk/hr/attachment.upload.php?type=file&amp;fieldname=filefield-id-Application-applicationfile&amp;varname=Application%5Bf0%5D%5Bapplicationfile%5D&amp;theme=orifarm-api&amp;locale=en_US" class="fileuploadframe" scrolling="no" frameborder="0" allowtransparency="true" style="height:61px;width:260px;"></iframe> </div></fieldset> <fieldset class="fieldset" id="box41" style="display:none"><div class="inputrow textarearequired"> <label style="display:block;clear:both;float:none;" class="longlabel"><span class="requireddot">*</span><span class="label-text">Write your application</span></label><div class="textareawrapperbig"><textarea name="Application[f0][application]" class="ckeditorBasic" id="CKE907607a4e710711076a8dfb558d10c08"></textarea></div> </div></fieldset> <div id="filefield-id-CV-attachments" class=" cvtemplatefieldid-23673"> <div class="filenames"></div> <label><span class="label-text">Other documents</span></label><iframe src="https://hr-skyen.dk/hr/attachment.upload.php?cvtemplatefieldid=23673&amp;type=file&amp;multiple=1&amp;fieldname=filefield-id-CV-attachments&amp;varname=CV%5Bf0%5D%5Battachments%5D&amp;theme=orifarm-api&amp;locale=en_US" class="fileuploadframe" scrolling="no" frameborder="0" allowtransparency="true" style="height:61px;width:260px;"></iframe> </div> <div class="inputrow userreferrer"> <label><span class="requireddot">*</span><span class="label-text">How did you find us?</span></label><select name="Application[f0][userreferrer]" class="required"><option value="0">Select <option value="Our website">Our website <option value="Jobview"> Jobview <option value="LinkedIn"> LinkedIn <option value="Facebook"> Facebook <option value="Jobindex"> Jobindex <option value="Jobnet"> Jobnet <option value="Farmakonom.dk"> Farmakonom.dk <option value="[ANDET]"> [ANDET]</select> </div> </fieldset> <fieldset class="fieldset termsAgreeWrapper fieldSet12"> <h2>Terms &amp; Conditions</h2> <hr> <div class="termsWrapper"> <p><strong>Privacy policy for online application</strong><br> Thank you for your interest in our online job posting.<br> &nbsp;<br> <strong>The protection of your personal information is very important to us.</strong><br> Therefore, we will inform you below about the collection, processing and use of your data in the context of the online application, in accordance with the relevant data protection regulations.<br> &nbsp;<br> <strong>Purpose of data collection / dissemination</strong><br> The collection and processing of your personal application data is exclusively earmarked for the filling of positions within our company. Your data will only be forwarded to the in-house bodies and specialist departments of our company responsible for the concrete application process. A transfer of your personal application data to other companies of the Orifarm Group will not take place without your prior express consent.<br> Any further use or transfer of your application data to third parties will not take place.<br> &nbsp;<br> <strong>Retention period of the application data</strong><br> A deletion of your personal application data takes place automatically 3 months after completing the application process, unless you have explicitly agreed to a longer storage.<br> &nbsp;<br> <strong>Storage for future job postings</strong><br> If we are unable to provide you with a current vacancy, but your profile suggests that your application may be of interest for future job postings, we will store your personal application information for six months, provided that you expressly consent to such storage and use. We would contact you in advance.<br> &nbsp;<br> <strong>Right to information and revocation</strong><br> If you have questions about the collection, processing or use of your personal data, or in cases of information, correction or deletion of data, as well as revocation of granted consent, please contact our data protection officer:<br> &nbsp;<br> <strong>Mr. Michael Stopper</strong><br> E-Mail: privacy.orifarm@mediant.de<br> &nbsp;<br> &nbsp;<br> To continue with the application, please accept the following required field with the asterisk *.</p> <label><input type="checkbox" name="acceptedconsents[]" value="388">&nbsp;I agree with the terms &amp; conditions</label> </div> </fieldset> </div> </div> </div></div> <div style="clear:both;" class="tabbottom"><button type="submit">Next</button></div> <div class="cb"></div> </form> <div class="cb"></div> </div> <div class="cb"></div> <script type="text/javascript"> </script> </div>

IT Developer SQL

– Who loves data and the connections it creates between people, processes, and systems

Are you a specialist who knows T-SQL inside out and take pride in optimizing the existing solutions, ranging from simple statements to frameworks built in SQL? Do 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, then 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. We help streamline the business processes by transferring data between internal and external systems. We also maintain a legacy data warehouse with multiple business critical reports, cubes, and applications on top. Our customers are 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.

Who are you?

You're a positive team player who has graduated with 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
  • can be physically present in our headquarters in Odense
  • can perform T-SQL optimizations at many levels of complexity
  • have worked with SSIS, SSRS, and SSAS and can maintain existing solutions
  • are a quick learner and enjoy expanding your skill set
  • can communicate fluently in Danish and English, both written and orally

It is an advantage, if you have knowledge in:

  • C#
  • Excel
  • VB (and VB script)
  • Microsoft Dynamics Ax 2009
  • GxP / Gamp5 / GDPR
  • the workflow in a Sales and Production company

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 with the medical authorities, and the process regarding expanding our product pool and following through with new launches, among others.

In the OLTP sub team, currently consisting of 3 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 brings value, and they love to use.

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.

Our values

The explorer spirit still characterizes Orifarm, although we have now become a large, international company since Hans and Birgitte Bøgh-Sørensen founded the company in 1994. Our mission is to make important savings for the society via parallel imported and generic pharmaceuticals and to ensure that the consumers get better value for money. Seriously and determined, we strive to make this happen while insisting on being good colleagues, improving together, helping each other and innovating. This attitude may be of benefit to you.

We offer

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.

If you need further information about the job please contact:

Steen Palle
Team Manager
stpal@Orifarm.com

Application deadline:

As soon as possible
If you experience problems applying with Internet Explorer, we recommend trying it in a different browser.