Business Intelligence Engineer II, Global Specialty Recruiting - Amazon

Description Are you an organized, analytical, and process minded innovator who enjoys working with customers to solve problems with data? If so, Global Specialty Recruiting (GSR) is for you! The GSR Data Analytics Team within GSR is seeking a highly skilled and motivated Business Intelligence Engineer (BIE) to join our team. This is an opportunity to work on a team that develops data solutions to empower GSR recruiting teams to discover, engage, and cultivate top-tier Specialty/Tech/Executive talent at Amazon. The ideal candidate relishes working with large volumes of data, enjoys the challenge of highly complex technical contexts, and, above all else, is passionate about data and analytics. They are an expert with data modeling, ETL design and business intelligence tools and passionately partner with the business to identify strategic opportunities where improvements in data infrastructure creates out-sized business impact. They are a self-starter, comfortable with ambiguity, able to think big (while paying careful attention to detail), and enjoy working in a fast-paced and global team. It's a big ask, and we're excited to talk to those up to the challenge! Key job responsibilities - Gather business requirements from stakeholders and translate them into data and analytic requirements for software development engineers and data engineers. - Write Extract-Transform-Load (ETL) jobs to calculate business metrics. - Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions. - Monitor and troubleshoot operational or data issues in the data pipelines. - Review and audit existing ETL jobs and SQL queries. - Create, design and develop data models for scalable data marts. - Identify and recommend opportunities to automate systems and tools. - Learn and understand a growing range of Amazon data resources and discover how, and when to use which data sets. - Use machine learning, data mining, statistical techniques and run A/B experiments to solve complex business problems. A day in the life - Work closely with HR and Recruiting teams across the globe, building on your strong analytical skills to support multiple teams with regular production of metrics and analytics that are meaningful and scalable. - Use your skills in ETL, automation, and data visualization to provide actionable insights for our teams. - You will provide leadership to ensure that our metrics and analytics are produced and are aligned to the strategic goals of the organization. - Develop and maintain recruiting and workforce metrics & scorecards for leaders in supported businesses - Conduct and present statistical analysis, such as regressions, chi-square testing, and confidence intervals. - Establish scalable, efficient, automated processes for large scale data analyses, model development, model validation and model implementation. - Provide ad-hoc or special project data analysis to recruiting and business leaders that enable them to achieve their goals, drive decision making and create new strategies where necessary. Basic Qualifications - 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience - Experience with data visualization using Tableau, Quicksight, or similar tools - Experience with data modeling, warehousing and building ETL pipelines - Experience in Statistical Analysis packages such as R, SAS and Matlab - Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling Preferred Qualifications - 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 Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us. Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.