Software Development Engineer - Applications
About The Position
Work with Apple's IS&T team to drive development of self-service tools and data models to better support business analytics by designing and developing data pipelines, building data products, building tools to improve efficiency of analytical and reporting needs of users across Apple in the cloud Enterprise Data Warehouse. Participate in review of data solutions during design and development phase including Physical Model reviews with the development teams to provide inputs on improving performance. Perform continuous analysis of the database environment to capitalize on system-wide tuning opportunities. Perform optimization by continuous analysis of the database environment to capitalize on system-wide tuning opportunities and also looking at database resource utilization by intensive ETL and individual user queries. Analyze workloads to improve throughputs to meet response-time SLA's while optimizing resource consumption. Drive new platform features testing, rollout and adoption. Identify problem areas, suggest and deliver scalable solutions leveraging cloud based technologies. Partner with groups across Apple which include Operations, Sales, Retail, Finance, AppleCare, Marketing, Legal and others on data governance, reporting tools, hierarchy management and KPI's. Review software designs to ensure that they are optimized for performance, scalability and be a leader with vision and champion in automation. Provide second-level support to address any system wide service performance and stability issues. Work on Enterprise Data Warehouse (EDW) platform to provide a scalable, high performance, and active data platform. Build cloud-scale and micro/macro-services architectures.
Requirements
- Bachelor's degree in Computer Science, Computer Engineering, Mechanical Engineering or a related field
- 5 years of progressive, post-baccalaureate experience in the job offered or a related occupation
- 5 years of experience with Snowflake Enterprise data warehousing, architecture, execution methodology in building data metrics pipeline, and performance optimization
- 5 years of experience using SQL to conduct data analysis, optimizing and improving query performance to meet the data and reporting needs of business teams
- 5 years of experience creating frameworks and applications using Python to bring in automation, self-service tools to improve overall efficiency of the platform
- 5 years of experience using AWS Cloud Services like EC2, S3, IAM, ELB, Glacier, EKS, Route 53 and associated services to build, deploy, manage robust scalable applications in Cloud
- 5 years of experience using Cloud deployment techniques like CICD, git deployment, Terraform and cloud infrastructure services to deploy and effectively running the services in the platform
- 5 years of experience managing and optimizing relational and NoSQL databases, including Snowflake, PostgreSQL, Cassandra, and SQL Workbench, to store and query structured/unstructured data efficiently
- 5 years of experience utilizing big data technologies like Spark, Hadoop, and Presto to process large datasets, optimize queries, and improve data analytics performance
Responsibilities
- Design and develop data pipelines
- Build data products
- Build tools to improve efficiency of analytical and reporting needs
- Participate in review of data solutions during design and development phase
- Perform continuous analysis of the database environment to capitalize on system-wide tuning opportunities
- Perform optimization by continuous analysis of the database environment
- Analyze workloads to improve throughputs to meet response-time SLA's while optimizing resource consumption
- Drive new platform features testing, rollout and adoption
- Identify problem areas, suggest and deliver scalable solutions leveraging cloud based technologies
- Partner with groups across Apple on data governance, reporting tools, hierarchy management and KPI's
- Review software designs to ensure that they are optimized for performance, scalability
- Provide second-level support to address any system wide service performance and stability issues
- Work on Enterprise Data Warehouse (EDW) platform to provide a scalable, high performance, and active data platform
- Build cloud-scale and micro/macro-services architectures
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
