Senior Business Intelligence Engineer, DCC Communities
Amazon.com - Herndon, VA
posted 16 days ago
About the position
As a Business Intelligence Engineer you will enable data-driven 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 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.
Responsibilities
- Passion for storytelling through the visualization of data.
- Experience with Amazon QuickSight or similar visualization/dashboarding platforms like PowerBI, QlikView, Google Charts, Tableau, etc.
- Advanced SQL skills including aggregate functions, joins between three or more data sources, window functions, and query optimization.
- Proficient in building presentation layers for reporting dashboards in SQL.
- Ability to design and build tables for staging and presentation in AWS Redshift or other similar Data Warehouse platform.
- Advanced knowledge and understanding of data modeling and data design.
- Expertise in building automation to extract data from a Data Lake/Data Warehouse into visualizations.
- Excellent communication skills, verbal and written.
- Proficient in leading projects, interacting with customers and stakeholders to deliver successful dashboard products.
Requirements
- 5+ years of professional or military experience.
- Experience programming to extract, transform and clean large (multi-TB) data sets.
- Experience with AWS technologies.
- Experience in scripting for automation (e.g. Python) and advanced SQL skills.
Nice-to-haves
- Experience working directly with business stakeholders to translate between data and business needs.
- Experience managing, analyzing and communicating results to senior leadership.
- Experience with theory and practice of design of experiments and statistical analysis of results.
- Experience with theory and practice of information retrieval, data science, machine learning and data mining.
Benefits
- Full range of medical, financial, and/or other benefits.
- Equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package.
