Business Intelligence Engineer, Inventory Accounting Team
Amazon
Full-time
On-site
Seattle, Washington, United States
$89,600 - $185,000 USD yearly
The Inventory Controllership team is looking for a Business Intelligence Engineer who is data-driven and detail oriented, to partner in expanding our financial data and reporting systems to support our global inventory financial reporting. You should have excellent business and communication skills to be able to work with business owners and tech leaders to gather requirements, build data pipelines and reports/dashboards/automations to meet business needs. You stay abreast of emerging technologies, investigating and implementing where appropriate. This person must be strategic and have strong analytical skills, robust interpersonal and influencing skills, strong organizational and project management skills, and is a self-starter. They will need to roll up their sleeves, work both independently and collaboratively across teams, and have a high level of ownership and accountability.
Key job responsibilities
- Learn, publish, analyze and improve management information dashboards, operational business metrics decks and key performance indicators.
- Improve tools and processes, scale existing solutions, and create new solutions as required based on stakeholder needs.
- Design and automate ETL pipelines for business metrics.
- Partner with stakeholders from business, product and operations teams to define priority of BI projects, and reporting / Program Management for BI projects
- Performing deep-dives to derive actionable insights; Creating models to predict outcomes and optimize business processes
- Building self-service reporting tools and dashboards
- Providing SQL support and delivering trainings (SQL, QuickSight, etc.)
- Research the most appropriate methodologies for a given analytical problem.
- Contribute to key business documents.
- Architect and develop scalable data pipelines
- Develop new data models and end to data pipelines.
- Actively participate in design reviews of related tech products.
- Interface with multiple finance and accounting customers, gathering requirements and delivering complete solutions.
- Analyze and solve problems at their root, stepping back to understand the broader context.
A day in the life
Work with the largest dataset in Amazon Inventory in the world to drive financial insights, support operations and build analytical solutions for partners which can help drive cost control and decision making. As a Business Intelligence Engineer, you will be working in one of the world's largest and most complex data warehouse environments. You will design, implement and support scalable reporting solutions to integrate with multi heterogeneous data sources, aggregate and retrieve data in a fast and safe mode, curate data that can be used in reporting, analysis, machine learning models, Gen AI and ad-hoc data requests.
About the team
Inventory Accounting Controllership is one of the most challenging and exciting spaces to work for, with high inventory turnover and being required to seamlessly integrate with the Amazon Fulfillment Tech (AFT) systems for automatic Ingestion inventory activities for proper accounting to keep our books complete and accurate.
- 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 using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Experience working directly with business stakeholders to translate between data and business needs
- Experience in discovering business requirements and creating insightful dashboards tailored for various levels of the organization, including senior leadership.
- The successful candidate will be able to deliver products that exceed customer satisfaction, ensure data accuracy and completeness, automate manual tasks and develop efficient data pipelines.
- 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
- Proven success in communicating with users, other technical teams, and senior management to collect requirements, describe data modeling decisions and data engineering strategy
- Understanding of system performance and scaling
- Knowledge on LLM and Gen Ai.
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.
Key job responsibilities
- Learn, publish, analyze and improve management information dashboards, operational business metrics decks and key performance indicators.
- Improve tools and processes, scale existing solutions, and create new solutions as required based on stakeholder needs.
- Design and automate ETL pipelines for business metrics.
- Partner with stakeholders from business, product and operations teams to define priority of BI projects, and reporting / Program Management for BI projects
- Performing deep-dives to derive actionable insights; Creating models to predict outcomes and optimize business processes
- Building self-service reporting tools and dashboards
- Providing SQL support and delivering trainings (SQL, QuickSight, etc.)
- Research the most appropriate methodologies for a given analytical problem.
- Contribute to key business documents.
- Architect and develop scalable data pipelines
- Develop new data models and end to data pipelines.
- Actively participate in design reviews of related tech products.
- Interface with multiple finance and accounting customers, gathering requirements and delivering complete solutions.
- Analyze and solve problems at their root, stepping back to understand the broader context.
A day in the life
Work with the largest dataset in Amazon Inventory in the world to drive financial insights, support operations and build analytical solutions for partners which can help drive cost control and decision making. As a Business Intelligence Engineer, you will be working in one of the world's largest and most complex data warehouse environments. You will design, implement and support scalable reporting solutions to integrate with multi heterogeneous data sources, aggregate and retrieve data in a fast and safe mode, curate data that can be used in reporting, analysis, machine learning models, Gen AI and ad-hoc data requests.
About the team
Inventory Accounting Controllership is one of the most challenging and exciting spaces to work for, with high inventory turnover and being required to seamlessly integrate with the Amazon Fulfillment Tech (AFT) systems for automatic Ingestion inventory activities for proper accounting to keep our books complete and accurate.
- 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 using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Experience working directly with business stakeholders to translate between data and business needs
- Experience in discovering business requirements and creating insightful dashboards tailored for various levels of the organization, including senior leadership.
- The successful candidate will be able to deliver products that exceed customer satisfaction, ensure data accuracy and completeness, automate manual tasks and develop efficient data pipelines.
- 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
- Proven success in communicating with users, other technical teams, and senior management to collect requirements, describe data modeling decisions and data engineering strategy
- Understanding of system performance and scaling
- Knowledge on LLM and Gen Ai.
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.