Experienced Full Stack Data Engineer – Web & Cloud Application Development for E-commerce and Business Intelligence

About Us

Costco is a global leader in the retail industry, with a reputation for providing exceptional customer service and a family-friendly work environment. As one of the world's largest retailers, we have a presence in 14 countries and continue to grow and expand our operations. Our commitment to excellence has earned us a spot on Forbes' list of the "World's Best Companies" – we're ranked seventh! At Costco, we believe in investing in our employees and providing them with the tools and resources they need to succeed. If you're looking for a challenging and rewarding career, we invite you to join our team.

About the Role

We're seeking an experienced Full Stack Data Engineer to join our team and help drive business intelligence and e-commerce initiatives. As a key member of our data engineering team, you'll be responsible for designing and implementing data pipelines to support our business needs. You'll work closely with our product owners, BI architects, and data stage teams to design, build, test, and automate data pipelines that are relied upon across the organization as the single source of truth. If you have a passion for data engineering and a strong background in software development, we encourage you to apply for this exciting opportunity.

Key Responsibilities

• Design, develop, implement, and operationalize ETL/ELT processes using Informatica Cloud (IICS).
• Collaborate with data designers and data/BI architects to design data pipelines and suggest continuous improvement of data storage, data ingestion, data quality, and organization.
• Develop and maintain optimal data pipeline engineering.
• Identify, design, and execute internal cycle enhancements: automating manual processes, improving data delivery.
• Execute large data and NoSQL solutions by creating flexible data handling stages to drive high-value insights to the organization.
• Support the development of Information Dictionaries and Information Scientific categorization for product solutions.
• Exhibit a strong understanding of coding and programming concepts to build data pipelines (e.g., data transformation, data quality, data integration, etc.).
• Assemble data models with data designers and create data pipelines to store data in defined data models and designs.
• Show a strong understanding of data integration strategies and tools (e.g., Extract, Transform, Load (ETL)/Extract, Load, Transform (ELT)) tools and database design.
• Show a strong understanding of database storage concepts (data lake, social databases, NoSQL, Chart, data warehousing).
• Identify ways to improve data reliability, efficiency, and quality of data management.
• Direct impromptu data recovery for business reports and dashboards.
• Evaluate the integrity of data from various sources.
• Oversee database setup including installing and upgrading software and maintaining necessary documentation.
• Monitor database activity and resource usage.
• Perform peer review for another Data Engineer's work.

Requirements

• 2+ years' experience designing and operationalizing data pipelines with large and complex datasets.
• 2+ years' hands-on experience with Informatica IICS or PowerCenter.
• 2+ years' experience in Data Modeling, ETL, and Data Warehousing.
• 2+ years' experience working with Cloud technologies like ADLS, Azure Databricks, Azure Synapse, Azure Cosmos DB, and other big data innovations.
• Experience with advanced e-commerce and clickstream data.
• Broad experience working with various data sources (SQL, Hive, flat files (csv, delimited), Web API, XML).
• High-level SQL skills. Strong understanding of social databases and business intelligence; ability to write complex SQL queries against multiple data sources.
• Strong understanding of database storage concepts (data lake, social databases, NoSQL, Chart, data warehousing).
• Ability to work in a fast-paced agile development environment.
• Flexibility to address business needs including weekends, holidays, and on-call responsibilities on a rotational basis.

Preferred Qualifications

• BA/BS in Computer Science, Engineering, or similar programming/services experience.
• Azure Certifications.
• Experience implementing data integration methods like event/message-based integration (Kafka, Azure Event Hub), ETL.
• Experience with Git/Azure DevOps.
• Experience delivering data solutions through agile software development approaches.
• Openness to the retail industry.
• Excellent verbal and written communication skills.
• Experience with UC4 Job Scheduler.
• Experience with Power BI.

Benefits

Costco offers a comprehensive benefits package to our employees, including:

• Medical benefits: Costco offers extensive medical benefits to qualified employees, including clinical, dental, and vision coverage. These benefits may extend to the employee's dependents as well.
• 401(k) Retirement Savings Plan: Costco provides a 401(k) retirement savings plan to help employees save for their future. The organization may offer a matching contribution to qualified employees' retirement savings.
• Employee Stock Purchase Plan (ESPP): Costco offers an Employee Stock Purchase Plan (ESPP) that allows qualified employees to purchase company stock at a discounted price, commonly through payroll deductions.
• Life insurance and Disability Insurance: Costco provides life insurance and disability coverage to qualified employees, offering financial security in the event of death or disability.
• Paid Time Off (PTO): Costco offers paid time benefits, including vacation days, holidays, and sick leave, to qualified employees. The amount of PTO may vary based on residency and position within the organization.
• Education Reimbursement: Costco offers education reimbursement benefits to qualified employees who wish to further their education or pursue work-related courses or degrees. The organization may reimburse a portion of education costs upon successful completion of approved courses.
• Employee Discounts: Costco employees are eligible for discounts on products and services offered by the organization. This includes discounts on Costco warehouse items as well as discounts on Costco travel services, optical services, and other benefits.
• Employee Assistance Program (EAP): Costco provides an Employee Assistance Program (EAP) to help employees and their families with various personal and business-related challenges. This may include counseling services, legal assistance, financial counseling, and other support services.
• Career Advancement Opportunities: Costco offers opportunities for career advancement and progression to its employees. This may include training programs, mentorship opportunities, and internal advancement opportunities for qualified employees.
• Balance between work and personal life: Costco recognizes the importance of balance between work and personal activities and may offer flexible scheduling options, remote work opportunities, and other benefits to help employees balance their work and personal lives.

Join Our Team

If you're a motivated and experienced data engineer looking for a challenging and rewarding career, we invite you to join our team. Apply now and take the first step towards a successful and fulfilling career with Costco!