Data Engineer (Hybrid)
Lancaster, PA, United States
Eurofins
World leader in food, environment, pharma product testing & agroscience CRO services; 61,000 staff across a network of more than 1,000 independent companies (940 laboratories) in 59 countries, offering over 200,000 analytical methods.Company Description
Eurofins Scientific is an international life sciences company which provides a unique range of analytical testing services to clients across multiple industries. The Group believes it is the world leader in food, environment and pharmaceutical 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, advanced material sciences and for supporting clinical studies. In addition, Eurofins is one of the key emerging players in specialty clinical diagnostic testing in Europe and the USA.
Job Description
Position Objective: Develop and maintain data sources to support Business Intelligence reporting and analysis requirements for Eurofins laboratories across the Globe.
Position Responsibilites:
- Develop new and improve existing ETL processes to load data into tabular models, data warehouses and other data structures as best fit for solving business requirements for reporting and further data analysis including machine learning.
- Collaborate with business analyst and stakeholders to understand data requirements and translate them into technical solutions.
- Analyze existing data processing to identify and implement improved methods for preparing data.
- Design and implement reports in PowerBI.
- Investigate approaches for moving data processing to cloud-native (Azure) tools & technologies.
- Implement data security measures to protect sensitive data.
- Optimize data platforms for performance and cost efficiency.
- Monitor and troubleshoot issues as they arise.
- Code review other team members work, providing constructive feedback and identifying potential bugs and gaps in design & implementation.
- Partner with other team members for ensuring the accuracy, completeness, and consistency of the data.
- Create & maintain documentation on design and intent of data processes and data structures
- Provide recommendations to software application teams on potential changes to data structures to address performance issues or improve processing abilities
- Continuously enhancing knowledge and skills, staying updated on data architecture and cloud technology.
- Evaluate, recommend and implement new technologies and tools to enhance data architecture and management processes.
- Build and maintain development and test systems.
CURRENT TECHNOLOGY TOOLSET:
- Databases : Microsoft SQL Server 2019+, Azure SQL, CosmosDB, Oracle
- SSAS Tabular Models
- PowerBI (PowerBI Reports and Paginated Reports)/Microsoft Fabric
- SSRS
- SSIS
- GIT
- Azure DevOps
- PowerShell
- Microsoft Azure
- Microsoft Windows
Qualifications
What we are looking for in a qualified candidate:
- Knowledge of Pharmaceutical industry, terms and processes i.e. GXP
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services(SSIS)
- Microsoft PowerShell
- Excellent English communication skills (concise writing and orally convincing).
- Very good interpersonal relation skills at all levels of the organization, with the ability to collaborate effectively across teams in an organization.
- Ability to work in a complex international environment.
- Eager to learn and continuously develop personal and technical capabilities.
- Excellent analytical and problem-solving skills
- Keen attention to detail
- Ability to acquire new skills quickly
- Desire to work in a collaborative team environment
Position Minimum Qualifications:
- B.S or equivalent in the field of Computer Science or related degree concentration, or equivalent directly-related experience
- Minimum 5 years of experience in IT Application/Software Development field
- Minimum 2 years in a data-centric engineering role
- Hands on experience with ETL design and coding in business intelligence and data warehousing environments, including the ability to design and execute using industry best practices.
- Experience with SQL Server Analysis Services particularly with tabular models including MDX and DAX queries
- Working knowledge of Microsoft Power BI platform including Power Query expressions
- Strong Microsoft SQL Server skills including creating stored procedures, functions & views
- Authorization to work in the United States indefinitely without restriction or sponsorship
Additional Information
Position is Full Time, Hybrid- Monday-Friday, 8:00 AM-5:00 PM. Candidates currently living within a commutable distance of Lancaster, Pennsylvania are encouraged to apply.
What we Offer:
- 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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Azure Business Intelligence Computer Science Data analysis Data Warehousing DevOps Engineering ETL Git Machine Learning Oracle Pharma Power BI Security SQL SSIS Testing
Perks/benefits: 401(k) matching Career development Health care Insurance
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Intern jobs
- Open Lead Data Analyst jobs
- Open Power BI Developer jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Business Data Analyst jobs
- Open Product Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Analyst Intern jobs
- Open Sr Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Sr. Data Scientist jobs
- Open Data Engineering Manager jobs
- Open Senior Data Architect jobs
- Open Junior Data Engineer jobs
- Open Big Data Engineer jobs
- Open Research Scientist jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Data quality-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open LLMs-related jobs
- Open APIs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Consulting-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs