Data Engineer

poolcorp; United States; Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical &Dental & Vision

401(k) match

PTO & Holidays

Life Insurance & LT Disability

Parental Leave

Tuition Programs

Bonus & Referrals

Employee Stock Purchase Plan

Employee Discounts

Job summary

POOLCORP, the world’s leading distributor of outdoor living products, seeks a Data Engineer to design, build, and maintain data pipelines and a modern data platform. You will transform raw data into usable formats, ensure quality, and support data-driven decisions with cross-team collaboration.

The role requires deep expertise in SQL Server, Azure Data Factory, SSIS, and Power BI, with on-site weekly collaboration in Covington, LA while primarily remote in the United States.

Qualifications

• 5+ years of professional experience in data engineering or a closely related field.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent practical experience.
• Advanced proficiency in SQL Server and Azure SQL Database, including T-SQL development and query optimization.
• Hands-on experience building and maintaining SSIS packages for complex ETL workflows.
• Strong experience with Azure Data Factory (pipelines, linked services, triggers, data flows).
• Working knowledge of Microsoft Fabric (including Power BI), Azure Analysis Services, and Tabular Models.

Responsibilities

• Design, build, and maintain robust ETL/ELT pipelines using Azure Data Factory and SSIS.
• Build and manage data warehouse schemas, models, and processes in SQL Server and Azure SQL Database.
• Optimize complex T-SQL queries, stored procedures, and database objects for performance and reliability.
• Collaborate with data analysts, scientists, and other stakeholders to understand data requirements and deliver scalable solutions.
• Establish and enforce data quality standards, data governance practices, and documentation.
• Monitor and troubleshoot data pipelines, proactively resolving issues to ensure data availability and accuracy.
• Participate in code reviews, architectural design discussions, and engineering best practices.
• Evaluate and integrate emerging data technologies to modernize the data platform.

Skills

SQL

ETL/ELT

Azure Data Factory

SSIS

SQL Server

Azure SQL

Power BI

Azure Analysis Services

Tabular Models

Python

C#

Git

Education

Bachelor's degree

Tools

SQL Server

Azure SQL Database

SSIS

Azure Data Factory

Power BI

Azure Analysis Services

Tabular Models

Microsoft Fabric

Azure Databricks

Job description

Looking to work for the best in the industry?

Look no further than POOLCORP, the world's leading distributor of outdoor living products. With over 445 Sales Centers in 13 countries and a team with more than 6,000 dedicated employees, we are committed to meeting the needs of our customers with pride and professionalism. Our network includes SCP Distributors, SCP Distributors International, Superior Pool Products, National Pool Tile, Pinch A Penny, and Horizon Distributors.

Why join POOLCORP?

We offer a wealth of opportunities for career growth and advancement, with comprehensive training programs to support your success. As a company, we value integrity, trust, diversity, and innovation, and we strive to foster a family-oriented, hometown culture that is supported by our strong, stable, and growing business. Join us today and experience the best of both worlds!

You want Benefits? You've got it! Our generous benefits package includes:

• Medical, Dental, Vision, and Prescription Drug coverage with Flexible Spending Accounts and Wellness Programs
• 401 (k) with generous company match
• 13 days of paid time off (PTO) & 8 Paid Holidays (NOTE: PTO increases with tenure!)
• 100% employer paid Life Insurance and Long-Term Disability Insurance
• Paid Parental Leave
• Fully Funded Tuition Education Programs
• Bonus Programs that include Employee Recognition and Referrals, Summer Madness, and Annual Performance
• Employee Stock Purchase Plan
• Employee Discounts and much more!

Location: Remote in the United States, with ability to travel to Covington, LA Quarterly.

Applicants must be currently authorized to work in the United States on a full-time basis. The Company is unable to provide visa sponsorship, visa transfer support, or employment-based immigration sponsorship now or in the future. Candidates must reside and work within the United States.

What to Expect?

We are seeking a highly skilled Data Engineer to join our team! They will be responsible for design ing , build ing , and maintain ing the infrastructure and pipelines that enable data collection, storage, and access for analysis and other applications. As well as transforming raw data into usable formats, ensuring data quality and security, and collaborating with various teams to support data-driven decision-making. This role requires one day on site in our Covington location weekly.

• Design, develop, and maintain robust ETL/ELT pipelines using Azure Data Factory and SSIS.
• Build and manage data warehouse schemas, models, and processes in SQL Server and Azure SQL Database.
• Optimize complex T-SQL queries, stored procedures, and database objects for performance and reliability.
• Collaborate with data analysts, scientists, and other stakeholders to understand data requirements and deliver scalable solutions.
• Establish and enforce data quality standards, data governance practices, and documentation.
• Monitor and troubleshoot data pipelines, proactively resolving issues to ensure data availability and accuracy.
• Participate in code reviews, architectural design discussions, and engineering best practices.
• Evaluate and integrate emerging data technologies to modernize the data platform.

What You Will Need:

Experience & Education

5+ years of professional experience in data engineering or a closely related field.

Bachelor's degree in Computer Science , Information Systems, Engineering, or equivalent practical experience .

Microsoft Data Stack

• Advanced proficiency in SQL Server and Azure SQL Database, including T-SQL development and query optimization.
• Hands-on experience building and maintaining SSIS packages for complex ETL workflows.
• Strong experience with Azure Data Factory (pipelines, linked services, triggers, data flows).
• Working knowledge of Microsoft Fabric (including Power BI), Azure Analysis Services, and Tabular Models

Data Warehousing

• Solid understanding of data warehousing concepts: dimensional modeling, star schemas, Kimball and Inman methodology .
• Experience designing and implementing data marts and enterprise data warehouse solutions.
• Familiarity with third normal form (3NF) database structures, slowly changing dimensions (SCDs) , and incremental load patterns.

Core Engineering Skills

• Strong proficiency in at least one programming language (Python, C#).
• Experience with source control systems (Git) and collaborative development workflows.
• Ability to work independently and translate complex business requirements into scalable technical data solutions.
• Excellent analytical thinking, problem-solving, testing, and team communication skills.

Preferred Qualifications :

The following qualifications are a plus but are not required . We encourage candidates who meet most of the required qualifications to apply :

• Knowledge of Microsoft Fabric and Azure Databricks .
• Experience with Azure DevOps (pipelines, repos, boards)