高级商业智能开发工程师
Senior Business Intelligence Developer
SmartLight正在将数据平台从SQL Server迁移到Snowflake。这个职位在这一转型过程中起着核心作用。大部分工作涉及逆向工程现有的遗留SQL Server逻辑——存储过程、视图和嵌入式报告查询，并将其重构为干净、高效的Snowflake数据集市。成功的候选人必须同样熟悉阅读和分解遗留的SQL Server代码，并在Snowflake中构建其现代等效版本，确保业务逻辑在迁移到新平台时得到保留、改进并正确管理。
关键职责
· 设计、构建和维护在Snowflake中的受控数据集市，作为业务报告的单一真实来源。
- 在Sigma中开发、发布和维护仪表板和报告，为业务利益相关者提供清晰、可决策的洞察。
- 逆向工程遗留的SQL Server逻辑（存储过程、视图、查询），并将其转化为结构良好的Snowflake模型，作为平台迁移的一部分。
- 直接与业务专家（SME）合作，获取报告需求，然后从开始到最终报告全程负责交付——减轻SME自行构建报表的负担。
- 建立并记录一致的业务定义和指标逻辑，使组织内的数据保持一致。
- 应用数据建模最佳实践（维度建模、可重用语义层），确保数据集市性能良好、易于维护且可扩展。
- 在构建时考虑数据治理、质量和符合HIPAA要求的处理方式，鉴于医疗理赔数据的敏感性。
- 为报告标准、命名规范和文档做出贡献，以降低关键人物风险并支持审计准备。
所需资格
· 有资深BI开发人员、分析工程师或同等职位的经验，能够交付生产环境的数据集市和报告。
- 强大的SQL技能，包括阅读、分解和重构复杂的遗留SQL Server代码（存储过程、视图）。
- 有在Snowflake（或具有明确迁移能力的类似云数据仓库）中构建数据模型和数据集市的实际经验。
- 熟练使用Sigma构建仪表板和报告（或具有快速上手Sigma能力的现代BI工具）。
- 扎实的维度/数据建模和语义层设计基础。
- 能够将模糊的业务需求转化为完成的、自助式的报告。
查看英文原文
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 data governance, quality, and HIPAA-aligned handling in mind, given the sensitivity of healthcare claims data.
- Contribute to reporting standards, naming conventions, and documentation that reduce key-person risk and support audit readiness.
Required Qualifications
· Demonstrated senior-level experience as a BI Developer, Analytics Engineer, or equivalent, delivering production data marts and reporting.
- Strong SQL expertise, including the ability to read, decompose, and refactor complex legacy SQL Server code (stored procedures, views).
- Hands-on experience building data models and marts in Snowflake (or comparable cloud data warehouse with clear ability to transition).
- Proficiency building dashboards and reports in Sigma (or a comparable modern BI tool with demonstrated ability to ramp quickly on Sigma).
- Solid grounding in dimensional/data modeling and semantic-layer design.
- Ability to translate ambiguous business requirements into finished, self-explanatory reporting with minimal oversight.
Preferred Qualifications
· Experience in healthcare, healthcare claims, or another regulated data environment (HIPAA/PHI).
- Direct experience with SQL Server-to-Snowflake migrations.
- Familiarity with dbt or similar transformation/orchestration tooling.
- Experience establishing a BI/reporting function or standards where none previously existed.
Impact
Within the first year, this role will consolidate today's scattered, SME-built reporting into a governed Snowflake-and-Sigma reporting layer that the business trusts, freeing subject-matter experts to focus on domain and client work, and establishing the scalable analytics foundation that supports SmartLight's continued growth.
Originally posted on Himalayas