• Job Description

  Req#: 8411

  Costco Travel IT is responsible for the technical future of Costco Wholesale, the third largest retailer in the world with wholesale operations in fourteen countries. Despite our size and explosive international expansion, we continue to provide a family, employee centric atmosphere in which our employees thrive and succeed. As proof, Costco ranks seventh in Forbes “World’s Best Employers”.

  This is an environment unlike anything in the high-tech world and the secret of Costco’s success is its culture. The value Costco puts on its employees is well documented in articles from a variety of publishers including Bloomberg and Forbes. Our employees and our members come FIRST. Costco is well known for its generosity and community service and has won many awards for its philanthropy. The company joins with its employees to take an active role in volunteering by sponsoring many opportunities to help others.

  Come join the Costco Travel IT family. Costco IT is a dynamic, fast-paced environment, working through exciting transformation efforts. We are building the next generation retail environment where you will be surrounded by dedicated and highly professional employees.

  Responsible for developing and operationalizing data pipelines to make data available for consumption (reports and advanced analytics). This includes data ingestion, data transformation, data validation / quality, data pipeline optimization, orchestration; and engaging with DevOps Engineer during CI / CD. The role requires a grounding in programming and SQL, followed by expertise in data storage, modeling, cloud, data warehousing, and data lakes. The Data Engineer works closely with Data Architects, Data Scientists and BI Engineers to design and maintain scalable data models and pipelines.

  Costco Travel is looking for an experienced Data Engineer to research, design, and maintain the future of our Costco Travel distributed database layer in a microservice and hybrid cloud/on-prem infrastructure. This position will also assist with building and maintaining the data pipeline from the travel engine databases to our data warehouse system. This role will work closely within IT to ensure system stability and performance is at the highest possible level. Individuals in this role will work with the Infrastructure team to ensure the best practices for multi-data source implementation, and define best practices for both Costco Travel’s line of business applications and Data Warehousing systems. The Data Engineer will have a background in practical Database and DW concepts and architectures (dimensions, facts, aggregates, and appropriate use of various data storage products and their implementations), along with experience developing data models, creating, and validating ELT data transit systems to connect our line of business systems with our DW and BI teams.

  If you want to be a part of one of the worldwide BEST companies “to work for”, simply apply and let your career be reimagined.

  ROLE

  ● Demonstrates ability to communicate technical concepts to non-technical audiences both in written and verbal form.

  ● Assembles large, complex data sets to meet business requirements.

  ● Works in tandem with Data Architects to align on data architecture requirements provided by the latter.

  ● Creates and maintains optimal data pipeline architecture.

  ● Identifies, designs, and implements internal process improvements: automating manual processes, optimizing data delivery.

  ● Implements big data and NoSQL solutions by developing scalable data processing platforms to drive high-value insights to the organization.

  ● Supports development of Data Dictionaries and Data Taxonomy for product solutions.

  ● Demonstrates strong understanding with coding and programming concepts to build data pipelines (e.g. data transformation, data quality, data integration, etc.).

  ● Builds data models with Data Architect and develops data pipelines to store data in defined data models and structures.

  ● Demonstrates strong understanding of data integration techniques and tools (e.g. Extract, Transform, Load (ETL) / Extract, Load, Transform (ELT)) tools and database architecture.

  ● Demonstrates strong understanding of database storage concepts (data lake, relational databases, NoSQL, Graph, data warehousing).

  ● Identifies ways to improve data reliability, efficiency and quality of data management.

  ● Conducts ad-hoc data retrieval for business reports and dashboards.

  ● Assesses the integrity of data from multiple sources.

  ● Manages database configuration including installing and upgrading software and maintaining relevant documentation.

  ● Monitors database activity and resource usage.

  ● Performs peer review for another Data Engineer’s work.

  ● Assists with development, building, monitoring, maintaining, performance tuning, troubleshooting, and capacity estimation.

  ● Sources data from the operational systems.

  ● Prepares the database-loadable file(s) for the Data Warehouse.

  ● Manages deployment of the data acquisition tool(s).

  ● Monitors and maintains Data Warehouse/ELT.

  ● Monitors, reports and resolves data quality.

  ● Works closely with all involved parties to ensure system stability and longevity.

  ● Supports and maintains Business Intelligence functionality.

  ● Evaluates, understands and implements patches to the Data Warehouse environment.

  ● Loads best practices and designs multidimensional schemas.

  REQUIRED

  ● 2+ years’ programming experience in Snowflake, Hadoop, or other Data Warehouse technologies; Snowflake preferred.

  ● 2+ years’ data modeling/data architecture experience.

  ● 3+ years’ working on cloud platforms; Azure preferred.

  ● 3+ years’ experience in T-SQL, SQL, ELT/ETL performance tuning.

  ● 2+ years’ experience in Microsoft SQL Server 2008R2 or newer.

  ● 2+ years’ experience with SSIS or equivalent ETL tool.

  ● 2+ years’ experience in SQL/Stored Procedure development.

  ● Understanding of semi-structured / unstructured data using JSON, AVRO, Parquet, CSV, etc.

  ● Experience with complex multi-server environments and high availability environments.

  ● Experience using Azure Data Factory, Five Tran, Spark or other similar data integration tools.

  ● Experience with system monitoring, log management, and error notification.

  ● Fundamental network and IT infrastructure knowledge.

  ● Highly motivated; able to work independently, multi-task, respond to changing priorities, and initiative to own specific tasks.

  ● Strong problem determination, troubleshooting, and resolution skills.

  ● Excellent written and oral communication skills & customer service skills.

  ● Ability to work analytically to solve both tactical and strategic problems.

  Recommended

  ● High School Diploma or GED preferred.

  Required Documents

  ● Cover Letter

  ● Resume

  California applicants, please click here to review the Costco Applicant Privacy Notice.

  Pay Ranges:

  Level 2 - $100,000 - $135,000

  Level 3 - $125,000 - $165,000

  We offer a comprehensive package of benefits including paid time off, health benefits - medical/dental/vision/hearing aid/pharmacy/behavioral health/employee assistance, health care reimbursement account, dependent care assistance plan, short-term disability and long-term disability insurance, AD&D insurance, life insurance, 401(k), stock purchase plan to eligible employees.

  Costco is committed to a diverse and inclusive workplace. Costco is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or any other legally protected status. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to IT-Recruiting@costco.com

  If hired, you will be required to provide proof of authorization to work in the United States. Applicants and employees for this position will not be sponsored for work authorization, including, but not limited to H1-B visas.

• About the company

  Costco Wholesale Corporation is an American multinational corporation which operates a chain of membership-only warehouse clubs.

Notice