ICQA Data Analyst

Amazon; Ottawa; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading fulfillment service company in Ottawa seeks a Data Analyst to support their Inventory Control and Quality Assurance team. The role involves developing data collection processes, maintaining data integrity, and providing analytical support while using tools such as SQL, Excel, and Python. Candidates should have at least 2 years of relevant experience and a Bachelor's degree or equivalent.

Qualifications

• 2+ years of business analyst or data analyst experience.
• Experience using SQL to extract and manipulate data.
• Experience with MS Office, especially Excel.
• Experience writing complex Excel VBA macros.

Responsibilities

• Develop data collection processes and data management systems.
• Maintain data integrity with 0% error rate.
• Design queries and compile data for reporting in Excel.
• Research defect trends and perform data mining.

Skills

Data analysis

SQL

Excel VBA macros

Problem solving

Python

Tableau

Education

Bachelor's degree or equivalent

Tools

MS Excel

VBA

SQL

Python

Tableau

Job description

Description

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 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 project management experience

Preferred Qualifications

• 3+ years of business analyst, data analyst or similar role experience
• Experience communicating across technical and non-technical audiences, including executive level stakeholders or clients
• 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 statistical analytics and programming languages such as R, Python, Ruby, etc.
• 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 for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.