Data Engineer

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

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!So, end your job search here – at POOLCORP – Where Outdoor Living Comes to Life!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 Programs401 (k) with generous company match13 days of paid time off (PTO) & 8 Paid Holidays (NOTE: PTO increases with tenure!)100% employer paid Life Insurance and Long-Term Disability InsurancePaid Parental LeaveFully Funded Tuition Education ProgramsBonus Programs that include Employee Recognition and Referrals, Summer Madness, and Annual PerformanceEmployee Stock Purchase PlanEmployee 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 designing, building, and maintaining 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.On a daily basis our Data Engineer: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 & Education5+ 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 StackAdvanced 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 ModelsData WarehousingSolid 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 SkillsStrong 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) for CI/CD of data solutions.Familiarity with AI tools, including large language models (e.g., Claude by Anthropic) and their integration into data workflows.Development experience with machine learning for forecasting, grouping, and anomaly detectionKnowledge of real-time or streaming data architectures (Azure Event Hubs, Azure Service Bus).Understanding of UniBasic databases and coding languages.Exposure to data catalog and data lineage tools (Microsoft Purview).Understanding of both Waterfall and Agile/Scrum development methodologies.Bilingual, Military, Military Spouses and Veteran applicants are strongly encouraged to apply! We understand the uniqueness of hiring military personnel and veterans and will support him/her in the time of duty or with the transition into new civilian professions.All offers to external candidates for employment are contingent upon the successful completion of pre-employment drug testing and background verifications before employment is finalized.At POOLCORP, we are committed to our employees’ success. Our comprehensive benefits program offers the flexibility of benefits that meet the needs of our employees and their families. Some of these benefits include medical, dental and vision care, company-paid life and long-term disability insurance, prescription drug coverage, flexible spending and health savings accounts, 401(k) with company match, employee stock purchase plan, and employee assistance and education reimbursement programs. These benefits can help build a foundation for the future while helping employees live a healthy lifestyle.The compensation range for this position nationally is between $118,000 and $127,000 based on a full-time schedule. The actual pay may vary depending on your skills, qualifications and experience. Additionally, this position may be eligible for discretionary bonuses or commissions plans as well as relocation or cost of living adjustments.Your total compensation (pay, benefits, and bonuses) will be adjusted based upon your job classification, hours worked, and length of employment. Please note that benefits are subject to change. For more information about compensation and benefits, visit https://www.poolcorp.com/careers/compensation-benefits/POOLCORP, including all its subsidiaries, is a drug-free company and Equal Opportunity Employer – By Choice. The Company understands, respects, and values diversity – unique styles, experiences, identities, ideas, and opinions – while striving to be inclusive of all people. This commitment is critical to our success as a global company as we seek to recruit, develop, and retain the most talented people from a diverse candidate pool. Hiring and promotional decisions are based solely on the qualifications required for the job to be filled.