Описание
SmartLight is actively migrating its data platform from SQL Server to Snowflake. This role is central to that transition. A significant portion of the work involves reverse-engineering existing legacy SQL Server logic — stored procedures, views, and embedded report queries — and re-architecting it into clean, performant Snowflake data marts.
The successful candidate must be equally comfortable reading and decomposing legacy SQL Server code and building its modern equivalent in Snowflake, ensuring that business logic is preserved, improved, and properly governed as it moves to the new platform. Key
Responsibilities
Design, build, and maintain governed data marts in Snowflake that serve as the single source of truth for business reporting. Develop, publish, and maintain dashboards and reports in Sigma that deliver clear, decision-ready insight to business stakeholders. Reverse-engineer legacy SQL Server logic (stored procedures, views, queries) and translate it into well-structured Snowflake models as part of the platform migration.
Partner directly with business SMEs to capture reporting requirements, then own delivery from inception through final report — relieving SMEs of self-service report-building. Establish and document consistent business definitions and metric logic so that numbers reconcile across the organization. Apply data modeling best practices (dimensional modeling, reusable semantic layers) to ensure marts are performant, maintainable, and scalable.
Build with
Полное описание, компания и ссылка на вакансию — после входа.
ВойтиКонтакты работодателя (email/phone/telegram) скрыты из публичного превью —
отправьте резюме, чтобы мы связали вас напрямую.