Senior Business Intelligence Developer
At a glance
Senior Data Analysis & BI role at SmartLight Analytics. Remote · full-time.
Pay not stated Data Analysis & BI salary
dataroles summary, based on the employer's posting.
What you'll do
- Rebuild legacy SQL Server procedures, views and report queries as governed Snowflake data marts while preserving and improving their business logic
- Create and maintain Sigma dashboards that turn business reporting needs into clear, decision-ready insights
- Work with business experts to clarify reporting needs, then take each report from initial requirements through delivery
- Set shared metric definitions and modeling practices so reports reconcile and data marts stay maintainable
- Document reporting standards and apply quality, governance and HIPAA-aligned handling to sensitive claims data
What you bring
- You have senior-level experience delivering production data marts and reporting in BI development, analytics engineering or a comparable role
- You can untangle complex SQL Server procedures and views, then build data models in Snowflake or a comparable cloud warehouse
- You have built dashboards in Sigma or another modern BI tool and can learn Sigma quickly
- You understand dimensional modeling and semantic layers, and can turn unclear requests into finished reports with little oversight
Who this fits
This senior role suits someone comfortable moving between legacy SQL investigation, cloud data modeling and hands-on reporting delivery. It is remote and involves handling sensitive healthcare claims data with HIPAA-aligned practices.
From the employer
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.
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BIRemote
Find me workBy the team behind dataroles.