BI Engineer II - DataTech, Ops Technology Solutions

- 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 writing complex SQL queries
- 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
- 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
- Knowledge or AI/ML and Data Science applications

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/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.
Operations Technology Solutions (OTS), DataTech team is looking for a Business Intelligence Engineer to join our team supporting Amazons Operations and technical stakeholders. The BI Engineer is expected to drive the analytical solutions which include but not limited to, QuickSight Development, Dataset desining, business process and solution automation. They will also part take in designing some of our key business solutions, come up with insights on key metrics, engage with stakeholders to earn trust and merge data intelligence efforts centrally.

The right candidate will be working with large datasets, data visualization, automation and will enable bringing data forward to answer complex business questions that deepen our knowledge of our business drivers.
This role requires someone with strong team communication skills, data modeling skills, and the ability to work across teams including Data Science, Software Dev, Product Management, Demand Planning, Supply Planning, Marketing and Finance to drive business outcomes.


Key job responsibilities
- Design, development and ongoing operations of scalable, performant data warehouse (Redshift) tables, data pipelines, reports and dashboards.
- Development of moderately to highly complex data processing jobs using appropriate technologies (e.g. SQL, Python, Spark, AWS Lambda, etc.)
- Development of dashboards and reports.
- Collaborating with stakeholders to understand business domains, requirements, and expectations. Additionally, working with owners of data source systems to gain insights into capabilities and limitations.
- Deliver minimally to moderately complex data analysis;
- Manage the timeline and deliverables of projects, anticipate risks and resolve issues.
- Adopt best practices in reporting: data integrity, test design, validation, and documentation.
- Have proven track record of launching new solutions and managing projects end to end.
- Strong verbal and written communication skills.

A day in the life
- Interface with technical and non-technical customers delivering complete BI solutions.
- Build a data structure and reporting process by working through various business parameters, which establish truth in data.
- Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions.
- Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
- Build knowledge of latest technologies, tools, methodologies, and best practices and distill that information across the analytics organization.
- Gather insights from customers and operations teams, make recommendations, and help leaders across OTS organization make key business decisions.
- Design and conduct experiments on the effectiveness and efficiency of different initiatives to improve key output metrics and help shape the long-term strategy.

Amazon offers a full range of benefits that support you and eligible family members, including domestic partners and their children. Benefits can vary by location, the number of regularly scheduled hours you work, length of employment, and job status such as seasonal or temporary employment.

The benefits that generally apply to regular, full-time employees include:
- Medical, Dental, and Vision Coverage
- Maternity and Parental Leave Options
- Paid Time Off (PTO)
- 401(k) Plan  

If you are not sure that every qualification on the list above describes you exactly, we'd still love to hear from you!

At Amazon, we value people with unique backgrounds, experiences, and skillsets. If you’re passionate about this role and want to make an impact on a global scale, please apply!