Architecting Data Solutions: Design and architect complex Data Warehousing/Data Lake solutions on Snowflake, utilizing the latest technologies.
Automated Data Processes: Develop scalable, automated processes for data extraction, processing, and analysis within a Data Mesh architecture.
CI/CD Pipelines: Set up CI/CD pipelines for auto-deployment, while maintaining development, UAT, and production environments.
Technical Troubleshooting: Identify and resolve technical issues promptly, ensuring seamless data operations.
Continuous Improvement: Explore ways to enhance data pipelines in terms of both content and delivery methods, contributing to departmental improvement.
Performance Optimization: Optimize and fine-tune complex SQL queries on Snowflake, demonstrating expertise in various data partition strategies.
Collaboration with Data Analysts: Work closely with Data Analysts to optimize and ensure the availability of data feeds, incorporating Change Capture, Change Data Control, and other delta loading approaches.
Data Solution Design: Take responsibility for designing solutions related to data integration, data management, metadata management, and data quality.
Data Transformation and Documentation: Discover, transform, test, deploy, and document data sources effectively.
Essential Skills
You bring 4-6 years of experience, showcasing increasing responsibilities in implementing data solutions with a focus on Snowflake or a similar data warehouse.
4+ years of experience in Python.
You have a deep understanding of Data Warehouse, ETL concepts, and data modeling principles, including Star Schema, Snowflake Schema, Dimension Tables, and Fact Tables.
Proficient in Cloud-based data solution components and architecture, covering data ingestion, processing, cataloging, security, dev ops, and consumption.
Experienced in implementing core Snowflake concepts such as data sharing, UDFs, zero copy clones, time travel, micro partition, stored procedures, data import/export, and external tables.
Strong analytical and problem-solving skills, with the ability to proactively engage with cross-functional teams to resolve issues and blockers.
Ability to consider alternative solutions/components and make design decisions, backed by justification.
Excellent communication skills, fostering effective collaboration within the team and across departments.
Good to Have Skills
You possess 2-3 years of hands-on experience in DevOps
Experience working in Fin-tech domain with security best practices.
