Senior BI Analyst: Dashboards, SQL & Data Pipelines

Jim Adler & Associates; Houston (TX); On-site; USD 75,000 - 120,000; Full time

Job summary

Jim Adler & Associates is seeking a data analyst with strong SQL and BI dashboard skills. You will build and optimize dashboards, collaborate with firm leadership to gather requirements, and ensure accurate, governance‑compliant reporting across key metrics.

The role emphasizes data pipelines, transformations, and user training to enable self-serve analytics for attorneys and staff. Experience with Snowflake and cloud data sources is preferred.

Qualifications

• 3 to 5 years of experience in a BI, reporting, or data analyst role.
• Strong, demonstrable SQL skills, including joins and aggregations.
• Hands-on experience building dashboards in modern BI platforms (Domo, Power BI, Tableau, SSRS).
• Experience gathering requirements from non-technical stakeholders and translating them into reports.
• Strong attention to detail and delivering validated data.
• Clear written and verbal communication with attorneys and executives.

Responsibilities

• Build, maintain, and improve dashboards and reports in the firm's BI platform and other tools.
• Partner with management and attorneys to gather requirements and deliver relevant reports.
• Write and optimize SQL to query Snowflake and SQL Server.
• Build and maintain data pipelines from Snowflake and S3 into the BI platform.
• Develop and maintain data transformations for clean datasets.
• Track and report on firm metrics (case volume, aging, intake, revenue, etc.).
• Document datasets, definitions, and report logic for shared understanding.
• Train and support users to navigate dashboards and self-serve.

Skills

SQL proficiency

Query optimization

Dashboard/report development

Requirements gathering

Attention to detail

Communication

Education

Bachelor's degree or equivalent

Tools

Domo

Power BI

Tableau

SSRS

Snowflake

SQL

Job description

Jim Adler & Associates is seeking a data analyst with strong SQL and BI dashboard skills. You will build and optimize dashboards, collaborate with firm leadership to gather requirements, and ensure accurate, governance‑compliant reporting across key metrics.

The role emphasizes data pipelines, transformations, and user training to enable self-serve analytics for attorneys and staff. Experience with Snowflake and cloud data sources is preferred.