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
Rate:
Not specified
Location:
Remote
IR35 Status:
Not specified
Remote Status:
Remote
Industry:
Data & Analytics
Seniority Level:
Not Specified