BI & Analytics Analyst/Data Engineer

JSSA; Rockville (MD); Hybrid; USD 90,000 - 130,000; Full time

Job summary

JSSA seeks a BI & Analytics Analyst / Data Engineer to lead end‑to‑end analytics, from data warehouse design in SQL Server to delivering polished Power BI reports. The role blends BI delivery with hands‑on data engineering and requires collaboration with stakeholders and data engineers to produce reliable, scalable insights.

The candidate should have 5–7+ years in BI/analytics, strong SQL/T‑SQL skills, Power BI expertise, and hands‑on experience with Wherescape and Azure data services.

Qualifications

• Bachelor's degree required; Master’s degree highly preferred.
• 5–7+ years of experience in a BI, analytics, or data engineering role.
• Strong proficiency in SQL Server and T‑SQL—including stored procedures, window functions, and query optimization.
• Hands‑on experience building and maintaining Power BI reports and semantic models (DAX, Power Query).
• Hands‑on experience with Wherescape OLAP solution.
• Experience with Azure data services (Azure Synapse, Data Lake, Analysis Services).
• Experience integrating or working with EMR data (optional but helpful).
• Familiarity with star schema/dimensional modelling (Kimball a plus).
• Python for data wrangling or automation is a plus.

Responsibilities

• Owns end‑to‑end analytics lifecycle from data shaping to self‑service Power BI reports.
• Translates business requirements into clear analytical deliverables and manages stakeholders.
• Designs and maintains star schema data warehouse objects in SQL Server.
• Writes and maintains T‑SQL stored procedures, ETL pipelines, and DWH data loads.
• Develops and owns source‑to‑target mapping documentation for new data domains.
• Integrates data from source systems and ensures data quality and lineage.
• Supports self‑service analytics through well‑documented datasets and standards.

Skills

SQL Server

T-SQL

Power BI

DAX

ETL

Python

Data Modeling

Star schema

Wherescape

Azure Synapse

Azure Data Lake

SSIS

Education

Bachelor's degree

Tools

Wherescape OLAP

SSIS

Azure Analysis Services

Azure Synapse Analytics

Azure Data Lake

MDS

DQS

Job description

JSSA has been helping individuals and families across the Washington metro area through a wide range of counseling, educational, special needs services, in‑home support, hospice and nursing care, and social services. BI & Analytics Analyst/Data Engineer is the key resource for JSSA, and is responsible for all engineering, development, support, and management of data and analytics solutions within the agency. About the role: We are looking for a driven, analytically sharp BI & Analytics Analyst / Data Engineer to join our growing IT team. This is a hybrid role with an equal split between business intelligence delivery and hands‑on data engineering—ideal for someone who loves both telling stories with data and building the infrastructure that powers them. You will own the end‑to‑end analytics lifecycle: from shaping SQL Server data warehouse structures to delivering polished, self‑service Power BI reports. You will work closely with business stakeholders, 3rd‑party data engineers (source data), and IT business partners (and their stakeholders) to turn raw data into reliable, scalable, and actionable insight.

Essential Functions

• Business Intelligence & Analytics works with IT business partners and operational leaders to design analyses that identify opportunities for improvement in care, evaluate adherence to clinical best practice, and measure outcomes.
• Assists with ensuring that agency data repositories produce consistent, reusable data through collaboration with key staff to develop, implement and provide guidance on standards and best practices.
• Promotes best‑practice knowledge and use to business stakeholders enabling self‑service analysis vs. IT owned development.
• Owns self‑service reporting datasets, including DAX measures, data models, and row‑level security.
• Translates business requirements into clear analytical deliverables, manages stakeholder expectations and iterates based on feedback.
• Monitors report usage and data quality, proactively identifying and resolving issues.
• Documents data definitions, metric logic, and report lineage to support a data‑literate culture within the agency.
• Uses technical tools to query, manipulate, and summarize data from various data sources.
• Assists in designing, developing, maintaining, and updating databases on department and organizational needs.
• Designs and builds star schema data warehouse objects in SQL Server, including fact tables, dimension tables, and aggregate layers.
• Writes and maintains T‑SQL stored procedures, ETL pipelines, and staging‑to‑DWH data loads.
• Develops and owns source‑to‑target mapping documentation for new data domains.
• Integrates data from source systems.
• Contributes to data quality, pipeline reliability, and warehouse performance optimization.
• Supports the adoption of self‑service analytics by building clean, well‑documented datasets.
• Documents current data architecture, defines logical/physical data and establishes agency data blueprint.
• Manages and supports the data warehouse solution (Wherescape RED), SQL Server and associated data management.
• Defines operational monitoring and alerting tools to ensure end‑to‑end delivery of trusted, quality data from source systems to consumption.
• Establishes best‑practice standards and processes for data automation, orchestration, and transformation.
• Identifies, designs, implements and manages a master data management solution for client and employee subjects.
• Works with key stakeholders to define data quality standards and operational DQ processes.

Minimum Education, Licensure, and Work Experience Required

• Bachelor’s degree required; Master’s degree highly preferred.
• 5‑7+ years of experience in a BI, analytics, or data engineering role.
• Strong proficiency in SQL Server and T‑SQL—including stored procedures, window functions, and query optimization.
• Hands‑on experience building and maintaining Power BI reports and semantic models (DAX, Power Query).
• Hands‑on experience with Wherescape OLAP solution.
• Experience with alternative OLAP solutions (e.g., Azure Analysis Service, Azure Data Lake, and Azure Synapse Analytics).
• Experience integrating or working with EHR data (reports, APIs, or data exports).
• Familiarity with star schema/dimensional modelling concepts (Kimball methodology a plus).
• Python experience for data wrangling, automation, or pipeline scripting.
• Experience with Microsoft Master Data Services (MDS), including defining entities and creating business rules.
• Experience with Microsoft Data Quality Services (DQS) and SQL Server Integration Services (SSIS).
• Comfortable working across the full analytics stack—from raw source data to end‑user report.
• Strong communication skills—able to explain data concepts clearly to non‑technical stakeholders.
• Advanced skill set with Microsoft office suite (Power BI), SQL, and experience with EMR systems (hospice, homecare, and/or mental health) desired.