Senior Data Engineer
Raleigh, NC, US
TARGAN
TARGAN: Advancing the future of animal health in poultry, livestock, and aquaculture with innovative biotech & approaches for a sustainable food supply.Description
As a Data Engineer, you will be responsible for designing, developing, and maintaining our data infrastructure. You will work closely with a diverse range of users, including business users, leadership, mechanical engineers, controls programmers, biologists, and data scientists. Your expertise in Azure, Fabric, Data Factory, IoT, and common data formats such as Parquet and JSON will be crucial in optimizing our data processes and driving insightful business decisions through Power BI. To succeed in this data engineering position, you should have strong analytical skills and the ability to combine data from different sources. This Data Engineer's skills also include familiarity with several programming languages and knowledge of learning machine methods.
Key Responsibilities
- Design, develop, and maintain data pipelines using Azure Data Factory / Fabric.
- Implement data storage solutions using Azure SQL Database, Azure Data Lake, and other Azure services.
- Develop and maintain ETL processes to ensure data is accurately and efficiently processed.
- Collaborate with data analysts and business stakeholders to understand data requirements and deliver appropriate solutions.
- Build and maintain data models and data warehouses to support business intelligence and reporting needs.
- Develop and maintain data integration solutions using Azure Data Factory and other relevant tools.
- Create and optimize complex SQL queries to retrieve and manipulate data.
- Implement and manage data security and compliance measures.
- Create and maintain documentation related to data architecture, processes, and workflows.
- Utilize Power BI and Power Query to create interactive and insightful reports and dashboards for business users.
- Work with cutting-edge technologies like Fabric and IoT to drive innovation in data solutions.
- Engage with a wide range of users, including business users, leadership, mechanical engineers, controls programmers, biologists, and data scientists, to understand their data needs and provide tailored solutions.
- Handle data in various formats, including Parquet, JSON, and other common formats.
- Monitor and optimize costs associated with data storage and processing, ensuring efficient use of resources.
- Monitor and troubleshoot data issues, ensuring high availability, reliability and performance of data systems.
- Working knowledge of Python and Jupyter Notebooks or similar tools a plus.
- Knowledge of Azure Purview and data security best practices a plus.
Requirements
- Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
- 5+ years of experience as a Data Engineer or in a similar role.
- Strong proficiency in Azure services, including Azure Data Factory, Pipelines, Azure SQL Database, Azure Data Lake, and other Azure data services.
- Experience with ETL tools and processes.
- Strong SQL skills and experience with relational databases; knowledge of big-data modeling concepts such as Star / Snowflake Schemas.
- Proficiency in Power BI and Power Query for data visualization and reporting.
- Knowledge of data warehousing concepts and best practices; understanding of data ops principles for transformation/curation of data (raw, structured, and semantic transformation layers).
- Knowledge of data formats such as Parquet, JSON, and other common formats.
- Familiarity with IoT platforms and data integration from various IoT devices.
- Experience with cost monitoring and optimization in a cloud environment.
- Detail-oriented with a high level of accuracy in work.
Working Conditions
Must be able to work in both industrial environments and office settings. This involves adhering to safety protocols, wearing appropriate protective gear, and sometimes working with industrial machinery or in environments with strict access controls.
Please Note: To 3rd Party Search Firms/Employment Agencies: All inquiries must be directed to careers@targan.com. Please do not call or email any TARGAN employee about current or future job openings. All resumes submitted by search firms or employment agencies to any employee at TARGAN via email, telephone, social media, or other means will be deemed to be the sole property of TARGAN unless the firm submitting the resume has previously entered into a written agreement with TARGAN regarding recruitment services and has been approved by Human Resources to work on an open position. TARGAN will not pay any fee or remuneration concerning candidates without complying with this requirement.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Azure Business Intelligence Computer Science DataOps Data pipelines Data visualization Data Warehousing Engineering ETL Industrial JSON Jupyter Parquet Pipelines Power BI Python RDBMS Security Snowflake SQL
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 Research Scientist jobs
- Open Data Science Manager jobs
- Open Data Engineer II jobs
- Open Principal Data Scientist jobs
- Open Business Data Analyst jobs
- Open BI Analyst jobs
- Open Sr Data Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Engineer jobs
- Open Data Science Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Business Intelligence Analyst jobs
- Open Software Engineer, Machine Learning jobs
- Open Lead Data Analyst jobs
- Open Azure Data Engineer jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open Data Analytics Engineer jobs
- Open Manager, Data Engineering jobs
- Open Marketing Data Analyst jobs
- Open Data Engineer III jobs
- Open Junior Data Engineer jobs
- Open Data Engineering Manager jobs
- Open Data Analyst II jobs
- Open ETL Developer jobs
- Open Data quality-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Excel-related jobs
- Open ML models-related jobs
- Open Data pipelines-related jobs
- Open APIs-related jobs
- Open PhD-related jobs
- Open PyTorch-related jobs
- Open LLMs-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Consulting-related jobs
- Open TensorFlow-related jobs
- Open Deep Learning-related jobs
- Open Business Intelligence-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs
- Open Git-related jobs
- Open Hadoop-related jobs
- Open Docker-related jobs