200+ applicants

Company

Inotiv · 10 hours ago

Data Integration Engineer

United States

Full-time

Remote

Mid Level

$80K/yr - $96K/yr

Maximize your interview chances

BiopharmaLife Science

Hiring Manager

Julie Melton, EdD

Insider Connection @Inotiv

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Develop and optimize SQL queries, stored procedures, and scripts to extract, transform, and load (ETL) data from various sources into target systems.

Design, configure, and deploy Azure Data Factory pipelines, activities, and data flows to orchestrate and automate data movement and transformation processes.

Set up and maintain Azure Synapse objects, including data warehouses, data lakes, and data integration services, to support efficient data storage and processing.

Collaborate with data architects and analysts to understand data requirements and translate them into technical specifications and data models.

Implement data transformation logic, data cleansing techniques, and data enrichment processes to ensure data quality and consistency.

Optimize data factory pipelines and workflows to enhance performance, scalability, and efficiency of data processing and integration operations.

Develop and maintain technical documentation, including system designs, data flow diagrams, and process documentation.

Ensure compliance with information governance policies and best practices, including data privacy, data security, and regulatory requirements.

Conduct data profiling and analysis to identify data quality issues, anomalies, and opportunities for data improvement.

Stay updated with emerging trends and technologies in SQL development, Azure Data Factory, and cloud-based data solutions.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQL DevelopmentAzure Data FactoryAzure SynapseData Integration PrinciplesETL MethodologiesData Transformation TechniquesData Factory OptimizationInformation GovernanceData Profiling ToolsTechnical DocumentationRelevant Certifications

Required

Bachelor's degree in Computer Science, Information Technology, or a related field.

Strong proficiency in SQL development, including experience in writing complex queries, stored procedures, and scripts.

Solid understanding of data integration principles, data transformation techniques, and ETL methodologies.

Good working knowledge of Azure Data Factory, including the setup and configuration of pipelines, activities, and data flows.

Experience in setting up and managing Azure Synapse objects, such as data warehouses and data lakes.

Familiarity with data factory optimization techniques to improve performance and efficiency of data processing workflows.

Knowledge of information governance processes, including data privacy, data security, and regulatory compliance.

Experience in documenting technical solutions, system designs, and data flows.

Proficiency in data profiling and analysis tools for identifying data quality issues and anomalies.

Excellent problem-solving and analytical skills, with the ability to troubleshoot and resolve data-related issues.

Preferred

Relevant certifications are a plus.

This position could be offered at different levels for candidates who qualify with a combination of advanced levels of education and/or years of experience.