Experienced Data Engineer - Data Analytics and Pipeline Development Specialist for a Leading Retail Company

Introduction to Costco and the Role

Come join one of the world's most successful and admired companies, Costco, as a Data Engineer - Data Analytics. As a key member of our IT team, you will play a crucial role in shaping the technical future of our organization. With operations in 14 countries and a reputation for excellence, we are committed to providing a family-oriented, employee-driven environment where our team members can thrive and succeed. As evidence of our dedication to our employees, Costco ranks seventh in Forbes' "World's Best Employers" list.

Job Overview

As a Data Engineer - Data Analytics, you will be responsible for designing 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 development, coordination, and collaboration with DevOps engineers during CI/CD. The role requires a strong foundation in programming and SQL, followed by expertise in data storage, modeling, cloud, data warehousing, and data lakes. You will work closely with Data Architects, Data Scientists, and BI Architects to design and maintain scalable data models and pipelines.

Key Responsibilities

• Develop and operationalize data pipelines to power analytics and data services, focusing on data engineering to build and deliver automated data pipelines from a variety of internal and external data sources.
• Collaborate with product owners, engineering, and data platform teams to design, build, test, and automate data pipelines that are relied upon across the organization as the single source of truth.
• Communicate technical concepts to non-technical audiences both in written and verbal form.
• Gather large, complex datasets to meet business requirements.
• Work closely with Data Architects to align on data engineering requirements provided by the latter.
• Design and maintain optimal data pipeline architecture.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery.
• Implement big data and NoSQL solutions by developing scalable data processing platforms to drive high-value insights to the organization.
• Support development of Data Dictionaries and Data Taxonomy for product offerings.
• Demonstrate strong understanding with coding and programming concepts to build data pipelines (e.g., data transformation, data quality, data integration, etc.).
• Build data models with Data Modeler and develop data pipelines to store data in defined data models and formats.
• Demonstrate strong understanding of data integration techniques and tools (e.g., Extract, Transform, Load (ETL)/Extract, Load, Transform (ELT)) and database architecture.
• Identify ways to improve data reliability, efficiency, and quality of data management.
• Lead ad-hoc data retrieval for business reports and dashboards.
• Review the integrity of data from various sources.
• Manage database design including installing and upgrading software, and maintaining significant documentation.
• Monitor database activity and resource utilization.
• Perform peer review for another Data Engineer's work.

Requirements and Qualifications

To be successful in this role, you should have:

• 3+ years of experience designing and operationalizing data pipelines with large and complex datasets.
• 3+ years of hands-on experience with Informatica PowerCenter.
• 3+ years of experience in Data Modeling, ETL, and Data Warehousing.
• 3+ years of hands-on experience with Informatica IICS.
• 3+ years of experience working with Cloud technologies, such as ADLS, Azure Data Factory, Azure Databricks, Databricks Live Table, Spark, Azure Synapse, Universe DB, and other big data technologies.
• Broad experience working with various data sources (SQL, Oracle database, flat files (csv, delimited), Web API, XML).
• Advanced SQL skills. Strong understanding of relational databases and business data; ability to write complex SQL queries against multiple data sources.
• Strong understanding of database storage concepts (data lake, relational databases, NoSQL, Graph, data warehousing).
• Able to work in a high-speed agile development environment.
• Scheduling flexibility to meet the needs of the business, including weekends, holidays, and 24/7 on-call duties on a rotational basis.

Preferred Qualifications

• BA/BS in Computer Science, Engineering, or equivalent programming/services experience.
• Azure Certifications.
• Experience implementing data integration strategies, such as event/message-based integration (Kafka, Azure Event Hub), ETL.
• Experience with Git/Azure DevOps.
• Experience delivering data solutions through agile software development methodologies.
• Familiarity with the retail industry.
• Excellent verbal and written communication skills.
• Experience working with SAP integration tools, including Bodies.
• Experience with UC4 Job Scheduler.

Career Growth and Development

At Costco, we are committed to the growth and development of our employees. As a Data Engineer - Data Analytics, you will have the opportunity to work on challenging projects, collaborate with experienced professionals, and develop your skills in a dynamic and supportive environment. We offer a range of training and development programs, including mentorship, coaching, and education assistance, to help you achieve your career goals.

Work Environment and Company Culture

Our company culture is built on a foundation of respect, integrity, and teamwork. We value our employees and strive to create a work environment that is inclusive, supportive, and rewarding. As a member of our team, you can expect:

• A collaborative and dynamic work environment.
• A culture of innovation and continuous improvement.
• Opportunities for professional growth and development.
• A comprehensive benefits package, including medical, dental, and vision coverage, 401(k) matching, and paid time off.
• A competitive salary and bonus structure.

Compensation and Benefits

We offer a competitive compensation package, including a salary of $26 per hour, as well as a range of benefits, including:

• Medical, dental, and vision coverage.
• 401(k) matching.
• Paid time off.
• Life insurance.
• Disability insurance.
• Employee assistance programs.

Conclusion

If you are a motivated and experienced Data Engineer - Data Analytics looking for a new challenge, we encourage you to apply for this exciting opportunity. As a member of our team, you will have the chance to work on complex and rewarding projects, develop your skills, and contribute to the success of one of the world's most admired companies. Don't miss out on this opportunity to take your career to the next level and join our dynamic team of professionals.

Apply now and let your career be redefined!