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.
Powered by JazzHR
Senior Business Intelligence Developer • PLANO, TX, US
Virtual Director Of Sales - Nola, Ai Dlp, Cybersecurity.Our client is the first-ever data security platform that puts data loss prevention (DLP) and insider risk management (IRM) programs on autopi... Show more
Follow implementation timeline and report progress and impediments to senior management.Work with partner teams to choreograph dependencies and follow program timeline to completion.Expertise in Ag... Show more
Travel expenses will be paid to Non locals).O9 Solutions Functional Expertise in Supply Planning and Multi-Echelon Inventory Optimization.O9 Design and Configuration Expertise with Demonstrated ski... Show more
Quotient Inside Ai Product Enablement Senior Manager.At Oliver Wyman, a Marsh (NYSE: MRSH) business, we bring deep industry insight, bold innovation, and a collaborative approach that cuts through ... Show more
Kearney Senior Business Analyst, Mobility, Defense and Advanced Industrials.As a Senior Business Analyst at Kearney, you will be a key contributor to the growth and development of our Mobility, Def... Show more
Associate Director AI Software Security Engineer.The Raytheon Software Engineering Team is seeking an experienced and delivery-focused Associate Director AI Software Security Engineer to drive appl... Show more
Business Intelligence DeveloperWe are looking for a highly skilled and experienced Business Intelligence Developer to join our Business Intelligence & Analytics team.You will play a critical ro... Show more
Senior Principal Risk Specialist, Cyber Engagements.About FINRA FINRA (Financial Industry Regulatory Authority) is the largest independent regulator of securities firms doing business in the United... Show more
Digi Security Systems is an industry leader in the design, installation and support of custom video surveillance, electronic access control, and intrusion detection solutions for public and private... Show more
The Best Teams are Created and Maintained Here.The Business Developer (BD) works to improve BrightView’s market position and achieve profitable financial growth.This role helps to achieve long-term... Show more
Kearney Foresight Senior Business Analyst.As a Foresight Senior Business Analyst at Kearney, you will be a key contributor to the growth and development of our Foresight Practice as we offer honest... Show more
Senior Director of Channel Sales, AI Cybersecurity, Remote.We are a fast-growing, venture-backed cybersecurity company building the next-generation autonomous data security platform.Our solution au... Show more
The Assurance Senior Manager is responsible for developing suggestions to improve client internal controls and accounting procedures as well as advising the client on various economic and regulator... Show more
Responsible for interpreting business needs, gathering and documenting requirements, and ensuring alignment between business objectives and technical solutions.Supports end-to-end project lifecycle... Show more
Review and label digital content including text, images, and documents.Every task you complete helps improve how technology interprets information and performs in practical settings.Detail-oriented... Show more
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more
Business Intelligence - Project Manager.Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company in the United States, which was founded in 2011 by Mark M... Show more
Experience Required: 8 years overall.Business Analyst (BA) and 4+ years of experience in Healthcare.Sound knowledge of Healthcare and BA work experience especially with Data Integration is mandator... Show more
Quotient Inside Ai Product Enablement Senior Manager.At Oliver Wyman, a Marsh (NYSE: MRSH) business, we bring deep industry insight, bold innovation, and a collaborative approach that cuts through ... Show more
Business Development Manager for Military and Specialty Vehicle.The Business Development Manager for Military and Specialty Vehicle is responsible for driving sales growth by promoting product acro... Show more
