caferemote
SmartLight Analytics

Senior Business Intelligence Developer

Remote United States Full-time Senior $120K – $145K / year Posted 7 days ago
Apply now
Work from
United States
Contract
Full-time
Experience
Senior
Salary
$120K – $145K / year
Posted
13 November 2026
Apply by
10 December 2026

This role is central to that transition.

SmartLight is actively migrating its data platform from SQL Server to Snowflake. 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.

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.

Requirements

  • 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.

Nice to have

  • 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.

Discussion

No comments yet. Ask a question or share a tip about this role.

Apply now

More jobs from SmartLight Analytics

View company →

Marketing Coordinator

SmartLight Analytics
Remote United States Full-time $65K – $90K / year

We are seeking an organized, detail-oriented, and creative Marketing Coordinator to join the SmartLight Analytics Business Development team, reporting to and…

10 days ago Sales and Marketing

Similar remote jobs

Browse all →

AI Safety Expert - Bilingual

mercor
Remote United States Contract $17 – $25 / hour

About the job Mercor connects elite creative and technical talent with leading AI research labs. Headquartered in San Francisco, our investors include Benchmark , General Catalyst , Peter…

1h ago Data

Senior AI & Transformation Enablement Specialist

Datasite
Remote United States Full-time $83K – $141K / year

About us Datasite is the essential infrastructure for M&A. Also comprising Grata, Blueflame AI, and Sherpany, we help dealbreakers find opportunities, manage transactions, and make key…

1h ago Data

Business Analyst III Claims, DRG

Centene Corporation
Remote United States Full-time $70K – $126K / year

Position Purpose: Perform various analysis and interpretation to link business needs and objectives for assigned function. Key Details: Must be authorized to work in the U.S. without the…

1h ago Data

Functional Consultant – Epicor Kinetic (Operations & Supply Chain) – 100% Remote

TeccWeb
Remote United States Full-time

About Teccweb Teccweb is an Epicor Service Partner specializing in the implementation and optimization of Epicor Kinetic for mid-market manufacturers and distributors across North America.…

1h ago Data

Product Owner

Dev Partners
Remote Philippines Full-time

💻 We Are Hiring- Product Owner | 100% Remote We are seeking an experienced Product Owner to oversee and coordinate the ongoing maintenance, enhancement, and continuous improvement of an…

2h ago Data

Mechanical Engineer III

DLB Associates
Remote United States Full-time $105K – $135K / year

DLB Associates is a premier engineering and consulting firm specializing in innovative, mission-critical solutions across hyperscale data centers, advanced infrastructure, and…

2h ago Data

Get remote jobs the moment they are posted

Choose your categories and skills. We push matching jobs to your device. No email, ever.