Data Warehouse Engineer (Remote)

Job Category: Data Analytics/Warehousing, & BI

Requisition Number: DATAW006460

Posted: January 30, 2026

Job Type: Full-Time

Remote: Yes

Location: Lands' End Inc (B5), 5 Lands End Ln, Dodgeville, WI 53533, USA

Job Overview
As a Data Warehouse Engineer, you are responsible for developing integrations using enterprise Extract, Transform, and Load (ETL) tools to meet business requirements. You have an advanced understanding of one or more of the tools in the enterprise ETL toolset and can create very complex integrations. You mentor junior members of the team on development techniques and set standards and design patterns for the rest of the team to follow. You are a thought leader on the team and consistently lead and challenge others on the team to drive towards efficient and supportable solutions.

Responsibilities

Develop integrations that use standards and design patterns defined by the technical team and that meet all approved requirements and design specifications

Unit test developed integrations to ensure they are meeting defined requirements for business rules and performance expectations

Provide accurate estimates for work assigned to you, meet agreed deadlines and specifications, record accurate time and communicate to project management when any issues arise that prevent you from meeting agreed timelines or agreed specifications

Support developed EDW/BI applications to ensure 24/7 delivery of those applications and notify stakeholders when issues arise with delivery of those applications or defined service level agreements. Solicit help from team members when troubleshooting issues outside of your area of expertise

Mentor junior developers and review code

Organize project or support team meetings to discuss production issues or design considerations

Provide accurate estimates for work assigned to you and others, meet agreed upon deadlines, record accurate time and communicate to management when timelines will not be met by you or the team

Define standards and design patterns to be used by the technical team

Translate a Functional Specification into a Technical Specification provided by a Business Analyst

Perform as a thought leader on the team by leading design sessions and challenging designs of others in a respectful manner to get an optimal design

Keep an enterprise view of the company’s data by driving towards common data definitions and design and developing reusable reporting and integration assets

Skills

3+ years of professional experience in data engineering or data warehousing

Strong proficiency in SQL and experience in developing complex queries

Proficiency in Python (PySpark), specifically with ETL pipelines

Intermediate experience in Shell scripting to perform file operations and run shell commands

Develop and manage ETL/ELT pipelines using tools such as AWS Glue and Databricks that power the Data Lakehouse Architecture

3+ years of experience with cloud data warehouses such as AWS Redshift, Snowflake, Synapse

Experience working with structured and semi-structured data (Parquet, Avro, JSON, Delta) and open table formats such as Apache Hudi, Delta Tables

Experience working with AWS services such as S3, Redshift, Glue, Secrets Manager, Cloud Watch, and EC2

Experience in performing Pipeline Orchestration using tools such as Stonebranch Universal Automation Center, Lake flow, or Air Flow

Strong understanding of version control (Git) and modern CI/CD workflows

Ability to lead design and review sessions and provide constructive feedback to others as it relates to coding standards and industry best practices

Strong verbal and written communication skills

Ability to understand requirement documents and technical specifications and translate those into code

Experience working with Agile/Scrum teams a plus

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

#J-18808-Ljbffr