Data & BI Analyst jobs

Senior Business Intelligence Developer

SmartLight AnalyticsPlano, TXFull-timeFirst seen 20 days ago

Pay not listed

Looks real. 1 thing to check before you apply.

On SmartLight Analytics’ own careers site (JazzHR), checked open today.

  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteJazzHR board
  • Checked: Checked open todayJazzHR board
  • Checked: No reposts foundJazzHR board
  • Trust score 95 / 100 · Strong
See all 5 checksShow fewer
How we check

What you’ll do

  • Design, build, and maintain governed Snowflake data marts for business reporting.
  • Develop and maintain dashboards and reports in Sigma.
  • Reverse-engineer legacy SQL Server procedures, views, and queries and translate them into Snowflake models.
  • Gather reporting requirements from business subject-matter experts and deliver reports from inception through completion.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • Senior-level experience as a BI Developer, Analytics Engineer, or equivalent, delivering production data marts and reporting
  • Hands-on experience building data models and marts in Snowflake or a comparable cloud data warehouse
  • 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) (preferred)
  • Direct experience with SQL Server-to-Snowflake migrations (preferred)
  • Experience establishing a BI/reporting function or standards where none previously existed (preferred)

Skills

  • Strong SQL expertise, including reading, decomposing, and refactoring complex legacy SQL Server code (stored procedures, views)
  • Proficiency building dashboards and reports in Sigma or a comparable modern BI tool
  • Grounding in dimensional/data modeling and semantic-layer design
  • Familiarity with dbt or similar transformation/orchestration tooling (preferred)

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From SmartLight Analytics’ careers site

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

Show full descriptionShow less

- 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.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Senior BI Analyst

CoreWeave · Dallas, TX

$75k–$110k/yrFull-time

StrongChecked open todayPosted 18 days ago

Business Data Analyst

IntelliPro Group Inc. (agency) · Plano, TX

$69/hrContractHybrid

StrongChecked open todayPosted 20 days ago

Senior Marketing Analyst

One Park Financial · Dallas, TX

Full-time

StrongPay not listedLast seen open yesterdayPosted 1 month ago

See more like this