Hybrid Data Warehouse Tech Lead - Java & AWS

Franklin Madison; Brentwood (TN); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Franklin Madison in Brentwood, TN, is seeking a Data Warehouse Engineer to design, implement, and optimize AWS-based data warehouse solutions, primarily using Redshift, S3, Glue, and Lambda. You will partner with stakeholders and data engineers to deliver scalable models, governance, and secure data access.

The role requires 5+ years in Java/AWS, ETL pipelines, and data warehousing, plus a Bachelor’s in CS. This is a hybrid role with 3 days in the office and 2 remote, 40 hours per week.

Qualifications

• Bachelor’s degree in CS or related field with 5 years of relevant experience.

Responsibilities

• Design, develop, and maintain large-scale data warehouse solutions in AWS (Redshift) and integrate diverse data sources.
• Implement ETL pipelines using AWS services (Glue, Lambda, Step Functions).
• Collaborate with stakeholders and data engineers to model data for business needs.
• Optimize performance and ensure high availability, scalability, and security of data warehouses.
• Create data models, data dictionaries, and documentation for users and team members.
• Ensure regulatory compliance, data governance, and privacy practices.

Skills

Analytical thinking

Collaboration

Problem solving

Education

Bachelor’s degree in Computer Science or related field

Tools

AWS Redshift

AWS Glue

AWS Lambda

AWS Step Functions

AWS S3

Java

Python

Power BI

Qlik

Job description

Franklin Madison in Brentwood, TN, is seeking a Data Warehouse Engineer to design, implement, and optimize AWS-based data warehouse solutions, primarily using Redshift, S3, Glue, and Lambda. You will partner with stakeholders and data engineers to deliver scalable models, governance, and secure data access.

The role requires 5+ years in Java/AWS, ETL pipelines, and data warehousing, plus a Bachelor’s in CS. This is a hybrid role with 3 days in the office and 2 remote, 40 hours per week.