Snowflake Developer

Required Skills:

• Snowflake expertise : Advanced SQL, performance tuning, Snowpipe, Streams/Tasks, stored procedures, role-based access control, and cost/warehouse optimization
• Data conversion/migration experience: Proven track record of legacy-to-modern system conversions, including source-to-target mapping, data profiling, cleansing, reconciliation, and validation/audit controls
• ETL/ELT pipeline development: Hands-on with tools such as dbt, Informatica, Matillion, Azure Data Factory, or Python-based orchestration (Airflow); experience with CDC and incremental loading patterns Data modeling: Dimensional modeling and layered architectures (raw/staging/curated/marts) to support both conversion and downstream analytics
• Analytics and reporting enablement: Building analytics-ready datasets and supporting BI tools (Tableau, Power BI, or similar) for claims, benefits, and program integrity reporting
• Unemployment Insurance/claims domain knowledge: Familiarity with UI, DI, or PFL claims, benefit payments, employer accounts, and wage data. Prior EDD or other state workforce agency experience strongly preferred