AWS Data Engineer

As the AWS Data Engineer, you will be instrumental in building, optimizing, and maintaining scalable data pipelines and lakehouse architectures on AWS to enable reliable, high-performance data flows for analytics and reporting. Your primary focus will be designing robust data models, implementing lakehouse solutions using AWS services, and ensuring efficient ingestion, transformation, and storage of data from diverse sources. This is an excellent opportunity to shape a modern data ecosystem using cutting-edge AWS technologies.

This position reports directly to the Manager of Engineering.

• Data Modeling: Design and implement dimensional and normalized data models optimized for analytical workloads in lakehouse environments.
• Lakehouse Architecture: Build and manage modern data lakehouse solutions using AWS services including Amazon S3, AWS Glue, Amazon Redshift Spectrum, and Lake Formation for governance, cataloging, and fine-grained access control.
• ETL/ELT Pipelines: Develop, monitor, and optimize batch and near-real-time data pipelines using AWS Glue, AWS Lambda, Amazon Kinesis, and Step Functions.
• Data Ingestion & Integration: Ingest structured, semi-structured, and unstructured data from APIs, databases, streaming sources, and third-party systems into the lakehouse.
• Infrastructure as Code & Automation: Define and manage data infrastructure using AWS Cloud Formation, CDK, with CI/CD pipelines.
• Support model training and analytics initiatives by preparing datasets, performing analysis with strong attention to detail, and creating visualizations using AWS Quick Suite.
• Perform other duties as assigned.

• Deliver scalable, maintainable data models that support evolving analytical and reporting needs.
• Implement secure, governed lakehouse architecture with centralized metadata, access controls, and auditability via AWS Lake Formation.
• Build high-throughput, fault-tolerant data pipelines with monitoring, alerting, and automated recovery using Amazon Cloud Watch and Event Bridge.
• Optimize query performance and cost using Redshift, Athena, and S3 partitioning/compression strategies.
• Ensure data quality, lineage, and documentation through automated testing and catalog integration.
• Collaborate effectively with analytics engineers, data scientists, and business stakeholders to align data solutions with organizational objectives.

• 3+ Years Experience with AWS data services including S3, AWS Glue, Lake Formation, Amazon Redshift, Athena, and IAM for fine-grained access.
• 4+ Years Experience in data modeling for data warehouses and lake houses.
• 4+ Years Experience building and orchestrating ETL/ELT pipelines using AWS Glue, Lambda, Step Functions.
• Proficiency with SQL and Python.
• Hands-on experience with infrastructure as code (Cloud Formation/CDK/Terraform) and CI/CD for data workloads.
• Strong understanding of data governance, security, and compliance in cloud environments.
• Excellent communication and interpersonal abilities, facilitating effective collaboration across technical and business teams.
• Experience working in a remote environment.
• Proficiency in data visualization tools (Tableau/Power BI) and project management software (Jira, Confluence).

At REE, we believe in empowering our employees to thrive both personally and professionally. When you join our team, you become part of a dynamic and inclusive work environment where innovation and collaboration are celebrated.

• Competitive Salary: $110,000 - $130,000/yr
• Health, dental, and vision insurance with Company-sponsored Life Insurance
• Retirement savings plan with company match
• Vacation time off, sick time off, and holidays

• Ongoing training and development programs
• Opportunities for advancement within the company

• Flexible work schedules
• Remote first environment with company wide conferences annually
• Employee assistance program for personal and family well-being

• Employee discounts on products and services through Insperity
• Recognition programs for outstanding…