Sr. Data Engineer

Posted Date: Aug- 3-2021

Job ID: 20684

Job Type: Full Time

Job Function: Information Technology

City: Seattle

State: Washington

Store: Seattle HQ

Remote Eligible: No



Please visit the Covid-19 Hiring Updates before applying


What's cool about this job

Business Intelligence & Analytics at REI has been going through a transformational journey to enable the co-op to be a data driven organization. Along with a complete revamp of the entire analytical platform ecosystem which includes onboarding new solutions and migrating to Cloud, the team continues to enhance our already rich data platforms with additional data that helps to drive actionable insights across the Co-op. The team also develops new analytical products in the form of reports, Dashboards and Data Science products to solve critical business problems.  Our team of Architects, Engineers, Business Analysts, Project Managers and Data Scientists use technologies such Snowflake, SAP BW, MongoDB, AWS Services, Tableau, Business Objects, Sigma Computing and programming languages like SQL, Python, R & Terraform to support multiple projects in data integration, analytics and data science. 

 As a Sr. Data Engineer, you will have the opportunity to build new data integrations and data products to solve complex data and business problems in support of our Marketing, Digital Retail, Physical Retail, Merchandising, Finance, Customer Insights and Supply Chain teams.  Working in an agile environment, you will collaborate with business partners and the rest of the team to build world class products. You also get to be part of a super fun team and an organization that values work-life balance and inspires you to live a life outdoors!

Responsibilities

  • Design, develop & deploy data pipelines between a variety of internal and external sources and the Enterprise Data Warehouse using SQL, Python and AWS services.
  • Ensure data quality and data availability by building accurate, audited, scalable and performant data interfaces that cleanse, organize and integrate disparate data into an easily consumable format for end-user facing reports and data science models.
  • Collaborate with the Product managers and Stakeholders to understand data needs, iterate and refine requirements and develop products that meets the goals.
  • Adhere and contribute to development best practices, version control and deployment strategies to ensure product quality, agility and recoverability.
  • Provide administration support  for AWS services, Database platform and analytics solutions.
  • Work closely with Production Support team to ensure comprehensive transition of developed products and provide ongoing Subject matter expertise and support.
  • Explore and learn the latest developments in AWS, Database platforms, Analytics toolsets and programming languages to introduce new capabilities to the team and identify opportunities to refine and improve the current solutions.

Bring your passion and expertise

  • Bachelor’s degree in computer science or related field, or equivalent training and experience.
  • 2+ years’ experience as a Data/ETL Engineer with Cloud Database technologies like Snowflake, Redshift, Bigquery, AzureDB.
  • 5+ years’ experience as a Data/ETL Engineer with Relational Database technologies like Oracle, SQL Server, Netzza, terradata
  • 5+ years of experience with writing advanced SQL queries.
  • Demonstrated strength in data modeling, ETL development, and data warehousing.
  • 2+ years of scripting experience in Python.
  • Knowledge of Agile and Scrum project methodologies utilizing Jira/Confluence
  • Experience in AWS services like S3, EC2 etc is highly desired
  • Must possess strong verbal and written communication skills, be self-driven, accountable and constant learner.
  • Experience working for a large retail company is preferred.
  • Experience in working with Data science and Reporting teams is preferred.
#LI-LM1

At REI we offer an enviable work environment that Fortune Magazine has recognized on the "100 Best Places to Work" list since the award's inception – 23 years in a row! Sure, we work hard, but it’s balanced with time off to play—a strategy that works for us as we continue to grow and thrive. Want to enjoy a workplace where you can be yourself, be heard and be respected while having a job that challenges you? This is the place.

With more than 160 retail locations (and growing), REI offers unique competitive benefits to its more than 15,000 employees, including healthcare, gear and apparel discounts, free equipment rentals and challenge grants to help employees reach personal outdoor goals, generous retirement plan contributions, public transit subsidy, adoptions assistance, paid sabbaticals, and more.

REI is an Equal Opportunity Employer

NEW YORK CORRECTION LAW
ARTICLE 23-A, Section 753
LICENSURE AND EMPLOYMENT OF PERSONS PREVIOUSLY CONVICTED OF ONE OR MORE CRIMINAL OFFENSES

§753. Factors to be considered concerning a previous criminal conviction; presumption.

1. In making a determination pursuant to section seven hundred fifty-two of this chapter, the public agency or private employer shall consider the following factors:

(a) The public policy of this state, as expressed in this act, to encourage the licensure and employment of persons previously convicted of one or more criminal offenses.

(b) The specific duties and responsibilities necessarily related to the license or employment sought or held by the person.

(c) The bearing, if any, the criminal offense or offenses for which the person was previously convicted will have on his fitness or ability to perform one or more such duties or responsibilities.

(d) The time which has elapsed since the occurrence of the criminal offense or offenses.

(e) The age of the person at the time of occurrence of the criminal offense or offenses.

(f) The seriousness of the offense or offenses.

(g) Any information produced by the person, or produced on his behalf, in regard to his rehabilitation and good conduct.

(h) The legitimate interest of the public agency or private employer in protecting property, and the safety and welfare of specific individuals or the general public.

2. In making a determination pursuant to section seven hundred fifty-two of this chapter, the public agency or private employer shall also give consideration to a certificate of relief from disabilities or a certificate of good conduct issued to the applicant, which certificate shall create a presumption of rehabilitation in regard to the offense or offenses specified therein.