Senior Data Warehouse Lead - Java & AWS ETL

Franklin Madison Group LLC; Brentwood (MD); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Franklin Madison Group LLC is seeking a senior data engineer to design, develop, and maintain large-scale AWS data warehouse solutions, with emphasis on Redshift and data modeling.

You will collaborate with business stakeholders and data engineers to deliver robust data models, implement ETL pipelines using AWS services, and optimize performance while ensuring security and governance. This hybrid role is based in Maryland and requires 5+ years of related experience.

Qualifications

• Bachelor's degree in CS or related field with 5+ years of related experience.
• 5+ years designing and maintaining large-scale Java apps in AWS.
• 5+ years implementing ETL pipelines with AWS services (EC2/S3/Glue/Lambda/Step Functions).
• 5+ years with AWS Lambda, RDS, S3, Step Functions, Java, Spring.
• 2+ years designing and maintaining large-scale Data Warehouse solutions in AWS.
• 2+ years with AWS Glue, Python, Qlik and Power BI.
• 5 years designing and modifying software systems using scientific/mathematical models.

Responsibilities

• Design, develop, and maintain large-scale AWS data warehouse solutions.
• Collaborate with stakeholders and data engineers to gather requirements and deliver data models.
• Implement ETL pipelines using AWS services (Glue, Lambda, Step Functions).
• Optimize performance of data warehouse and ETL processes.
• Ensure high availability, scalability, and security of data solutions.
• Integrate data from multiple sources into a unified warehouse.
• Monitor and troubleshoot data warehouse performance and data integrity.
• Create automated workflows for data ingestion, transformation, and reporting.
• Collaborate with data scientists and analysts to ensure data accessibility.
• Develop data models, data dictionaries, and documentation.
• Ensure compliance with data governance, security, and privacy in AWS.

Skills

Java

AWS

Data Warehouse

ETL

Python

Power BI

Qlik

AWS Glue

Education

Bachelor's degree in Computer Science or related field

Tools

AWS Lambda

AWS S3

AWS Glue

AWS EC2

AWS Step Functions

Power BI

Qlik

Job description

Franklin Madison Group LLC is seeking a senior data engineer to design, develop, and maintain large-scale AWS data warehouse solutions, with emphasis on Redshift and data modeling.

You will collaborate with business stakeholders and data engineers to deliver robust data models, implement ETL pipelines using AWS services, and optimize performance while ensuring security and governance. This hybrid role is based in Maryland and requires 5+ years of related experience.