EA DT Engineer
- Beloit, United States
- Mid Level
- Posted
This position is based in our Beloit, Wisconsin office and requires working onsite five days per week.
About ABC Supply
- ABC Supply is North America’s largest wholesale distributor of exterior and interior building products.
- ABC Supply is proud to be an employee-first company.
- In fact, we have won the Gallup Exceptional Workplace Award every year since its inception in 2007, and Glassdoor has named us one of the best places to work in the country.
- Be part of a company that recognizes your talents, rewards your efforts, and helps you reach your full potential.
- At ABC Supply, we have YOUR future covered.
Responsibilities
- Design, develop, and deliver large-scale data systems, data processing, and data transformation Pipelines.
- Collaborate with stakeholders to understand business needs and work closely with business to deliver enterprise grade datasets that are reliable, flexible, scalable, and provide low cost of ownership.
- Develop optimized and scalable batch integration solutions for ABC Supply, including traditional DW workloads and nightly large extracts that are scheduled.
- Extract data from various sources, transform it into a usable format, and load it into Azure data lake using ADF pipelines, Databricks, Pyspark and SQL.
- Design and build data models – star schema, snowflake.
- Understand common analytical data models like Kimball.
- Build physical data models that align with best practice and requirements.
- Plan, review, and perform the implementation of database changes for integrations/DW work.
- Work with BI team, PO to build required tables and transform data to load into Snowflake/Dremio.
- Perform data management tasks.
- Recommend ways to improve data reliability, efficiency, and quality.
Requirements
- Master’s degree in Computer Science, IT/IS, or related field of study and two (2) years of work experience in the job offered or related occupation in which the required experience was gained.
- In lieu of a Master’s degree in Computer Science, IT/IS, or related field of study and two (2) years of work experience in the job offered or related occupation in which the required experience was gained, employer will accept a Bachelor’s degree in Computer Science, IT/IS, or related field of study and five (5) years of experience in the job offered or related occupation in which the required experience was gained.
- Must also have demonstrated experience in the following: Enterprise integration patterns (EIP), data warehouse modeling, ETL processes, and database management; Development and data warehouse requirements gathering, analysis and design; Cloud native
- Modern Data Engineering projects; Designing, building, and deploying scalable data pipelines; Python, Pyspark and Spark SQL; and Analytical data models such as Kimball.
Pay
123,600.00 - $130,000.00/year.
Benefits
- Health, dental, and vision coverage - eligible after 60 days, low out of pocket 401(k) with generous company match - eligible after 60 days, immediately vested
- Employer paid employee assistance program
- Employer paid short term and long term disability
- Employer paid life insurance
- Flex spending Paid vacation
- Paid sick days
Primary Work Location
1 ABC Parkway, Beloit, WI 53511.
Additional Locations
N/A Work Shift: Not Specified To apply, submit a resume to https://www.abcsupply.com/, or submit a resume to https://jobcenterofwisconsin.com/, or mail resume to: ABC Supply NSC, LLC, Attn: HR, 1 ABC Parkway, Beloit, WI 53511.
Must Reference Job Title
IT Data Engineer & Job Code: [Requisition Number provided by ABC Supply NSC, LLC]. EOE.
Paid holidays
Equal Opportunity Employer / Drug Free Workplace ABC Supply values diversity and we actively encourage women, minorities, and veterans to apply. #INDABCDNP #LI-DNI
