Company Description Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and our environment safer, healthier and more sustainable. From the food you eat, to the water you drink, to the medicines you rely on, Eurofins works with the biggest companies in the world to ensure the products they supply are safe, their ingredients are authentic and labelling is accurate. Eurofins believes it is a global leader in food, environmental, pharmaceutical and cosmetics products testing and in agroscience CRO services. It is also one of the global independent market leaders in certain testing and laboratory services for genomics, discovery pharmacology, forensics, CDMO, advanced material sciences and in the support of clinical studies. In over just 30 years, Eurofins has grown from one laboratory in Nantes, France to over 47,000 staff across a network of more than 900 independent companies in over 50 countries and operating more than 800 laboratories. Eurofins offers a portfolio of over 200,000 analytical methods to evaluate the safety, identity, composition, authenticity, origin, traceability and purity of biological substances and products, as well as providing innovative clinical diagnostic testing services, as one of the leading global emerging players in specialised clinical diagnostics testing. In 2019, Eurofins generated total revenues of EUR € 4.56 billion, and has been among the best performing stocks in Europe over the past 20 years. Job Description OVERALL OBJECTIVES: Develop and maintain the Business Intelligence Data Warehouse within Eurofins laboratories across the Globe. ROLES & RESPONSIBILITIES: • SQL Server Database development work including tables, views, stored procedures and functions. SSIS development for Extract Transform Load (ETL) processes as well. • SQL scripting to perform essential data maintenance functions including reclassification's, some master data setup and other. Work closely with Data Quality function to implement changes. • Use of Pyramid Analytics BI Reports, Power BI or similar • Performance tuning and testing of BI structures and processes. • Participation in the design of data models to house and deliver essential reporting. • Training of BI Team members and key BI power users on specific data designs and intended use. • Serve as primary DBA on all DW systems other than Operational DB management • Play an active role in the development and implementation of Master Data Management practices. • As a member of the BI team to promote and evolve standards for object naming and data warehousing approach • Maintenance and extension of our SQL server jobs and Azure Powershell runbooks for update of our SQL and Azure Analysis Services environments. • Bachelor's degree in computer science or equivalent relevant experience. • Microsoft SQL Server training and certification strongly desired. • Power BI training and certification a big plus. • 2-3 years in a data warehouse development role • 2+ years with SQL Server Integration Services (SSIS) • Microsoft Power BI platform, including DAX and Power Query expressions and Analysis Services tabular a big plus • SQL Server Reporting Services (SSRS) helpful • Powershell a plus • Provide technical support on projects or troubleshoot system issues across multi-tier web architecture. • Analyze, design, build and implement end to end custom software solution. • Code, refactor, design, implement software solutions and provide system troubling shooting of those systems. • Knowledge of Agile Scrum and work as team member in the scrum team • Build and Maintain Development and test systems • Manage multiple assignments and balance workload according to priorities • Maintains a high degree of knowledge on current technologies, tools and brainstorm ideas with other team members Qualifications • BE Computer Science or MBA or equivalent degree • Minimum 5 years of experience in IT Application/Software Development field • Should have been part of at least 2 complete life-cycle implementation using Scrum. Technical knowledge: • Bachelor's degree in computer science or equivalent relevant experience. • Microsoft SQL Server training and certification strongly desired. • 2-3 years in a data warehouse development role • 2+ years with SQL Server Integration Services(SSIS) • Microsoft Power BI platform, including DAX and Power Query expressions and Anaysis Services tabular a big plus • SQL Server Reporting Services (SSRS) helpful • Powershell a plus • Strong and proven background in Information Technology. • Knowledge and/or experience with widely successful Agile techniques: User Stories, ATDD, TDD, Continuous Integration, Continuous Testing, Pairing, Automated Testing, Agile Ceremonies • Excellent analytical and troubleshooting skills. Desirable experience: • Exposure in handling international projects is highly preferred. • Knowledge of Pharmaceutical industry, terms and processes i.e. GXP Personal Qualities: • English communication skills (written and oral). • Very good interpersonal relation skills at all levels of the organization, with capability to influence decisions and lead others to achieve results. • Ability to work in a complex international environment. • Responsive problem solver and proactive actions. • Eager to learn and continuously develop personal and technical capabilities. Additional Information Position is Full Time, Monday - Friday 8:00am - 5:00pm. This position is on site and all candidates within Lancaster, PA commuting distance are encouraged to apply. • Excellent full time benefits including comprehensive medical coverage, dental, and vision options • Life and disability insurance • 401(k) with company match • Paid vacation and holidays Eurofins is a M/F, Disabled, and Veteran Equal Employment Opportunity and Affirmative Action employer.