Find your next role

Discover amazing opportunities across our network of companies committed to gender equality in the workplace.

Business Intelligence Engineer, Analytics & Data Management

Amazon

Amazon

Operations, Data Science
Seattle, WA, USA
Posted on Jul 24, 2024

DESCRIPTION

Amazon was recently voted #2 most admired company in the US, #1 most innovative, and #1 in Customer Service. We are investing heavily in building an excellent advertising business, and are responsible for defining, and delivering a collection of self-service performance advertising products that is fully scalable and reliable. Our products are strategically important to our leadership, finance, economists, analysts, and BI partners to drive long-term growth. We mine billions of ad impressions and millions of clicks daily and are breaking fresh ground to create world-class products. We are highly motivated, collaborative, and fun loving with an entrepreneurial spirit and bias for action. With a broad mandate to experiment and innovate, we are growing at an unprecedented rate with a seemingly endless range of new opportunities.

The Advertising Analytics & Data Management team is looking for a BI Engineer who has strong ownership, outstanding business acumen, and excellent analytical abilities to help build analytics and reporting solutions to support various Ad products. In this role, you will partner with stakeholders across product and engineering teams to understand business requirements, conduct analyses, automate reports, provide documentation and data curation, and build out self-serve analytics solutions over PB-scale data lake.

Key job responsibilities
- Own the design, development, and maintenance of scalable solutions for ongoing metrics, reports, analyses, dashboards, etc. to support analytical and business needs.
- Translate business needs into data/technical needs and data insights into business takeaways.
- Translate basic business problem statements into analysis requirements.
- Use analytical and statistical rigor to answer business questions and drive business decisions.
- Find and create ways to measure the customer experience to drive business outcomes.
- Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
- Write queries and output efficiently, and have in-depth knowledge of the data available in area of expertise. Pull the data needed with standard query syntax; periodically identify more advanced methods of query optimization. Convert data to make it analysis-ready.
- Recognize and adopt best practices in reporting and analysis: data integrity, design, analysis, validation, and documentation.
- Troubleshoot operational data-quality issues.
- Review and audit existing ETL jobs and queries.
- Recommending improvements to back-end data sources for increased accuracy and simplicity.

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.