Overview
Remote
Depends on Experience
Contract - W2
Contract - Independent
Skills
snowflake
architect
ETL
Data modeling
Job Details
- Data Modeling & Architecture: Design and implement scalable data models and schemas within Snowflake to support business intelligence and analytics needs.
- ETL Development: Develop, test, and maintain ETL processes to integrate data from various sources into Snowflake, ensuring data accuracy and consistency.
- Performance Optimization: Optimize SQL queries and Snowflake configurations to enhance performance and reduce costs, including the use of clustering keys, materialized views, and partitioning strategies.
- Data Security & Governance: Implement and manage security measures such as role-based access control (RBAC), data encryption, and auditing to protect sensitive information and ensure compliance with data governance policies.
- Collaboration & Support: Work closely with data engineers, analysts, and business stakeholders to understand data requirements and deliver appropriate solutions. Provide technical support and training to team members and end-users.
- Monitoring & Troubleshooting: Monitor Snowflake environments for performance issues, troubleshoot problems, and implement solutions to maintain optimal system performance.
- Documentation: Maintain comprehensive documentation for data models, ETL processes, and system configurations to support data governance and compliance efforts.
- Experience: 3 5 years of experience as a Snowflake Developer or in a similar data engineering role, with a focus on data warehousing and ETL processes.
- Technical Skills:
- Proficiency in SQL and Snowflake-specific SQL extensions.
- Experience with data modeling concepts and best practices.
- Familiarity with ETL tools and data integration techniques.
- Understanding of cloud platforms, particularly Snowflake, AWS
- Knowledge of data security and compliance standards.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.