The Data Analyst will work closely with the learning, ICQA and operations teams to provide data and analytical support for FC initiatives, root cause investigation of defects, and will provide to insure compliance to operational-related SOX requirements. Moreover, analyze data to support OE initiatives, dig deep into data to determine root cause of defects, build and maintain decision support tools, and present findings to business partners to drive improvements in FC-wide quality and productivity. The complexity of research and skills for the position is well beyond basic data entry and research. It involves complex analysis and diving deep into key metrics based on requests, building and maintaining multiple databases, extensive knowledge of software applications to create tools, and understanding of multiple programming languages. The following provides some detail of the job duties and responsibilities.Job responsibilities• Development of data collection processes and data management systems• Maintenance of data integrity (0% error rate)• Designing of queries, compiling of data, and generation of reports in MS Access and Excel• Charting and graphing of data for reporting purposes• In depth research of defect trends• Data collection and entry as needed• Data mining and problem solving#amazonmexicoWe are open to hiring candidates to work out of one of the following locations:Tepotzotlan, MEX, MEXBASIC QUALIFICATIONS- Completed High School Diploma or equivalent.- 2+ years of experience working in Analytics or Business Intelligence environment.- Experience creating interactive, user-friendly and compelling dashboards and reports using visualization tools like QuickSight, Tableau, Power BI etc.- Experience in Data Analysis (SQL, PowerBI, detecting tendencies, areas of opportunity, solution proposal, costs).- Experience in MS Excel (Macros, Pivot Tables, Advanced Formulas). - Expertise in SQL, Tableau and Python- Experience writing VBA and using macros in Microsoft Excel- MS Office experience required, including experience with Excel (v-lookups, pivot tables, etc.)- Demonstrated experience pulling and analyzing data to aid in root cause identification and drive process improvement initiatives across the network.- 1 year of experience in modern web development including HTML5, CSS, and Javascript frameworks (Angular JS, React, Backbone.js etc)PREFERRED QUALIFICATIONS- Bachelors Degree - 2+ years as a business or data analyst- Building Excel-based or PDF-based reports via data tables- Proficiency in modern web development including HTML5, CSS, and Javascript frameworks (Angular JS, React, Backbone.js etc)- Ability to work in a fast-paced and agile development environment and to learn new frameworks/stacks- Knowledge of AWS systems, configurations
