Job Summary (Snowflake Engineer/Architect)
- Lead the architecture, design, and development of scalable data solutions on the Snowflake platform.
- Provide technical leadership and mentorship to junior data engineers.
- Design and oversee efficient ETL/ELT processes using Snowflake and third-party tools.
- Optimize Snowflake performance, including query tuning and data ingestion.
- Establish and enforce data governance, security, and compliance standards.
- Implement automation and orchestration of data pipelines leveraging Azure and Snowflake features.
- Collaborate with data architects, scientists, and business analysts to align infrastructure with business needs.
- Stay current on Snowflake features and best practices; drive innovation in data infrastructure.
- Lead integration and deployment of Snowflake on cloud platforms, especially Azure.
- Maintain comprehensive technical documentation for architectures and processes.
- Utilize advanced Snowflake features (Snowpipe, Streams, Tasks, Materialized Views, etc.).
- Extract and ingest data from APIs.
- Ensure high data quality using best practices.
- Apply expertise in data modeling, data warehousing concepts (star/snowflake schemas), and big data technologies.
- Demonstrate advanced SQL skills for optimizing complex queries.
- Work with cloud environments (AWS, GCP, Azure) to deploy/manage Snowflake clusters.
- Use ETL/ELT tools (FiveTran, Matillion, Talend, Informatica) for data integration.
- Employ advanced scripting skills (Python, Bash) to automate data processes and support CI/CD.
- Build and tune machine learning models in Azure and Snowflake.
- Maintain strong knowledge of data security, encryption, and regulatory compliance (GDPR, HIPAA, SOC 2).
- Work within Agile development methodologies in a fast-paced environment.