Senior Business Intelligence Developer

• →

  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.