Teams at SmartLight Analytics

Build governed Snowflake data marts and Sigma dashboards while migrating legacy SQL Server logic. Reverse-engineer stored procedures, views, and queries; translate business requirements into reliable reporting; establish standardized metrics, semantic layers, documentation, governance, and data-quality practices for sensitive healthcare claims data.

Build and maintain healthcare data ingestion pipelines and dbt transformation models in Snowflake. Contribute to fact and dimensional modeling, semantic-layer development, data quality troubleshooting, pipeline reliability, and governed reporting. Collaborate with engineers, analysts, and stakeholders to translate requirements into technical data structures. Use AI-assisted development tools while following testing, documentation, security, SDLC, and change-management practices.

Analyze healthcare claims and eligibility data to identify payment anomalies, trends, and actionable insights. Build and maintain dashboards, conduct data audits, fulfill ad hoc analytical requests, automate recurring reporting processes, and communicate findings to technical and non-technical stakeholders. The role partners with account managers, clinical teams, and operational teams to support client conversations and improve healthcare cost-management outcomes.