Snowflake Architect

Local to bay area

Onsite 1day a week

6 months contract to hire.

Location and working hours
local to Bay Area and one day onsite a week in Oakland office.

Snowflake Architect

Job Overview

The Data Analytics and Insights team is seeking an experienced and talented Senior Data Engineer to join our growing team of analytics experts. As a key member of our team, you will play an essential role in the design, development, and maintenance of data pipelines, data products, and analytic products in enterprise snowflake. The ideal candidate will have a strong background in data engineering, with specific expertise in Informatica and Snowflake. This role will involve working closely with our business stakeholders, data analysts, and data scientists to ensure the efficient development and management of our data infrastructure.

You will have a unique opportunity to be at the forefront of the utility industry and gain a comprehensive view of the nation's most advanced smart grid.

Key Responsibilities

• Develop and optimize cloud-based data storage and processing solutions usingSnowflake.
• Design, implement, and maintain robust data pipelines andETL processes
• Collaborate with Federated teams and other data engineers to understand data requirements and deliver high-quality data solutions.
• Ensure data integrity and security across all data workflows and storage solutions.
• Monitor and troubleshoot data pipelines, addressing any issues promptly to ensure the smooth flow of data.
• Develop reusable and modularstored procedures and scripts for data processing.
• Contribute to the development and implementation of data governance and best practices.
• Monitor and troubleshoot data pipelines to ensure reliability and accuracy.
• Implement best practices for data governance, data quality, and metadata management.

Minimum Qualifications

• Bachelor's or master's degree in computer science, Engineering, or a related field.
• Minimum of 5 years of experience in data engineering or a related role.
• Proven experience withSnowflake is required.
• Knowledge ofdata warehousing concepts, dimensional modeling, and performance tuning.
• Hands-on experience withETL tools (e.g., Informatica, Talend, dbt, or custom ETL frameworks).
• Strong proficiency in SQL and database management.
• Experience with cloud platforms such as AWS, Azure, or Google Cloud.
• Familiarity with version control(Git) and CI/CD for data pipelines.
• Familiarity with Big Data technologies such as Hadoop, Spark, and Kafka is a plus.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities.

Preferred Skills

• Experience with Python or other scripting languages.
• Experience with informatica but not necessary.
• Knowledge of data visualization tools such as Tableau or Power BI.
• Exposure todata orchestration tools