Data Engineer II (AWS Analytics Engineering)

Quick Facts

• Role: Data Engineer II focusing on AWS Analytics Engineering
• Scope: Own major portions of data architecture, logical data models, and analytics data pipelines

Description

Own and evolve portions of the data architecture for large-scale AWS analytics. Design data contracts, build ingestion flows, optimize transformations, and deliver stable, performant analytical models with strong data quality. Work with AWS engineers and stakeholders to improve self-service dataset access and operational excellence.

Responsibilities

• Identify and resolve data quality issues; improve pipeline best practices and ingestion/transformation patterns
• Build and optimize logical data models and data pipelines for difficult datasets with security, scalability, and cost considerations
• Make dataset-level technical trade-offs to balance short- and long-term approaches
• Produce pragmatic, secure, maintainable, and readable code; minimize incidental complexity
• Contribute to infrastructure decisions: manage resources, storage, and query optimization for stable performance
• Solve difficult multi-source integration problems and proactively resolve inconsistency or gaps
• Break work into tasks, deliver independently, collaborate on dependencies, and build consensus
• Mentor peers, participate in hiring, and share team knowledge
• Drive best practices: code quality, data certification, dependency management, operational excellence, SLAs, and automation
• Participate in code reviews/design discussions/operational reviews
• Take ownership of operational health via on-call support, monitoring, alerting, runbooks, and incident response

Requirements

• 5+ years of data engineering experience
• 3+ years developing and operating large-scale BI data structures using ETL/ELT processes
• 3+ years developing and operating large-scale BI data structures using SQL
• 5+ years analyzing and interpreting data with Redshift, Oracle, or NoSQL
• 3+ years developing and operating large-scale BI data structures using OLAP technologies
• Experience communicating with users, other technical teams, and management to collect requirements and describe designs

Preferred Qualifications

• Experience with AWS technologies: Redshift, S3, AWS Glue, EMR, Kinesis, Firehose, Lambda, IAM roles/permissions
• Experience with non-relational data stores: object storage, document or key-value stores, graph databases, column-family databases
• Experience with big data: Hadoop, Hive, Spark, EMR
• Experience with Data and AI technologies (AI/ML, GenAI, analytics, databases, storage)
• 4+ years of data warehouse technical architectures, data modeling, infrastructure components, ETL/ELT, and reporting/analytic tools with hands-on SQL
• Experience operating highly available distributed data extraction/ingestion/processing systems; familiarity with software development lifecycle

Benefits

• Sign-on payments and restricted stock units (RSUs)
• Health insurance (medical, dental, vision, prescription) plus Basic Life and AD&D; supplemental life options; EAP; mental health support; medical advice line
• Flexible Spending Accounts; adoption and surrogacy reimbursement coverage
• 401(k) matching
• Paid time off and parental leave