IT Data Warehouse Engineer

ABC Supply Co. Inc.

Data Warehouse Engineer focused on developing data integration solutions for ABC Supply, ensuring efficient data management and transformation processes across various platforms.

Posted 5/2/2026full-timeRemote • 🇺🇸 United StatesSeniorLeadWebsite

Tech Stack

Tools & technologies

AzureETLPySparkPythonSparkSQL

About the role

Key responsibilities & impact

Develops batch integration solutions for ABC Supply.
This includes traditional DW workloads and nightly large extracts that are scheduled.
Design and Build Data models – star schema, snowflake
Create ADF pipelines to bring new data from various sources
Create Data bricks notebooks for Data transformation
Documents all solutions as needed using ABC standard documentation.
Plans, reviews, and performs the implementation of database changes for integrations/DW work.
Maintain integration documentation and audit tools.
To include developing/updating the integration dashboard.
Work with BI team, PO to build required tables and transform data to load into Snowflake
Provides support for database/database servers as a member of the Data Management team.
Works with project management and business analysis team to provide estimates and ensure documentation of all requirements.
Provide logical layers (database views) for end-user access to data in database systems.
Partners with functional support and help desk teams to ensure communication, collaboration and compliance with support process standards at ABC.
Performs data management tasks as needed.

Requirements

What you’ll need

A Bachelor's Degree in Computer Science or a related field is required.
A high school diploma and/or equivalent combination of education and work experience may be substituted.
A minimum of 7 years relevant experience of development experience in Data warehousing and various ELT or ETL tools
Preferred experience in Data bricks, Azure, ADF (Azure Data Factory)
A minimum of 5 years' experience building database tables and models.
Must be able to write Complex SQL for DDL and DML operations fluently.
Must have hands on experience with Python, Pyspark, Spark SQL
Strong understanding of enterprise integration patterns (EIP) and data warehouse modeling.
Experience with development and data warehouse requirements gathering analysis and design.
Possess strong business acumen and consistently demonstrates forward thinking.
Eagerly and proactively investigates new technologies.
Is able to effectively work with ambiguous or incomplete information.
Must have a strong working knowledge of technical infrastructure, protocols and networks.
Must have strong experience on multiple hardware and software environments and be comfortable in heterogeneous systems.
Must be able to routinely work with little or no supervision.
Must be able to effectively and efficiently handle multiple and shifting priorities.

Benefits

Comp & perks

Health, dental, and vision coverage
Employer paid life insurance
401(k) with generous company match
Flex spending
Paid time off
Paid holidays

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Data warehousingELTETLComplex SQLPythonPysparkSpark SQLData modelingADFData bricks

Soft Skills

business acumenforward thinkingproblem solvingcommunicationcollaborationadaptabilityindependenceprioritizationinvestigative skillsworking with ambiguity

Certifications

Bachelor's Degree in Computer Sciencerelated field degree