Data Warehouse Engineer

1 week ago Be among the first 25 applicants

• 6+ years (senior) of experience with Data Warehouse Engineering. Should have been a part of building warehouse from scratch in a large scale enterprise environment.
• Strong Experience with MYSQL Relational Databases
• Knowledge with cloud-based data warehouses (open to Snowflake, Amazon Red Shift, etc.). Ideally strong experience with multiple so can add perspective on which might be best fit.
• Python ETL Engineering Skills
• Experience with workforce/operations planning to gain insights from data to make business decisions

Top Skills' Details

• 6+ years (senior) of experience with Data Warehouse Engineering. Should have been a part of building warehouse from scratch in a large scale enterprise environment.
• Strong Experience with MYSQL Relational Databases
• Knowledge with cloud-based data warehouses (open to Snowflake, Amazon Red Shift, etc.). Ideally strong experience with multiple so can add perspective on which might be best fit.
• Python ETL Engineering Skills
• Experience with workforce/operations planning to gain insights from data to make business decisions

Personality:
Should be go-getter, good with ambiguity, down to earth, great communication, not afraid to collaborate and give ideas vs being order taker

Description

The Apple Store Online Operations team is seeking an Business/Data Analyst to join our Workforce Strategy & Analytics (WSA) group. We are looking for a highly skilled, data-driven professional with strong technical expertise in data architecture, data pipelines, and data governance. The ideal candidate will have a proven track record of designing and optimizing data systems that enable high-quality, scalable analytics to drive operational efficiency and continuous improvement.

Join our team and help shape how data is utilized across the organization to optimize processes, improve performance, and foster a culture of data-driven decision-making.

In this role, you will leverage your expertise in data manipulation, ETL processes, and data integration to build a unified data foundation, serving as the single source of truth for ASO Operations business performance and operational metrics. You will collaborate closely with cross-functional teams to design, implement, and maintain robust data pipelines, ensuring the data is clean, scalable, and easily accessible for actionable decision-making.

Additionally, you will play a critical role in developing and automating reporting systems that provide stakeholders with timely, accurate insights, enabling data-driven business outcomes and operational improvements.

Responsibilities

Define and standardize operational metrics for ASO Operations, ensuring data consistency and alignment across global teams, and building data pipelines that provide reliable, real-time visibility into key performance indicators (KPIs).

Design, build, and maintain scalable data pipelines to integrate new datasets from evolving business processes, working closely with cross-functional teams to ensure data flow is optimized for performance, reliability, and accessibility.

Develop and implement data strategies to enhance data infrastructure, ensuring the seamless integration of structured and unstructured data sources for comprehensive analysis and decision-making.

Perform quantitative analyses to identify data trends, correlations, forecasting patterns, and anomalies impacting KPIs. Collaborate with teams to ensure actionable insights, forecasts, and plans are derived from clean, integrated data that drive continuous optimization of ASO Operations.

Skills

Python, SQL, MySQL, data warehouse, data warehouse architecture, data warehouse ETL, ETL development, snowflake, redshift, KPI's

Bachelor’s degree in Computer Science or a technical degree, or 6+ years of relevant professional experience.

Experience with data engineering tools and technologies, including expertise in SQL (for data querying), Python (for ETL processes and data manipulation), and data pipeline frameworks.

Experience in designing, building, and maintaining data pipelines for data integration and data warehousing, ensuring high-quality, scalable, and reliable data flow across systems.

Exce…