Back to jobs

Senior Business Intelligence Developer

Pay
Pay not listed
Work setting
Remote — work setting source
Listed location: Remote
Read the full posting
Employment
Not stated

What you’ll work on

Full posting
  • Reverse-engineer legacy SQL Server stored procedures, views and queries into Snowflake models

  • Design, build and maintain governed Snowflake data marts as the single source of truth

  • Develop and maintain Sigma dashboards and reports for business stakeholders

  • Capture reporting requirements with business SMEs and own delivery end to end

  • Document consistent business definitions and metric logic so numbers reconcile

From the employer’s posting
Reverse-engineer legacy SQL Server logic (stored procedures, views, queries) and translate it into well-structured Snowflake models as part of the platform migration.
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.
Partner directly with business SMEs to capture reporting requirements, then own delivery from inception through final report
Establish and document consistent business definitions and metric logic so that numbers reconcile across the organization.

What you’ll bring

All qualifications

Core experience

  • 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).
  • Ability to translate ambiguous business requirements into finished, self-explanatory reporting with minimal oversight.

Preferred experience

  • Experience in healthcare, healthcare claims, or another regulated data environment (HIPAA/PHI).
  • Familiarity with dbt or similar transformation/orchestration tooling.
  • Experience establishing a BI/reporting function or standards where none previously existed.
Qualification wording
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).
Ability to translate ambiguous business requirements into finished, self-explanatory reporting with minimal oversight.
Experience in healthcare, healthcare claims, or another regulated data environment (HIPAA/PHI).
Familiarity with dbt or similar transformation/orchestration tooling.
Experience establishing a BI/reporting function or standards where none previously existed.
Apply at SmartLight Analytics

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 14, 202668 days ago
Recorded sightings
46
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 68

Up longer than most. Similar jobs usually come down between day 5 and day 43.

Well past SmartLight Analytics’s usual: its jobs come down by about day 19.

From 16,018 similar postings that came down, and 9 of SmartLight Analytics’s. Coming down is not always a hire.

SmartLight Analytics is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring has slowed
  • Takes jobs down quickly
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • dbt
  • Sigma
  • Snowflake
  • SQL Server
Where the posting names them
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
- 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.
- 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).
- 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.
- 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.
- 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.
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.
- 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).
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.

Your next step

Complete your application on smartlightanalytics.applytojob.com. The employer’s form will show what is required.

Applying through JazzHR

  • No account needed: one application form on the employer’s applytojob.com page.

Already applied? Track this application

Job description

View original posting ↗

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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Remote

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.