
Senior Business Intelligence Developer
Job description
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.
Job details
- Published
- September 11, 2026
- Last checked
- November 17, 2026
- Experience
- Senior
- Job source
- jazzhr
- Workplace
- Remote · PLANO, US
- First seen
- November 14, 2026
LiftmyCV exclusive data
SmartLight Analytics hiring intelligence
SmartLight Analytics currently has 7 active jobs tracked by LiftmyCV. 0 new jobs in the past 7 days.
Verified November 17, 2026
Active openings
7
Currently tracked by LiftmyCV
New in 7 days
0
4 new jobs in the past 30 days
Published salaries
—
Not published by this employer yet
Average opening age
36 days
Across 7 active openings
Workplace breakdown
Hiring countries
Top hiring cities
Most in-demand roles
- • Business Analyst- Data Science
- • Director of Account Management
- • Marketing Coordinator
- • Payment Integrity Nurse Reviewer- Hospital Claims
- • Senior Business Intelligence Developer
- • Senior Lead Payment Integrity
As of November 17, 2026
Hiring insights calculated from active jobs tracked by LiftmyCV.
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at SmartLight Analytics
Similar jobs from this company
- Payment Integrity Nurse Reviewer- Hospital ClaimsSmartLight AnalyticsPLANO, USRemote
- Senior Software EngineerSmartLight AnalyticsTulsa, USRemote
- Marketing CoordinatorSmartLight AnalyticsPLANO, USRemote
- Senior Lead Payment IntegritySmartLight AnalyticsPLANO, USRemote
- Director of Account ManagementSmartLight AnalyticsPlano, USRemote
Across the market
Similar jobs from other companies
- Senior Business Intelligence DeveloperVanderbilt University Medical CenterNashville, USRemote
- Senior Business Intelligence DeveloperUniversity of ChicagoCharles M. Harper CenterOn-site
- Senior Business Intelligence DevelopermitelBangalore (NXT)On-site
- Senior Business Intelligence DeveloperAcronis BSC d.o.o. BeogradRSOn-site
- Senior Business Intelligence DeveloperCineplex Entertainment LPToronto, CAOn-site
- Senior Business Intelligence DeveloperCorewell Health CorporateSouthfield, USOn-site
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.