Data Engineer – SQL

Role Overview

This role is onsite in Ocala, Florida, and involves developing, maintaining, and optimizing data pipelines, designing and maintaining ETL and ELT processes, and managing the Azure Data Lake environment.

What You Will Do

Develop data pipelines, troubleshoot data feed failures, monitor and improve data pipeline performance, develop SQL queries, and work with Power BI developers and data analysts.

Why It Might Be a Fit

The ideal candidate will have strong experience with Microsoft Azure data technologies, particularly Azure Data Factory, Azure Data Lake Storage, and DataBricks, and strong SQL skills with experience developing complex queries.

Requirements

• 3+ years of experience in data engineering, data integration, database development, business intelligence engineering, or a related technical role
• Strong experience with Microsoft Azure data technologies, particularly Azure Data Factory, Azure Data Lake Storage, and DataBricks
• Strong SQL skills with experience developing complex queries, views, stored procedures, transformations, and reporting datasets
• Experience designing, developing, and maintaining ETL and ELT pipelines that integrate multiple enterprise data sources
• Experience integrating data through REST APIs, databases, file transfers, JSON, CSV, flat files, and other common integration methods
• Strong understanding of relational databases, data structures, database relationships, data types, indexing, and query optimization
• Experience preparing and modeling data for Power BI or similar business intelligence and visualization platforms
• Experience troubleshooting and optimizing data pipelines, SQL queries, transformations, and large data processing workloads
• Knowledge of incremental loading, change data capture concepts, data synchronization, data dependencies, and historical data management
• Experience implementing data validation, reconciliation, monitoring, logging, error handling, and data quality processes
• Experience working with data originating from ERP, CRM, transportation, logistics, financial, warehouse, customer service, or other enterprise business systems is preferred
• Strong analytical, troubleshooting, communication, organization, documentation, and problem-solving skills
• Ability to explain technical data concepts, issues, dependencies, and recommendations clearly to both technical and non-technical stakeholders
• Ability to work independently while collaborating cross-functionally with application development, infrastructure, analytics, project management, and business teams
• Ability to take ownership of critical data processes and proactively identify potential failures, performance issues, data quality concerns, and architectural improvements

Tagged as: SQL