DESCRIPTION
As an Amazon Business Intelligence Engineer you will be working in one of the world’s largest and most complex data warehouse environments. You should have deep expertise in the design, creation, management, and business use of extremely large datasets. You should have excellent business and communication skills to be able to work with business owners to develop and define key business questions, and to build data sets that answer those questions. You should be expert at designing, implementing, and operating stable, scalable, low cost solutions to flow data from production systems into the data warehouse and into end-user facing applications. You should be able to work with business customers in understanding the business requirements and implementing reporting solutions.
The person will need to effectively communicate across hierarchy and be self-motivated to raise the bar on deriving insights from analytics and identify opportunities to delight the customers. Above all you should be passionate about bringing large datasets together to answer business questions and drive change.
This person will own the production and delivery of suite of analytics reports and dashboards used by the organization to make key business decisions. This will involve:
1) Delivery of standardized performance metrics for global customers (Vendors) and stakeholders (AWS Finance and business services team) providing operational bandwidth to AWS finance teams to focus on business partnering initiatives.
2) Partner with existing BI leader in executing defined roadmap of projects.
3) Provide ad-hoc support to AWS finance and business services for SQL report creation, modification and optimization.
4) Debug report issues, unblock workflows and communicate with other teams and stakeholders by providing regular status updates.
Tools used include:
1. SQL (Oracle and Redshift)
2. ETL tools (internal)
3. Excel
4. Tableau
5. Report scheduling tools (internal)
BASIC QUALIFICATIONS
– 4+ years of experience as an analyst or engineer in the data/BI space
– Experience with data visualization using Tableau, Quick sight, or similar tools
– Experience with SQL – Retrieve and analyze data using SQL, Excel, and other data management systems
PREFERRED QUALIFICATIONS
– Bachelor’s degree in Computer Science, Computer Information Systems, or related fields
– 4 to 5 years of relevant work experience
– Expert knowledge of SQL with 2 to 3 years of experience writing SQL queries
– Expert knowledge of Microsoft Excel
– Ability to work in a fast-paced and rapidly-changing environment with experience managing multiple competing priorities and projects
– Excellent written, verbal, listening and communication skills
– Experience with reporting tools like Tableau or other BI packages
– Team player
– FP&A expertise to develop forecasting models, and report variance against goals will be an added advantage


Source link