Data Architect

## About the role Snowflake , AWS, Python , basic AI knowledge primary and DevOps , MLOps secondary. Snowflake-heavy role (7+ years in data warehouse/ETL). ## Key Responsibilities - Define and own technical architecture and design for the platform / projects - Help team to develop and deliver applications/components in accordance with technical design - Help team with complex issues during development - Provide guidance to the team on complex and emergent design patterns and technologies - Should work on projects needing development of large and scalable applications with good performance and high availability - Work with infrastructure teams to define the architecture stack needs like storage, security, load balancing, disaster recovery & failover - Delivery of highly secure solutions that are optimized for performance and built to scale - Develop, implement and maintain technical standards, procedures and best practices - Communicate with senior stakeholders, teams to articulate technology solutions ## Experience and Qualifications - BE / B-Tech / MCA - 7-12 years of total experience, ## Essential Skills - Good Knowledge in Architectural and Design patterns - Architecting, planning and implementation of e2e data warehouse and business intelligence systems utilizing best practices from data architecture, data integration and management areas - 6+ years - Expert data modelling skills; entity relationship as well as dimensional, designing various layers of data warehouse, etc… - 6+ years - Data analysis, source system analysis and data mapping to target data model - 6 to 10 years - Extensive knowledge in data integration architecture/ETL/Data warehouse, esp large volumes with complex integrations - 8+ years - Strong experience in SQL, Snowflake Scripting, Snaplogic, Unix shell scripting, Python, Snowflake optimization and scheduling tools along with performance improvement techniques across ETL technology stack with hands-on abilities - 8+ years - Experience with AWS cloud technologies with most of the core features - Lambda, API gateway, S3, Athena, RDS, Dynamo DB , SQS, EC2 etc. and good understanding of AWS WAF Frameworks - Understanding of row and column level security, data masking/encryption concepts; role and access privileges - Overseeing and reviewing the application design & development to ensure that it meets both the technical constraints of the architecture and the business objectives in terms of reliability, scalability and serviceability - Ability to identify and define non-functional requirements and design systems to meet the same - Strong DevOps background with understanding of different CI/CD stages till production - Knowledge of application architecture to ensure performance and scalability, including the identification and alleviation of bottlenecks. - Excellent communication (verbal and written) and interpersonal skills suitable for a diverse audience, with the ability to communicate in a positive, friendly and effective manner with 'technical' or 'non-technical' users/ customers - Solid experience with AWS, Azure, and Snowflake, including architecture patterns and cloud-native data solutions. ## Desirable Skills - Experience in preparing Technical Documentation (Pseudo Code, Process Flow , Data Model, Class Diagram ) - Experience in using Transformation tools like DBT, Data Lineage and Data Virtualization tools - Integration with cloud systems like Oracle Fusion, Concur, Anaplan, etc. - Good understanding of streaming concepts using Kinesis or Kafka, etc. - Exposure to Data quality, complex transformation such as B2B, metadata management, etc… - Exposure and sound understanding of financial services domain - Mutual Funds and Fund accounting - Self-starter with ability to take ownership of end – to – end implementations - Exposure to machine learning platforms( e.g., Azure ML, AWS Sagemaker) and understanding of how data architecture supports AI-driven solutions. - Operating in a quickly changing and ambiguous environment and driving technological innovations to meet business requirements - Good knowledge of reporting tools such as Power BI with understanding of different types of reporting, storytelling using visualization, etc…