Data Engineer II

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 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!

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.

What to Expect:

• Building and Maintaining Data Pipelines: Creating and managing the systems that move data from various sources to where it needs to be for analysis and other uses.

• Designing Data Architecture: Defining the structure and organization of data storage, including databases and data warehouses, ensuring optimal performance and scalability.

• Data Modeling: Creating and maintaining data models that represent how data is organized and related, supporting both analytical and operational needs.

• Data Quality Assurance: Implementing and maintaining processes to ensure data accuracy, consistency, and reliability.

• Data Security and Privacy: Implementing and enforcing policies and procedures to protect sensitive data and ensure compliance with regulations.

• Collaboration: Working closely with data scientists, analysts, and other stakeholders to understand their needs and deliver data solutions.

• Performance Optimization: Continuously monitoring and optimizing data systems for performance and efficiency.

• Staying Updated: Keeping abreast of new technologies and trends in data engineering to ensure the organization benefits from the latest advancements.

On a daily basis our Data Engineer:

• ETL Processes: Building and optimizing Extract, Transform, Load (ETL) pipelines to move data between different systems.

• Data Validation: Implementing checks and tests to ensure data accuracy and consistency.

• Data Warehousing: Building and managing data warehouses to support business intelligence and reporting needs.

• Cloud Technologies: Utilizing cloud platforms like AWS, Azure, or Google Cloud for data storage and processing.

• Big Data Technologies: Working with technologies like Hadoop, Spark, and Kafka to handle large volumes of data.

• Data Visualization: Developing tools and dashboards to present data insights to stakeholders.

What You Will Need:

• 5+ years - Design and development of ETL and ELT solutions using SSIS, T-SQL, Azure Data Factory, Azure Data Flows, Azure Data Bricks, Azure Database, Azure Analysis Services, Tabular Models, and Power BI Fabric.

• 
  5+ years - Experience with code editing and version controls using Microsoft Visual Studio, Azure Dev Ops, and SQL Server Management Studio.

• 
  5+ years - Experience with solution design, code implementation, and version control of Azure and Microsoft products and services from abstract project requests and goals.

• 5+ years - Experience with development under structure and naming standards.

• 
  3+ years - Design and Development experience with Kimball and Inman style Data Warehouse structures.

• 
  2+ years - Design and Development experience with third normal form database structures.

• 
  Strong self-management, internal solution validation, and team communication.

Skills Preferred:

• Design and Development experience with machine learning for forecasting, grouping, and anomaly detection

• Knowledge and experience with UniBasic databases and coding languages

• Design and Development experience with AI data querying and analysis

• Knowledge and experience in Data extraction from API, Oracle, Unidata, Tecsys, Cosmos DB, and Json document.

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.

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.