Technical Lead, Data Warehouse and Java

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

Description

• Designing, developing, and maintaining large-scale data warehouse solutions in AWS, primarily using Amazon Redshift (20%)
• Collaborating with business stakeholders and data engineers to gather requirements and deliver data models and architectures that meet the needs of the business (10%)
• Implementing ETL (Extract, Transform, Load) pipelines using ASW services such as AWS Glue, AWS Lambda, and AWS Step Function (10%)
• Optimizing and fine-tuning the performance of the data warehouse and ETL processes (10%)
• Ensuring high availability, scalability, and security of data warehouse solutions (5%)
• Integrating data from various sources (databases, S3 files, Salesforces, etc.) into a unified data warehouse (5%)
• Monitoring and troubleshooting issues related to data warehouse performance and data integrity (5%)
• Creating and maintaining automated workflows and processes for data ingestion, transformation, and reporting (10%)
• Collaborating with data scientists, analysts, and other stakeholders to ensure that data is accessible and available for analysis (10%)
• Developing data models, data dictionaries, and documentation for users and team members (10%)
• Ensuring compliance with best practices in data governance, security, and privacy within AWS (5%)

Requirements

• Must have a Bachelor’s degree in Computer Science or related field plus five (5) years of relevant experience.
• Experience must include five (5) years of experience with solutioning, designing, developing, and maintaining large-scale Java applications and systems in AWS;
• five (5) years of experience with implementing ETL (Extract, Transform, Load) pipelines using AWS services such as any one or a combination of AWS EC2, AWS S3, AWS Glue, AWS Lambda, or AWS Step Function;
• five (5) years of experience with any one or a combination of AWS Lambda, AWS RDS, AWS S3, AWS Step Functions, Java, Spring;
• Two (2) years of experience with designing, developing, and maintaining large-scale Data Warehouse solutions in AWS;
• Two (2) years of experience with AWS Glue, Python, Qlik and Power BI;
• five (5) years of experience with designing, developing, and modifying software systems, using scientific analysis and mathematical models to predict and measure outcomes and consequences of design.

This is a hybrid role and may work from home within commuting distance of the office up to 2 days a week and must work in the office a minmum of 3 days a week. 5 days/40hrs/wk