BI Engineer, OpsTech Solutions
DESCRIPTION
OpsTech Solutions organization, with an unparalleled scope, is part of the Amazon’s WW Operations & Robotics team. We design, deploy and support IT infrastructure, devices and Services across Amazon’s Global Fulfillment Centers, Transportation (Middle Mile, Last Mile & Logistics), and Specialty Customer Solutions (Amazon Fresh, Prime Now, Lockers, Pantry, Campus, and Prime Air). Our customers range from Amazon lockers to Amazon’s Air Hubs.
Ops Tech Infrastructure Engineering Product Management (OTIP) is looking for a Business Intelligence Engineer to join our team. The BI Engineer is expected to drive the analytics front of our key business projects, 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 excellent team leadership and 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.
- Partner 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 knowledge of AI (Artificial Intelligence) /ML (Machine Learning) and other industry solutions in this space to know when to apply what to solve business problems.
- Have proven track record of launching new products, solutions and managing projects end to -end.
- Excellence verbal and written communication skills.
- Comfortable wearing multiple hats and go over and above to drive results.
A day in the life
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!
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 developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Experience with data modeling, warehousing and building ETL pipelines
- Experience in Statistical Analysis packages such as R, SAS and Matlab
PREFERRED QUALIFICATIONS
- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
- Excellent communication (verbal and written) and interpersonal skills to translate ambiguous business requirements into complex analyses and actionable insights
- Strong analytic strategy skills; for this role creating analysis ideas is just as important as the ability to do the analysis
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.