Data Engineer II, DBS BI

Amazon • Bellevue, WA

6h • $132,100 - $178,800 • Onsite

About The Position

AWS Databases, Analytics and AI/ML Products and Services is a large and fast-growing business unit within AWS. The team is working to rebuild and revolutionize data engineering and business intelligence systems within the database, analytics, and AI/ML organization to support fast-growing business needs. This role is for an experienced, self-driven Data Engineer who will build complex data engineering and business intelligence applications using the AWS big data stack. The ideal candidate will have deep expertise and passion for working with large data sets, data visualization, building complex data processes, performance tuning, bringing data from disparate data stores, and programmatically identifying patterns. Excellent business acumen and communication skills are required to collaborate with business owners to define key business questions and requirements. The role also involves providing guidance and support for other engineers with industry best practices and direction, contributing to Amazon Web Services' data-driven decision-making culture that demands timely, accurate, and actionable business insights.

Requirements

• 5+ years of data engineering experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using OLAP technologies experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using data modeling experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using SQL experience
• Experience with data modeling, warehousing and building ETL pipelines

Nice To Haves

• Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
• Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)

Responsibilities

• Design, implement, and support data warehouse / data lake infrastructure using AWS big data stack, Python, Redshift, QuickSight, Glue/lake formation, EMR/Spark/Scala, Athena etc.
• Develop and manage ETLs to source data from various commercial, sales and operational systems and create unified data model for analytics and reporting.
• Use business intelligence and visualization software (e.g., QuickSight.) to develop dashboards those are used by senior leadership.
• Empower technical and non-technical, internal customers to drive their own analytics and reporting (self-serve reporting) and support ad-hoc reporting when needed.
• Develop deep understanding of vast data sources and know exactly how, when, and which data to use to solve particular business problems.
• Work with Product Managers, Finance, Service Engineering Teams and Sales Teams on day-to-day basis to support their new analytics requirements.
• Manage numerous requests concurrently and strategically, prioritizing when necessary
• Partner/collaborate across teams/roles to deliver results.
• Mentor other engineers, influence positively team culture, and help grow the team.

Benefits

• sign-on payments
• restricted stock units (RSUs)
• comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage)
• 401(k) matching
• paid time off
• parental leave

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed