Data Architect- Snowflake

As a Snowflake Data Architect at 3Pillar, you will play a key role in supporting clients to optimize their data management and derive valuable insights from it. Your responsibilities will include: - Leading the architecture and design of scalable, secure, and high-performing data solutions using Snowflake. - Designing and implementing robust data models for reporting and analytics purposes. - Developing and managing ETL/ELT pipelines utilizing various tools such as Informatica, dbt, Talend, Matillion, or custom scripts. - Optimizing Snowflake performance through clustering, caching, resource monitors, and query tuning. - Integrating Snowflake with diverse data sources including cloud storage, APIs, RDBMS, and real-time systems. - Implementing security best practices like data masking, access controls, and role-based access. - Collaborating with stakeholders to understand requirements and provide technical guidance. - Defining and enforcing data governance, data quality, and metadata management policies. - Staying updated on emerging Snowflake features and industry trends to enhance architecture and processes. - Coordinating with data scientists, analysts, and other stakeholders for data-related needs. - Mentoring junior team members, leading initiatives, and contributing to the growth of the Data Science & Analytics Practice. Qualifications: - Translating business requirements into data requests, reports, and dashboards. - Strong database and modeling concepts with exposure to SQL and NoSQL databases. - Expertise in data architecture patterns, principles, and designing secure and scalable data solutions. - Strong experience with Snowflake and its components. - Knowledge of Master Data Management and related tools. - Exposure to data security and privacy regulations and best practices. - Ensuring data accuracy, consistency, and quality. - Proficiency in AWS services such as S3, Redshift, Lambda, DynamoDB, EMR, Glue, Lake formation, Athena, Quicksight, RDS, Kinesis, Managed Kafka, API Gateway, CloudWatch. - Ability to implement data validation processes and establish data quality standards. - Experience in Linux and scripting. - Proficiency in data visualization tools like Tableau, Power BI, or similar for creating meaningful insights. Additional Experience Desired: - Experience with data ingestion tools like Fivetran, Stitch, or Matillion. - Familiarity with AWS IoT solutions. - Knowledge of Apache NiFi, Talend, Informatica. - Exposure to GCP Data services. - Familiarity with AI/ML technologies.,