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.
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.
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.
Skills Required
- Senior-level experience as a BI Developer, Analytics Engineer, or equivalent
- Strong SQL expertise, including reading, decomposing, and refactoring complex SQL Server code
- Experience building data models and data marts in Snowflake or a comparable cloud data warehouse
- Experience building dashboards and reports in Sigma or a comparable modern BI tool
- Knowledge of dimensional data modeling and semantic-layer design
- Ability to translate ambiguous business requirements into completed reporting with minimal oversight
- Experience in healthcare, healthcare claims, or another regulated data environment
- Direct experience with SQL Server-to-Snowflake migrations
- Familiarity with dbt or similar transformation or orchestration tooling
- Experience establishing a BI or reporting function and standards
What We Do
SmartLight Analytics was formed by a group of industry insiders driven to make a meaningful impact on the rising cost of employee healthcare. Using our statistical, clinical, fraud detection, coding and claims expertise we deliver the most complete wasteful spend reduction solution directly to self-funded employers. SmartLight utilizes proprietary inferential analytics customized to your employee population, followed by expert clinical review on 100% of your medical claims. Our team partners with your TPA to implement solutions resulting in a lower per employee healthcare spend. We let your data tell us where to look without any preconceived notions about what the errors are beforehand. Our approach is low-touch and involves zero employee involvement. SmartLight consistently delivers a higher ROI compared to other cost reduction solutions on the market.
.jpg){kind=logo}
