Snowflake DW Architect

Job Title

Expertise in Snowflake – Data modeling, ETL, Azure storage, Python and Best Practices in Snowflake.

Good Knowledge in Customer Service domain, especially in the field of Customer Meter Read, Billings, Rate Programs etc

Design, Develop and implement effective Analytics solutions and models with Snowflake

Design, Architecture and implement effective Analytics solutions and models using technologies

Examine and identify Data warehouse structural necessities by evaluating business requirements.

Assess Data warehouse implementation procedures to ensure they comply with internal and external regulations.

Prepare accurate Data warehouse design and architecture reports for management and executive teams.

Monitor the system performance by performing regular tests, troubleshooting and integrating new features.

Recommend solutions to improve new and existing Data warehouse solutions along with optimizing query performance.

Review the code and ensure the accuracy to the business requirements.

Educate staff members through training and individual support.

Offer support by responding to system problems in a timely manner.

Understand and document data flows in and between different systems/applications

Guidance to developers in preparing functional/technical specs to define reporting requirement and ETL process.

Snowflake Architecture, Azure Data Factory, python, Py Spark

In-depth knowledge of Snowflake end to end data architecture, demonstrated leadership skills, and expertise in technical project management

AI knowledge is a plus

Snowflake Certification is a Plus

Utility and Customer Service Domain knowledge like Billing and Rate Programs.

Data Modeling, Framework build on Ingestion, Audit, Logging and Reconciliation