Data Engineer (AppleCare Finance)

Summary

Posted: Nov 5, 2024

Role Number:200577479

Do you love thinking analytically? Are you passionate about using your financial knowledge to navigate complex challenges? Just as our customers find value in Apple products, the Finance group finds value for both Apple and its shareholders. As part of this group, you’ll play an integral role in ensuring our day-to-day financial health. You and your team will support Apple’s growth, both top and bottom line, by applying the same level of innovation toward financial matters as we do toward our products and services. You’ll also collaborate with Apple teams across the world to develop more effective investment strategies and risk management. Finance is essential to upholding our global commitment to excellence, and it is directly responsible for shaping the company’s future. Join us, and you’ll have a meaningful role in continuing Apple’s legacy of efficiency and success. We are looking for a skilled Data Engineer with a proven track record in building and troubleshooting issues in complex data sets from multiple data sources. This role requires candidate with hands-on expertise in advanced SQL scripting, ETL methodologies, data visualization, data validations, and problem-solving skills to uncover insights and drive business decisions.

Description

– Design and implement end-to-end database solutions across cloud data warehouses (such as Snowflake), lakehouse environments (e.g., S3), and enterprise solutions (SLM/S4 Hana) – Ensure data integrity and provide meticulous attention to data quality in all business analytics solutions. – Create test strategies, test scripts, and test plans to validate complex BI data from sources like SAP SLM and S4 Hana systems and other sources. – Develop and maintain complex PL/SQL scripts and apply scripting languages like Python to automate workflows. – Build and maintain normalized database designs and data models to ensure data accuracy and efficiency. – Collaborate with stakeholders to understand business needs, translating them into technical solutions. – Deliver impactful data visualizations in Tableau that bring insight and drive business outcomes – Leverage data storytelling techniques to present data findings, insights, and hidden patterns to both technical and non-technical stakeholders.

Minimum Qualifications

• 2 years of experience of relevant experience
• Bachelor’s Degree or equivalent

Preferred Qualifications

• 4-6 years of relevant, progressive experience as a Data Analyst, Data Engineer or other relevant field
• Shown experience in BI data testing and data validations; familiarity with ETL tools (e.g., Dataiku, Keystone, Alteryx), version control tools (e.g., GitHub), event streaming platforms (Kafka), and deployment tools (e.g., Jenkins); Proficiency in PL/SQL scripting and scripting languages such as Python
• Demonstrated experience in data visualization and reporting tools, particularly Tableau
• Experience in data modeling, normalized database design, and business metrics application
• Exceptional data-driven understanding with the ability to draw insights, uncover patterns, and solve complex business problems through data analysis
• Solid experience in data engineering tools and concepts, data pipeline development, data model design, and aggregation strategies, in support of responsive and highly interactive data products
• Experience in data wrangling and ensuring data integrity across various projects
• Strong communication skills with meticulous attention to detail for translating data insights into business impact