<div id='hrsky-content' style='margin-bottom:5px'> <h1>SQL Developer for Business Intelligence, Backend</h1><ul> <li> <h3><strong>Be part of a dedicated team, delivering business intelligence </strong></h3> </li> </ul> <p>We are looking for a person with flair for design and implementing structure in systems. You are an experienced SQL developer, who can work with the Microsoft ETL tools and comfortable with working in a small team of experts.</p> <p><strong>About the job</strong></p> <p>At Orifarm you will be a part of a small dedicated Business Intelligence team, where you will have great influence on the design and structure of the BI backend.<br> The BI team is responsible for extracting external data sources and to publish these data to other IT systems and to the business to consume.<br> The external data is delivered in many varieties, and therefore one of our challenges is to publish the data in a generic structure.<br> <br> <strong>Who are you?</strong></p> <p>You are a team player with a positive attitude who focuses on reaching our company goals. You are proactive in your approach and possess a great drive, combined with initiative and flexibility.</p> <p>We expect that you:</p> <ul> <li> <p>Have a bachelor degree, but the field is not vital</p> </li> <li> <p>Have minimum 3 years&rsquo; experience in developing and implementing Microsoft SSIS solutions</p> </li> <li> <p>Have minimum 3 years&rsquo; experience in developing and implementing data warehouse on a SQL server</p> </li> <li> <p>Are able to design, implement, and manage ETL systems</p> </li> <li> <p>Communicate fluently in English, both written and orally</p> </li> </ul> <p><strong>Who are we?</strong></p> <p>You will join a well-established BI team which consists of 3-4 developers, working closely together with the rest of the IT department; in total 31 people in Denmark, Germany and Czech Republic. In our team, we enjoy an informal atmosphere, and openness is an essential part of our foundation. We are all curious and excited about new technology and strive to work with the newest tools.</p> <p><strong>About Orifarm</strong></p> <p>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&oslash;gh-S&oslash;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 the 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.</p> <p> </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.<br> <br> 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>We collaborate with the consulting firm Sylvest+ so if you have any questions please do not hesitate to contact HR Business Partner Thomas Sylvest.</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 class='block'> <strong>Thomas Sylvest</strong><br><a href="mailto:thomas@sylvestplus.dk">thomas@sylvestplus.dk</a><br>Tlf.: +45 60 57 65 00<br> </div></div> </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|52102', action:'show-job|52102' }); }); </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=52102&amp;xdmframe=2&amp;theme=orifarm-api&amp;companyid=67&amp;filters=da_DK"> <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="52102"><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="52102"><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>

SQL Developer for Business Intelligence, Backend

  • Be part of a dedicated team, delivering business intelligence

We are looking for a person with flair for design and implementing structure in systems. You are an experienced SQL developer, who can work with the Microsoft ETL tools and comfortable with working in a small team of experts.

About the job

At Orifarm you will be a part of a small dedicated Business Intelligence team, where you will have great influence on the design and structure of the BI backend.
The BI team is responsible for extracting external data sources and to publish these data to other IT systems and to the business to consume.
The external data is delivered in many varieties, and therefore one of our challenges is to publish the data in a generic structure.

Who are you?

You are a team player with a positive attitude who focuses on reaching our company goals. You are proactive in your approach and possess a great drive, combined with initiative and flexibility.

We expect that you:

  • Have a bachelor degree, but the field is not vital

  • Have minimum 3 years’ experience in developing and implementing Microsoft SSIS solutions

  • Have minimum 3 years’ experience in developing and implementing data warehouse on a SQL server

  • Are able to design, implement, and manage ETL systems

  • Communicate fluently in English, both written and orally

Who are we?

You will join a well-established BI team which consists of 3-4 developers, working closely together with the rest of the IT department; in total 31 people in Denmark, Germany and Czech Republic. In our team, we enjoy an informal atmosphere, and openness is an essential part of our foundation. We are all curious and excited about new technology and strive to work with the newest tools.

About Orifarm

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 the 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.

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.

We collaborate with the consulting firm Sylvest+ so if you have any questions please do not hesitate to contact HR Business Partner Thomas Sylvest.

Application deadline:

As soon as possible
Thomas Sylvest
thomas@sylvestplus.dk
Tlf.: +45 60 57 65 00
If you experience problems applying with Internet Explorer, we recommend trying it in a different browser.