Data Warehouse Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Lands'​ End · 4 hours ago

Data Warehouse Engineer

Lands' End is seeking a Data Warehouse Engineer who will be responsible for developing integrations using enterprise ETL tools to meet business requirements. The role involves mentoring junior developers, leading design sessions, and ensuring the delivery of EDW/BI applications while adhering to established standards and performance expectations.

ApparelE-CommerceFashionHome DecorLifestyleRetailRetail Technology
check
H1B Sponsor Likelynote

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

Qualification

SQLPython (PySpark)ETL/ELT pipelinesCloud data warehousesAWS servicesShell scriptingPipeline OrchestrationVersion control (Git)Agile/Scrum experienceCommunication skillsMentoring

Required

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

Preferred

Experience working with Agile/Scrum teams a plus

Company

Lands'​ End

company-logo
Lands’ End, Inc. (NASDAQ: LE) is a leading multi-channel retailer of clothing, accessories, footwear and home products.

H1B Sponsorship

Lands'​ End has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (10)
2024 (5)
2023 (12)
2022 (12)
2021 (6)
2020 (7)

Funding

Current Stage
Public Company
Total Funding
$535M
2024-01-02Post Ipo Debt· $260M
2020-09-09Post Ipo Debt· $275M
2014-04-07IPO

Leadership Team

leader-logo
Andrew McLean
CEO
linkedin
leader-logo
Bernie McCracken
Chief Financial Officer
linkedin
Company data provided by crunchbase