Senior Data Engineer — MSSQL to Snowflake Migration (Fivetran + dbt)
- Рівень:
- senior
- Джерело:
- djinni.co
Що робити
- Migration & Translation
- Analyze existing SQL Server stored procedures that feed SSRS reports — catalog business logic, conditional transformations, and reporting-specific edge cases
- Translate stored procedure logic into dbt models (staging, intermediate, and mart layers) using idiomatic SQL and dbt best practices
- Design the Snowflake schema architecture (raw, staging, marts) aligned with dimensional modeling principles
- Ingestion & Pipeline Design
Що очікуємо
- 5+ years working with SQL Server (T-SQL), including complex stored procedures and SSRS
- 3+ years with Snowflake (schema design, performance tuning, warehouse sizing, access control)
- 2+ years building production dbt projects (models, tests, macros, packages, CI/CD)
- Hands-on experience with Fivetran (connector configuration, sync management, schema handling)
- Deep understanding of dimensional modeling and data mart architecture
Схожі вакансії
З блогу Trackr
Усі статті →
Знайдено через trackr.help/jobs · Канал: @trackrhelp · Бот для персональних сповіщень: @trackrhelpBot