Job Description

DESCRIPTIONAmazon is a US-based multinational electronic commerce company headquartered in Seattle, Washington. Amazon.com started as an online bookstore, but soon diversified into many other categories, with a vision to be earth\'s most customer-centric company & to build a place where people can come to find and discover anything they might want to buy online.About the role: Amazon\'s Finance Operations, Accounting & Analysis (FOAA) team is a fast-paced, team-focused, dynamic environment and delivering great experiences for our customers is top priority. FOAA is seeking a Business Intelligence Engineer to support automation of manual activities and reconciliations.Amazon is seeking an exceptional BI Engineer to join the Innovation and Automation(I&A) team within FOAA organisation. The person in this position will play a key role in supporting the development of tools and reports used by the FOAA analysts.The engineer will own BI support for FOAA by leading the creation of automated solutions to complex business problems. This person will help develop analytical solutions and leverage our optimized and scalable datasets, with opportunities to utilize emerging technologies. The ideal candidate will be passionate about building tools that provide unique insights to leaders of FOAA.The primary responsibilities of this role are to:
\xc2\xb7 Work with our customers to understand their needs and design reporting solutions that will exceed expectations
\xc2\xb7 Develop flexible and scalable solutions using new technologies
\xc2\xb7 Automate existing processes where needed
\xc2\xb7 Debug report issues, unblock workflows and Communicate with other teams and customers to provide status updates
. Work effectively with cross-functional teams and in a fast-paced and ever-changing environment.Tools used include:
1. SQL (Oracle and Redshift)
2. ETL tools (internal)
3. Excel
4. Tableau
5. Report scheduling tools (internal)
6. PythonOther responsibilities:
- Work with our customers to understand their needs and design reporting solutions that will exceed expectations
- Develop flexible and scalable solutions using new technologies
- Automate existing processes where needed
- Debug report issues, unblock workflows and communicate with other teams and customers to provide status updates
- Work effectively with cross-functional teams and in a fast-paced and ever-changing environment.
- Provide operational support for accounting and business to ensure financial events are completely and accurately recorded from source to our financial ledgers.
- Investigate common system failures such as corrupt workflows, missing or wrong configuration, and incorrect postings.
- Responsible for identifying root causes, categorize them into buckets, and provide systematic solution insights.
- Provide user operational support and respond to data and research queries from management team.
- Provide financial operations support for accounting and lines of business in order to complete reconciliation of financial accounts.
- Work with product management, technology management, and accounting to research issues, and implement process improvements.The ideal candidate will be detail oriented and driven to provide insightful and timely information to customers. The candidate should have strong communication skills and ability to prioritize effectively to ensure timelines are met. There is always room to make things better so this candidate should also have the ability to invent and simplify.Key job responsibilities
The engineer will own BI support for FOAA by leading the creation of automated solutions to complex business problems. This person will help develop analytical solutions and leverage our optimized and scalable datasets, with opportunities to utilize emerging technologies. The ideal candidate will be passionate about building tools that provide unique insights to leaders of FOAA.Key job responsibilities:
The primary responsibilities of this role are to:
- Work with our customers to understand their needs and design reporting solutions that will exceed expectations
- Develop flexible and scalable solutions using new technologies
- Automate existing processes where needed
- Debug report issues, unblock workflows and communicate with other teams and customers to provide status updates
- Work effectively with cross-functional teams and in a fast-paced and ever-changing environment.A day in the life
The BIE is responsible for partnering with internal business customers to analyze and manage financial issues relating to business operations. In this role, you will provide guidance and requirements for new product launches and resolve current financial business issues by partnering with accounting, appropriate business units, and source system teams. You will ensure new business launches meet requirements for all relevant financial use cases, including accounting, source system accuracy, and completeness. This role will identify and assist in fixing root causes by providing research, data, support, and recommendations to source system teams and business units. You will also work to develop and automate processes to identify appropriate classifications of financial variances and transition the solution to accounting when the process is in steady state.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 modelingPREFERRED 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