DW Snowflake Solution Architect

Job Description

Job Title: DW Snowflake Solution Architect

Location: EST/ CST, USA

Hire Type: Contract

Job Description:

Identify and write UAT test scripts
Write SQL statements based on entity relationship diagrams and source to target mapping table definitions
Proactively ask questions to better understand data and business processes
Review data and reports in Power BI, ability to build simple reports a plus
Does not need to be able to create connections to Snowflake or build the datasets; CDO owns that
Prepare and execute user training on how to review our data dictionary, request access to user roles, run provided SQL queries in Snowflake, access and run PowerBI reprots and work on ad-hoc PowerBI data pulls
Provide feedback on data model against business requirements
Review scope & design and provide strategic POV to DTV Transformation Lead and guidance to the team
Experience with large complex DW project both as Solution Architect and PM
Need to have Solution Architect with PM experience to help provide POV for them to build the realistic plan / time commitment / schedules
Understand business needs and translate into key solution architecture
DW with ERP experience is critical with focus on Finance (COA, Revenue, etc.)
Snowflake experience is nice to have