Amazon Business Big Data team is looking for a Data Engineer to help manage our ever growing information needs and support analysis of increasingly complex business questions. This individual would build and maintain database solutions that are used for daily reporting and drive business decision making while dealing efficiently with the massive scale of data available through our Data Warehouse as well as our software systems. You will be responsible for designing and implementing solutions using third-party and in-house reporting tools, modeling metadata, building reports and dashboards, and administering the platform software. You are expected to build efficient, flexible, extensible, and scalable ETL design and mappings.
You must be a self-starter and be able to learn on the go. Excellent written and verbal communication skills are required as you will work very closely with diverse teams.
Bachelors Degree in an engineering or technical field
10+ years experience with and detailed knowledge of data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools.
Experience in relational database concepts with a solid knowledge of SQL.
Strong knowledge of various data warehousing methodologies and data modeling concepts. Hands on modeling experience is highly desired
Experience in one of the modern reporting tools such as Tableau, QuickSight, etc.
Experience performing capacity planning at both table level as well as database level to ensure smooth data growth
Experience performing various performance tuning activities at the both database level as well as ETL
Experience partnering with business owners directly to understand their requirements and provide data which can help them observe patterns and spot anomalies.
Understanding of agile software development cycle
Good working knowledge of Redshift environment
Ability to work independently with minimum supervision
Knowledge of Tableau preferred
Knowledge of Columnar databases preferred
Familiarity with AWS technologies preferred
Experience with Big Data technologies such as Hadoop/Hive preferred