AWS Infrastructure Services owns the design planning delivery and operation of all AWS global infrastructure. In other words were the people who keep the cloud running. We support all AWS data centers and all of the servers storage networking power and cooling equipment that ensure our customers have continual access to the innovation they rely on. We work on the most challenging problems with thousands of variables impacting the supply chain and were looking for talented people who want to help.
Youll join a diverse team of software hardware and network engineers supply chain specialists security experts operations managers and other vital roles. Youll 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 youll experience an inclusive culture that welcomes bold ideas and empowers you to own them to completion.
As a Business Intelligence / Data Engineer you will enable datadriven decision making within the Amazon Web Services Data Center Infrastructure Operations organization.
The 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.
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 data lake as well as enduser 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 endtoend solutions. You will have an opportunity to work with big data and emerging technologies while driving business intelligence solutions endtoend: business requirements data modeling ETL metadata reporting and dashboarding. You should have expertise in the design creation management and business use of large datasets.
Key job responsibilities
Passion for storytelling through the visualization of data. We are looking for someone who obsesses about the user experience and who excels in driving business outcomes through the dashboards they develop.
Experience with Tableau or similar visualization/dashboarding platforms like PowerBI QlikView Google Charts Amazon QuickSight etc.
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.
Optimizing large volumes of data through organization of building views and tables with business metrics and KPIs and creating scheduled recurring jobs to load data into the visualization environment.
Excellent communication skills verbal and written.
Experience leading projects interacting with customers and stakeholders to deliver successful dashboard products.
About the team
Amazon Web Services (AWS) is the worlds most comprehensive and broadly adopted cloud platform. We pioneered cloud computing and never stopped innovating thats why customers from the most successful startups to Global 500 companies trust our robust suite of products and services to power their businesses.
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 hasnt followed a traditional path or includes alternative experiences dont let it stop you from applying.
We value worklife harmony. Achieving success at work should never come at the expense of sacrifices at home which is why we strive for flexibility as part of our working culture. When we feel supported in the workplace and at home theres nothing we cant achieve in the cloud.
Here at AWS its in our nature to learn and be curious. Our employeeled affinity groups foster a culture of inclusion that empower us to be proud of our differences. Ongoing events and learning experiences including our Conversations on Race and Ethnicity (CORE) and AmazeCon (gender diversity) conferences inspire us to never stop embracing our uniqueness.
Were continuously raising our performance bar as we strive to become Earths Best Employer. Thats why youll find endless knowledgesharing mentorship and other careeradvancing resources here to help you develop into a betterrounded professional.
4 years of analyzing and interpreting data with Redshift Oracle NoSQL etc. experience
Knowledge of SQL and data warehousing concepts
Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
Experience with data visualization using Tableau Quicksight or similar tools
Experience with Airflow DAGs for ETL
Experience in data mining ETL etc. and using databases in a business environment with largescale complex datasets
Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
Experience with forecasting and statistical 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
for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.
Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89600/year in our lowest geographic market up to $185000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on jobrelated knowledge skills and experience. Amazon is a total compensation company. Dependent on the position offered equity signon 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 This position will remain posted until filled. Applicants should apply via our internal or external career site.