Remote Data Engineer: Azure SQL, ETL & Analytics

Poolcorp; Covington (LA); On-site; USD 118,000 - 127,000; Full time

Benefits offered by this job

Medical, Dental, Vision, and Rx

401(k) with company match

Employee Stock Purchase Plan

PTO and Holidays (13 days + 8 holidays

Life Insurance & Long-Term Disability

Parental Leave

Tuition Education Programs

Employee Discounts

Job summary

POOLCORP is seeking a Data Engineer to design, build, and maintain data pipelines and a data warehouse for analytics and applications. You will transform raw data into usable formats while ensuring quality and security, collaborating across teams.

The role requires 5+ years in data engineering, strong SQL, and hands-on experience with Azure Data Factory, SSIS, and data warehousing. Hybrid work with occasional travel to Covington, LA may be required.

Qualifications

• 5+ years of professional experience in data engineering or a closely related field.
• Bachelor's degree in CS, IS, Engineering or equivalent practical experience.
• Strong SQL Server and Azure SQL Database expertise with T-SQL.
• Hands-on SSIS ETL workflow development and maintenance.
• Experience with Azure Data Factory pipelines and data flows.
• Knowledge of data warehousing concepts and dimensional modeling.
• Familiarity with 3NF, SCDs, and incremental loading patterns.
• Programming skills in Python or C#; source control with Git.

Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines using ADF and SSIS.
• Build and manage data warehouse schemas, models, and processes in SQL Server/Azure SQL.
• Optimize complex T-SQL queries and database objects for performance.
• Collaborate with analysts, scientists, and stakeholders on data needs.
• Establish data quality, governance, and documentation standards.
• Monitor and troubleshoot pipelines to ensure data availability.
• Participate in code reviews and architectural discussions.
• Evaluate new data technologies to modernize the platform.

Skills

SQL

Python

C#

Git

Data warehousing

Dimensional modeling

Kimball/Inmon

ETL/ELT

T-SQL

Problem solving

Education

Bachelor's degree in Computer Science, Information Systems, Engineering

Tools

SSIS

Azure Data Factory

SQL Server

Azure SQL Database

Microsoft Fabric

Power BI

Azure Analysis Services

Tabular Models

Azure Databricks

Git

Job description

POOLCORP is seeking a Data Engineer to design, build, and maintain data pipelines and a data warehouse for analytics and applications. You will transform raw data into usable formats while ensuring quality and security, collaborating across teams.

The role requires 5+ years in data engineering, strong SQL, and hands-on experience with Azure Data Factory, SSIS, and data warehousing. Hybrid work with occasional travel to Covington, LA may be required.