Technical Lead, Data Warehouse and Java

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%).