ICQA Data Analyst

Job summary

The Data Analyst provides analytical support for ICQA and operations teams to investigate defects and ensure SoX compliance. They are responsible for creating automated dashboards, managing data collection processes, and developing custom reporting tools.

Job details

At Amazon, we're working to be the most customer-centric company on earth. To get there, we need exceptionally talented, bright, and driven people. If you'd like to help us build the place to find and buy anything online, this is your chance to make history. Amazon Canada Fulfillment Services is hiring a Data Analyst to support the Inventory Control / Quality Assurance (ICQA) team. The Data Analyst assigned to ICQA will work closely with the ICQA and operations teams in Inbound and Outbound to provide data and analytical support for ACES initiatives, root cause investigation of defects, and will provide support to ensure compliance to ICQA-related SoX requirements. The Data Analyst will own the insights, set up analysis, and create automated dashboards and reporting. They will be responsible for identifying data sources (internal / external) to invent and simplify mechanisms and create custom reporting and analytics automation tools. Operating in a fast-moving and sometimes ambiguous environment, you will be required to work autonomously, taking full control and responsibility for achieving business objectives. This role provides real opportunity to develop original ideas, approaches and solutions in an ever-changing and competitive business climate. Key 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 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 - Back up for Process Assistant duties Basic Qualifications: - 2+ years of professional or military experience - Work 40 hours/week, and overtime as required - Work a flexible schedule/shift/work area, including weekends, nights, and/or holidays - Are 18 years of age or older - 2+ years of business analyst, data analyst or an equivalent role experience - 1+ years of using SQL to extract and manipulate data experience - Bachelor's degree, or High school or equivalent diploma - 2+ years of professional work experience, or experience in MS Office, with an emphasis on Excel - Experience writing complex Excel VBA macros - Experience in advanced SQL, Python, Tableau - Experience demonstrating problem solving and root cause analysis - Experience with modern software development, web development frameworks, APIs - 1+ years of project management experience Preferred Qualifications: - 3+ years of business analyst, data analyst or similar role experience - Experience in written and verbal communication skills to communicate with technical and non-technical audiences, including senior leadership - Experience dealing well with ambiguity, prioritizing needs, and delivering measurable results in an agile environment - Experience programming with at least one software programming language, or experience with full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations - Knowledge of data warehousing and data modeling - Experience with data scripting languages (e.g., SQL, Python, R, or equivalent) or statistical/mathematical software (e.g., R, SAS, Matlab, or equivalent) - Bachelor's degree in Business, Engineering, Statistics, Computer Science, Mathematics, Supply Chain or related field. Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status. Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations [https://amazon.jobs/content/en/how-we-hire/accommodations] for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner. The base salary range for this position is listed below. As a total compensation company, Amazon's package may include other elements such as sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon offers comprehensive benefits including health insurance (medical, dental, vision, prescription, basic life & AD&D insurance), Registered Retirement Savings Plan (RRSP), Deferred Profit Sharing Plan (DPSP), paid time off, and other resources to improve health and well-being. We thank all applicants for their interest, however only those interviewed will be advised as to hiring status. CAN, BC, Pitt Meadows - 23.00 - 35.00 CAD hourly

What you’ll do

The Data Analyst provides analytical support for ICQA and operations teams to investigate defects and ensure SoX compliance. They are responsible for creating automated dashboards, managing data collection processes, and developing custom reporting tools.

Requirements

Requires 2+ years of experience as a data analyst with proficiency in SQL, Python, and complex Excel VBA macros. A bachelor's degree or high school diploma is required, along with experience in root cause analysis and project management.

Benefits

• Health Insurance • Medical Insurance • Dental Insurance • Vision Insurance • Prescription Insurance • Basic Life Insurance • AD&D Insurance • Registered Retirement Savings Plan (RRSP) • Deferred Profit Sharing Plan (DPSP) • Paid Time Off

Listed skills

• Project management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Python
• Tableau
• Excel VBA
• Data Mining
• Root Cause Analysis
• Project Management
• Data Modeling
• Data Warehousing
• API Development
• Web Development Frameworks
• Data Visualization
• Reporting Automation
• SoX Compliance
• Data Integrity
• Problem Solving

Job areas

• Data & Analytics
• Logistics
• Technology
• Engineering
• Manufacturing