Technical Lead, Data Warehouse and Java

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, Sales forces, 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%)

• 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