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%); and 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; and 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