EA DT Engineer

American Builders and Contractors Supply Co • Beloit, WI

1d • Onsite

About The Position

ABC Supply is hiring an EA DT Engineer to design, develop, and deliver large-scale data systems, data processing, and data transformation pipelines. The role collaborates with stakeholders to understand business needs and delivers reliable, flexible, scalable, enterprise-grade datasets with low ownership costs. It is based at the company’s Beloit, Wisconsin office and requires onsite work five days per week.

Responsibilities include developing optimized, scalable batch integration solutions for traditional data warehouse workloads and scheduled large extracts; extracting, transforming, and loading data into Azure Data Lake using ADF pipelines, Databricks, PySpark, and SQL; designing star-schema, snowflake, and physical data models; planning, reviewing, and implementing database changes for integrations and data warehouse work; and partnering with the BI team and product owner to build tables and transform data for Snowflake and Dremio. The role also performs data management tasks and recommends improvements to data reliability, efficiency, and quality.

Requirements

• Master’s degree in Computer Science, IT/IS, or a related field of study and two years of work experience in the job offered or a related occupation; alternatively, a bachelor’s degree in Computer Science, IT/IS, or a related field of study and five years of experience in the job offered or a related occupation.
• Demonstrated experience with enterprise integration patterns (EIP), data warehouse modeling, ETL processes, and database management.
• Demonstrated experience in development and data warehouse requirements gathering, analysis, and design.
• Demonstrated experience in cloud-native modern data engineering projects.
• Demonstrated experience designing, building, and deploying scalable data pipelines.
• Demonstrated experience with Python, PySpark, and Spark SQL.
• Demonstrated experience with analytical data models such as Kimball.
• Work onsite five days per week at the Beloit, Wisconsin office.

Responsibilities

• Design, develop, and deliver large-scale data systems, data processing, and data transformation pipelines.
• Collaborate with stakeholders to understand business needs and deliver reliable, flexible, scalable enterprise datasets with low ownership costs.
• Develop optimized, scalable batch integration solutions, including traditional data warehouse workloads and scheduled nightly large extracts.
• Extract data from various sources, transform it, and load it into Azure Data Lake using ADF pipelines, Databricks, PySpark, and SQL.
• Design star-schema, snowflake, and physical data models aligned with best practices and requirements; understand analytical data models such as Kimball.
• Plan, review, and implement database changes for integration and data warehouse work.
• Work with the BI team and product owner to build tables and transform data for Snowflake and Dremio.
• Perform data management tasks.
• Recommend ways to improve data reliability, efficiency, and quality.

Benefits

• Health, dental, and vision coverage, eligible after 60 days.
• 401(k) with generous company match, eligible after 60 days and immediately vested.
• Employer-paid employee assistance program.
• Employer-paid short-term and long-term disability.
• Employer-paid life insurance.
• Flexible spending.
• Paid vacation.
• Paid sick days.
• Paid holidays.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level