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.