Business Intelligence Engineer II, Talent Acquisition Analytics

Amazon; Vancouver; On-site; CAD 76,000 - 128,000; Full time

Job summary

Amazon Development Centre Canada ULC in Vancouver seeks a Business Intelligence Engineer to own data analytics projects from start to finish, building reports and dashboards for Talent Acquisition leadership. You will transform data into actionable insights, automate processes, and collaborate with cross-functional teams across Amazon to influence strategy and hiring decisions.

The role emphasizes data integrity, scalable reporting solutions, and partnering with HRIS teams to shape the roadmap

Qualifications

• 3+ years analyzing data with Redshift, Oracle, NoSQL.
• Bachelor's degree or higher in a related field, or 2+ years Amazon RME FTEx experience.
• Experience with data visualization using Tableau, Quicksight, or similar tools.
• Experience with data modeling, warehousing and building ETL pipelines.
• Experience using SQL to pull data from a database or data warehouse.
• Advanced Microsoft Excel (pivot tables, macros, index/match, vlookup, VBA).

Responsibilities

• Collaborate with recruiting operations, data scientists, and leaders to define processes and provide analytics.
• Write code to analyze complex datasets and design data transformations.
• Build scalable automated data processes for reporting.
• Automate TA processes to streamline operations.
• Communicate insights to business customers and leadership.
• Create dashboards and reports for recruiting leaders and stakeholders.
• Perform complex data analysis across systems for scheduled and ad-hoc reporting.
• Identify root causes by mining KPIs and analyze trends with visualization and stats.

Skills

SQL

ETL

Data Visualization

Redshift

Oracle

NoSQL

Excel

Python

Education

Bachelor's degree or above in a related field

Tools

Tableau

Quicksight

Python

Job description

Description

As a Business Intelligence Engineer, this is your opportunity to be at the intersection of data, analysis, hiring, and strategy that will make it possible for our teams to fulfill that customer promise every day. In this role, you will own data analytics projects from beginning to end, and will build reports, compile metrics, and own ad hoc and trend analysis. You will utilize business intelligence tools to analyze data and drive key recommendations. You will work with Talent Acquisition leadership to achieve business objectives and communicate insights to key stakeholders. You will recognize and adopt best practices in reporting and analysis, including data integrity, analysis, validation, and documentation; and drive results in a fast-paced, ambiguous environment. You will provide analytical support for various Talent Acquisition programs, and build tools to surface timely, meaningful, and actionable data that will drive proactive decision making. Your analysis will contribute deeply to the development of our strategy and drive impact against our hiring objectives. You will collaborate with subject matter experts across Amazon to work through complex problems and to create unified scalable reporting solutions at an enterprise-wide level. You will have the opportunity to partner with the central HR Information Systems teams as an influencer on their next generation road map.

About The Team

Amazon delights millions of customers around the world, and the Talent Acquisition team enables our business leaders to make informed and effective hiring decisions.

Key job responsibilities

• Collaborate with recruiting operations, data scientists, and business leaders to define business processes and provide analytical support
• Leverage code to analyze complex datasets and design, develop and evaluate data transformations to solve specific business problems
• Build scalable, efficient, and automated data processes to facilitate customer-facing reporting
• Automate TA processes to streamline business operations
• Communicate verbally or in writing to business customers / leadership for sharing insights and recommendations
• Build dashboards and reports for both recruiting leaders and the businesses they support
• Perform complex data analysis across multiple systems to support both scheduled and ad-hoc reporting requests
• Mine key performance indicators to discover root causes
• Analyze business outcome data in order to identify relationships and trends; incorporate data visualization and statistical analyses

Basic Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Bachelor's degree or above in business administration, finance, economics, computer science, data science, engineering, or other related field, or 2+ years of Amazon RME (BB/3P) Full Time Exempt experience
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience using SQL (Structured Query Language) to pull data from a database or data warehouse
• Knowledge of Microsoft Excel at an advanced level, including: pivot tables, macros, index/match, vlookup, VBA, data links, etc.

Preferred Qualifications

• Master's degree or above in BI, finance, engineering, statistics, computer science, mathematics or equivalent quantitative field
• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
• Experience using Python scripting to process data for modeling

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.

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, Vancouver - 76,400.00 - 127,600.00 CAD annually

Company

- Amazon Development Centre Canada ULC

Job ID: A10424171