Software Developer Engineer - Applications

Apple•Cupertino, CA

1d•$181,100 - $272,100•Onsite

About The Position

Imagine what you can do here. Apple is a place where extraordinary people gather to do their lives best work. Together we create products and experiences people once couldn’t have imagined, and now, can’t imagine living without. It’s the diversity of those people and their ideas that inspires the innovation that runs through everything we do. Design and implement optimum data structures in the appropriate data management system including Teradata, Oracle, Big Data Technologies and Snowflake. Identify and understand the data sources Data sources which have both structured & unstructured data that are relevant to the business problem. Collaborate to understand the business requirements, system architecture and data demographics with Data scientists, Business analysts to build new metrics and analysis tools. Build robust data pipelines and models by processing, cleansing, and verifying the integrity of data used for analysis. Develop data-set processes for data discovery, modeling, mining and archival. Extract and process data using Python, Shell scripting, complex SQL and calling rest APIs. Perform complex data analysis with large volumes of data using tools like Tableau, Spark, Business objects, ThoughtSpot. Develop ETL solutions using PL/SQL and stored procedures which would adhere to Apple's data security standards. Build reports and dashboards with Tableau, Business Objects. Identify opportunities and contribute ideas for automation and work closely with enablement teams on how to continuously improve speed and quality of solutions. Explore and adopt to new technologies which would solve the problem. 40 hours/week.

Requirements

Master’s degree or foreign equivalent in Software Engineering, Computer Science, or related field and 2 years of experience in the job offered or related occupation.
2 years of experience with Building robust data pipelines & data models to design and implement optimum data structures in the appropriate data management system including Teradata, Redshift, Oracle, Big Data Technologies and Hadoop Ecosystem.
2 years of experience Utilizing Python and Unix shell scripting to build data pipelines, Automation, and Scheduling.
2 years of experience Designing and developing dashboards using Tableau to have analytics insights of the data.
2 years of experience Developing reusable modules to create reusable data-set processes for data discovery, modeling and mining.
2 years of experience Using SQL to build ETL solutions for a large volumes of data
2 years of experience Designing, Developing, Deploying solutions following the SDLC coding standards
2 years of experience Developing ETL solutions which would adhere to data security and standards of the company in order to maintain Enterprise Data security.
2 years of experience Using Dremio or other tools for ad hoc data analytics
2 years of experience Using Tableau for data visualizations and reporting
2 years of experience Using Business Objects or other tools for detailed excel based reporting.
2 years of experience Using SQL & developing scripts in python for data analysis & data profiling.

Responsibilities

Design and implement optimum data structures in the appropriate data management system including Teradata, Oracle, Big Data Technologies and Snowflake.
Identify and understand the data sources Data sources which have both structured & unstructured data that are relevant to the business problem.
Collaborate to understand the business requirements, system architecture and data demographics with Data scientists, Business analysts to build new metrics and analysis tools.
Build robust data pipelines and models by processing, cleansing, and verifying the integrity of data used for analysis.
Develop data-set processes for data discovery, modeling, mining and archival.
Extract and process data using Python, Shell scripting, complex SQL and calling rest APIs.
Perform complex data analysis with large volumes of data using tools like Tableau, Spark, Business objects, ThoughtSpot.
Develop ETL solutions using PL/SQL and stored procedures which would adhere to Apple's data security standards.
Build reports and dashboards with Tableau, Business Objects.
Identify opportunities and contribute ideas for automation and work closely with enablement teams on how to continuously improve speed and quality of solutions.
Explore and adopt to new technologies which would solve the problem.