Data Engineer - W2

TEKsystems
$70.00 - $90.00 / hr
United States, Washington, Seattle
Mar 11, 2025
Description Job Description As an Engineer II, you will bring a high level of technical knowledge, but also an ability to spread knowledge to your co-workers. You will help form the core of our engineering practice at lululemon by contributing to all areas of development and operations (pre-production to production). You will be an example of what good engineering looks like and help others around you refine their skills. You will be part of a day-to-day production release team and may perform on-call support functions as needed. Having a DevOps mindset is the key to success in this role, as Engineers are commonly part of full DevOps teams that "own" all parts of software development, release pipelines, production monitoring, security and support. This role will be supporting the Membership Tiered Program - Membership program is implementing several tiers of membership to their guests. The Martech team needs to hire 2 data engineers for pipeline development, integrate data from the database to create guest segments based on guest activity and views on membership activities. They will also be supporting data warehouse work for Membership. Job Description As an Engineer II, you will bring a high level of technical knowledge, but also an ability to spread knowledge to your co-workers. You will help form the core of our engineering practice at lululemon by contributing to all areas of development and operations (pre-production to production). You will be an example of what good engineering looks like and help others around you refine their skills. You will be part of a day-to-day production release team and may perform on-call support functions as needed. Having a DevOps mindset is the key to success in this role, as Engineers are commonly part of full DevOps teams that "own" all parts of software development, release pipelines, production monitoring, security and support. The initiatives include but not limited to the following: * GA4 Analytics Data share with lululemon Snowflake instance * Snowflake Data Engineering work in supporting Martech initiatives * Analysis of Adobe Analytics data and GA4 analytics to answer business questions. * Operationalize Data Pipelines in our Martech System Data Engineering Projects: * Data pipeline creation and maintenance. Stack: Google Cloud Platform (GCP), Azure Cloud, Azure Databricks, Snowflake * Includes engineering documentation, knowledge transfer to other engineers, future enhancements and maintenance * Create secure data views and publish them to the Enterprise Data Exchange via Snowflake for other lululemon teams to consume * Data pipeline modernization and migration via Databricks Delta Live Tables (DLT) and Unity Catalog * Leverage existing CICD process for pipeline deployment * Adhere to PII encryption and masking standards * Data Engineering Tools/Techniques: * Orchestration tools - ADF, AirFlow, FiveTran * Languages - SQL, Python * Data Modeling - Star and Snowflake Schema * Streaming - Kafka, EventHub, Spark, Snowflake Streaming * DevOps Support: * Support improvements to current CICD process * Production monitoring and failure support * Provide an escalation point and participate in on-call support rotations * Participate in discussions on how to improve DevOps * Be aware of product release and how that impacts our business - Take part in Agile ceremonies * Perform engineering assignments using existing procedures and best practices * Conduct research to aid in product troubleshooting and optimization efforts * Participate in and contribute to our Engineering Community of Practice Skills Python, Big data, Data warehouse, Etl, Development, azure, Azure Data Factory, Azure Databricks, Azure SQL Server, Snowflake, data pipelines Top Skills Details Python,Big data,Data warehouse,Etl Additional Skills & Qualifications * 5+ years of relevant engineering experience * Experience in Big Table, ClickStream data migration, Semi-Structured and Un-Structured data management * Experience with developing complex SQL queries * Experience with CI/CD principles and best practices * Experience with Azure Data Factory, Azure Data Bricks, Snowflake, and Storage Accounts. * Experience working with a Data Engineering team and understanding of Data Engineering practices. * Ability to learn, understand, and work quickly with new emerging technologies, methodologies, and solutions in the Cloud/IT technology space * Experience with bug tracking and task management software such as JIRA, etc. * Experienced in managing outages, customer escalations, crisis management, and other similar circumstances. Experience Level Intermediate Level Pay and Benefits The pay range for this position is $70.00 - $90.00/hr. Workplace Type This is a hybrid position in Seattle,WA. About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.