Amazon Business Intelligence Engineer II AWS 

United States, Kansas 

524735396

As a Business Intelligence / Data Engineer you will enable data-driven decision making within the Amazon Web Services ADC Infrastructure Operations organization.The ADC Infrastructure Operations Team is responsible for planning, implementing, monitoring and continuously improving the global Amazon Data Center infrastructure. The team supports all aspects of the Data Center based organizations, including but not limited to : Safety, Security, maintenance, daily operations, logistics, engineering and equipment management. This role will be instrumental for upcoming logistics work. A background in inventory, supply chain or logistics is advantageous, but not required.You will be developing, implementing and maintaining the information data warehouse, and utilizing insight platforms, to enable decision support systems for the overall organization.
You should have excellent business and communication skills, and be able to work with business owners to understand their data and reporting requirements.Above all, you should be passionate about working with huge data sets and be someone who is able to bring data sets together to answer business questions and drive growth. You will build ETLs to ingest the data into the data warehouse and datalake, as well as end-user facing reporting applications. You will primarily support teams within the Infrastructure environment, but will also have opportunities to support teams in the overall Amazon Web Services community. You will work with business customers and development teams to define analytics requirements and then deliver flexible, scalable, end-to-end solutions. You will have an opportunity to work with big data and emerging technologies while driving business intelligence solutions end-to-end: business requirements, data modeling, ETL, metadata, reporting, and dashboarding. You should have expertise in the design, creation, management, and business use of large datasets.
This position requires that the candidate selected must currently possess and maintain an active TS/SCI security clearance. The position further requires that, after start, the selected candidate obtain and maintain an active TS/SCI security clearance with polygraph or commensurate clearance for each government agency for which they perform AWS work.Key job responsibilities
- Moderate to Advanced SQL skills. Skill with aggregate functions, joins between three or more data sources, window functions, and query optimization.
- Experience in building presentation layers for reporting dashboards in SQL.
- Ability to design and build tables for staging and presentation, outside of the visualization software, in AWS Redshift or other similar Data Warehouse (DW) platform.
- Knowledge and understanding of data modeling and data design, e.g. fact and dimension tables, snowflake and star schema, etc.
- Experience in building automation to extract data from a Data Lake/Data Warehouse into visualizations.
You’ll join a diverse team of software, hardware, and network engineers, supply chain specialists, security experts, operations managers, and other vital roles. You’ll collaborate with people across AWS to help us deliver the highest standards for safety and security while providing seemingly infinite capacity at the lowest possible cost for our customers. And you’ll experience an inclusive culture that welcomes bold ideas and empowers you to own them to completion.Amazon values diverse experiences. Even if you do not meet all of the preferred qualifications and skills listed in the job description, we encourage candidates to apply. If your career is just starting, hasn’t followed a traditional path, or includes alternative experiences, don’t let it stop you from applying.We’re continuously raising our performance bar as we strive to become Earth’s Best Employer. That’s why you’ll find endless knowledge-sharing, mentorship and other career-advancing resources here to help you develop into a better-rounded professional.

- 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
- Current, active US Government Security Clearance of TS/SCI or above