ü 5+ years of experience as a Data Architect in a company with large, complex data sources.
ü Expertise in AWS , Redshift & RDS database, optimizing, tuning queries, tables and applying business rules/logic.
ü Expertise in translating business requirements into Data model and Datawarehouse layer on AWS Redshift
ü Experience in developing Reporting warehouse layer for consumption based on visualization requirements.
ü Proficient in SQL and ETL activities
ü Experience in technology stack AWS, Redshift, Google Cloud Platform, BigQuery, Web API
ü Experience in working on Google Analytics and Firebase as source systems is preferred
ü Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and AWS big data technologies.
ü Designing and implementing complex ETL pipelines and other BI solutions.
ü Experience in design, develop Python based data engineering solution or pipelines in AWS Cloud Utilizing services like Redshift, S3, EC2, RDS.
ü Experience in writing reusable, testable, and efficient, modular & OOP code in Python
ü Write Unit Test & perform Linting on Python code
ü Experience on Control M scheduler, Bitbucket for CI/CD  is nice have.
ü Work closely with business owners, developers, Business Intelligence Engineer to explore new data sources and deliver the data
ü Ability to perform quick discovery work and POCs with business in data engineering tasks.
ü Must have the ability to work independently
ü Must have experience with Agile/Scrum and knowledge of JIRA, Confluence tools
ü Must have good communication skills