The Data eNgineering and Analytics (DNA) Wizardry team is excited to have a new wizard join our coven! The DNA team spans across Data Architecture (DA) Data Engineering (DE) Business Intelligence (BI) and Data Science (DS) functional areas and is responsible for providing data and analytic solutions for the North American Stores (NAS) Organization. This Sr. BIE role will own the data pipelines and final customer interfaces (Turismo QuickSight) for the NAS Organization. This role will build core metrics and deep dive them to generate insights that directly impact organizational strategic decisions and priorities. The role requires high proficiency in complex SQL and Python scripting often joining together multiple types of data sets that range from normalized summaries to raw information spanning many diverse sources. The role will need to have a high bar for ownership and work autonomously to create highquality products for the customer (internal). The role is required to communicate project roadmap prioritization and release notes of new products with customer and stakeholder groups up to senior leadership. In addition this role will influence our team and customers to build scalable and sustainable analytic solutions. They will review product development and provide mentorship on projects.
Key job responsibilities
Develop and drive best practices to align with our theme Accuracy Complete and Timely (ACT) information: data integrity test design analysis validation and documentation
Mine data from database tables (ex. Redshift MySQL Oracle) using SQL and log files by writing scripts (ex. PERL Python UNIX)
Build solutions to have maximum scale and selfservice ability for stakeholders
Own the design and development of metrics analyses dashboards etc. to drive key business decisions
Produce written recommendations and insights for key stakeholders that will help shape effective metric development and reporting
Lead the design implementation and deployment of BI solutions for complex and ambiguous problems
Conduct deep dive analyses of business problems and formulate conclusions and recommendations to be presented to key stakeholders
Simplify and automate reporting audits and other datadriven activities
Partner with our Data Engineering team to enhance data infrastructure data availability and broad access to customer insights
Learn new technology and techniques to meaningfully support product and process innovation
Partner with Engineering teams to enhance data infrastructure data availability and broad access to customer insights
To develop and drive best practices in reporting and analysis: data integrity test design analysis validation and documentation
Learn new technology and techniques to meaningfully support product and process innovation
A day in the life
In this role you will transform complex data into actionable insights. Your datadriven solutions will influence strategic planning and inform daily decisionmaking. You will leverage a range of descriptive diagnostic predictive and prescriptive analytics techniques to uncover insights and opportunities.
About the team
Our mission is to simplify datadriven decision making for customers through effective analytics solutions. We deliver accurate complete and timely information while maintaining rigorous quality standards. The solutions transform complex data into actionable insights eliminating the need for technical expertise. This enables customers to optimize their business performance through direct data analysis.
The team builds robust processes and identifies improvement opportunities while partnering with stakeholders to enhance internal systems. We ensure proper data governance visibility and accessibility for all managed datasets. Our solutions focus on improving business performance (Increase Sales Decrease Time and/or Reduce Cost) for the NAS organization.
7 years of SQL experience
Experience in scripting for automation (e.g. Python) and advanced SQL skills.
Experience with data visualization using Tableau Quicksight or similar tools
Experience working directly with business stakeholders to translate between data and business needs
Experience building measures and metrics and developing reporting solutions
Knowledge of data warehousing and data modeling
Experience with AWS technologies
Experience programming to extract transform and clean large (multiTB) data sets
Experience with operations/supply chain
Experience with theory and practice of information retrieval data science machine learning and data mining
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.
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/howwehire/accommodations for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.
Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $117300/year in our lowest geographic market up to $202800/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on jobrelated knowledge skills and experience. Amazon is a total compensation company. Dependent on the position offered equity signon 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/workplace/employeebenefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.