← Back to jobsJob ID col-cmwp92h2l08jzd8hasr2oh84e

SmartLight AnalyticsPosted 2 days ago

Senior Business Intelligence DeveloperNew

Full-time
Remote
Competitive
Posted 2 days ago

SmartLight Analytics is migrating its data platform from SQL Server to Snowflake. The Senior Business Intelligence Developer will reverse-engineer legacy SQL Server logic, build governed Snowflake data marts, and develop Sigma dashboards and reports. The role will also define consistent metrics, translate business requirements into reporting solutions, and support data quality, governance, and audit readiness for sensitive healthcare claims data.

Posted
2 days ago
Source
smartlightanalytics.applytojob.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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

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

  • 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
  • Healthcare Experience

Required skills

Data MartsDimensional Data ModelingHIPAA/PHIHealthcare Claims DataSQLSQL ServerSQL Server-to-Snowflake MigrationSemantic-Layer DesignSigmaSnowflakedbt

Full job description

SmartLight Analytics is migrating its data platform from SQL Server to Snowflake. The Senior Business Intelligence Developer will reverse-engineer legacy SQL Server logic, build governed Snowflake data marts, and develop Sigma dashboards and reports. The role will also define consistent metrics, translate business requirements into reporting solutions, and support data quality, governance, and audit readiness for sensitive healthcare claims data.

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

Preferred

  • 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
  • Healthcare Experience
  • Healthcare Claims
  • Regulated Data Environments
  • HIPAA
  • PHI
  • Database Migrations
  • dbt
  • Data Transformation
  • Data Orchestration
  • BI Function Establishment
  • Reporting Standards

Company

  • Healthcare claims analytics to reduce wasteful spend for self-funded employers
  • Plano, Texas, USA
  • https://smartlightanalytics.com/
  • Founded in 2016
  • 51-200 employees

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

Required skills

  • Data Marts, Dimensional Data Modeling, HIPAA/PHI, Healthcare Claims Data, SQL, SQL Server, SQL Server-to-Snowflake Migration, Semantic-Layer Design, Sigma, Snowflake, dbt

Preferred skills

  • Direct experience with SQL Server-to-Snowflake migrations

Job details

Employment type

Full-time

Seniority level

Not stated

Date posted

Nov 19, 2026

Work mode

Remote

Job source

smartlightanalytics.applytojob.com

Company

SmartLight Analytics

Information Technology & AI

Healthcare claims analytics to reduce wasteful spend for self-funded employers

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Warehouse Engineer jobs

just now

1d ago

New

DBT Engineer with Airflow & SQL

Full-timeOn-siteUnited StatesCompetitive

NTT DATA is hiring a DBT Engineer with Airflow & SQL to build and maintain data transformation models and scalable ELT/ETL pipelines in Snowflake. The role focuses on data modeling, warehouse performance, and data quality and security.

Why similarSame roleSQLSnowflake

Apexon

1d ago

New

Data Warehouse and BI Maintenance and Operations Engineer

Full-timeRemoteUnited StatesCompetitive

Apexon is hiring a Data Warehouse and BI Maintenance and Operations Engineer to support the data lake, data warehouse, and reporting layer of a Medicaid Analytics platform.

Why similarSame roleSQLSnowflake

United Software Group Inc

1d ago

New

Forward Deployed Engineer-BI, LookML and BigQuery at 100% Remote Role

TemporaryRemoteUnited StatesCompetitive

United Software Group Inc is hiring a Forward Deployed Engineer to help modernize BI environments with Looker and BigQuery and prepare them for AI.

Why similarSame roleSQLdbt

Get new Data Warehouse Engineer jobs by email

Create job alert

Senior Business Intelligence Developer

SmartLight Analytics · Competitive

Apply on company site