BI & Analytics Analyst/Data Engineer

Jewish Council for the Aging of Greater Washington

Rockville (MD)

Hybrid

USD 110,000 - 132,000

Full time

11 days ago

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

The Jewish Council for the Aging of Greater Washington in Rockville, MD invites a BI & Analytics Analyst/Data Engineer to join a hybrid role. You will own the end-to-end analytics lifecycle, develop self-service Power BI reporting, and partner with stakeholders to translate business needs into actionable data products.

Qualifications include 5+ years in BI/analytics or data engineering, strong SQL Server and T-SQL proficiency, and hands-on Power BI expertise.

Qualifications

Bachelor’s degree in a related field required; Master’s highly preferred.
5–7+ years in BI, analytics, or data engineering.
Strong SQL Server and T-SQL proficiency.
Hands-on experience building Power BI reports and semantic models (DAX, Power Query).
Hands-on experience with Wherescape OLAP; experience with 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 and dimensional modeling concepts (Kimball methodology a plus).
Python experience for data wrangling, automation, or pipeline scripting.
Experience with Microsoft Master Data Services (MDS), DQS, and SSIS.

Responsibilities

Partner with IT business stakeholders and operational leaders to design analyses that identify opportunities for improvement in care, assess adherence to clinical best practices, and measure outcomes.
Help ensure agency data repositories provide consistent, reusable data by collaborating with key staff to develop, implement, and advise on data standards and best practices.
Promote best-practice knowledge and enable business stakeholders to conduct self-service analysis rather than relying on IT-owned development.
Own self-service reporting datasets, including DAX measures, data models, and row-level security.
Translate business needs into clear analytical deliverables, manage stakeholder expectations, and iterate based on feedback.
Monitor report usage and data quality, proactively identifying and resolving issues.
Document data definitions, metric logic, and report lineage to support a data-literate culture across the agency.
Use technical tools to query, manipulate, and summarize data from multiple data sources.
Assist in designing, developing, maintaining, and updating databases to meet department and organizational needs.
Design and build star schema data warehouse objects in SQL Server, including fact tables, dimension tables, and aggregate layers.
Write and maintain T-SQL stored procedures, ETL pipelines, and staging-to-DWH data loads.
Develop and maintain source-to-target mapping documentation for new data domains.
Integrate data from source systems.
Contribute to data quality, pipeline reliability, and warehouse performance optimization.
Support self-service analytics adoption by building clean, well-documented datasets.
Document current data architecture, define logical and physical data, and establish an agency data blueprint.
Manage and support the data warehouse solution (Wherescape RED), SQL Server, and associated components.
Define operational monitoring and alerting tools to ensure trusted, high-quality data flows from source systems to consumption.
Establish best-practice standards and processes for data automation, orchestration, and transformation.
Identify, design, implement, and manage a master data management solution for client and employee subjects, including defining data quality standards and operational data quality processes with stakeholders.

Skills

SQL Server

T-SQL

Power BI

DAX

Power Query

Wherescape OLAP

Wherescape RED

Azure Analysis Service

Azure Data Lake

Azure Synapse Analytics

Python

MDS

DQS

SSIS

EHR data

Star schema / Kimball

Data modeling

Education

Bachelor’s degree required

Master’s degree highly preferred

Tools

SQL Server

ETL pipelines

Star schema

Data warehouse design

Job description

The BI & Analytics Analyst/Data Engineer is responsible for engineering, development, support, and management of data and analytics solutions across the agency. This hybrid role splits time evenly between business intelligence delivery and hands-on data engineering, with ownership of the end-to-end analytics lifecycle and development of self-service Power BI reporting.

Responsibilities

Partner with IT business stakeholders and operational leaders to design analyses that identify opportunities for improvement in care, assess adherence to clinical best practices, and measure outcomes.
Help ensure agency data repositories provide consistent, reusable data by collaborating with key staff to develop, implement, and advise on data standards and best practices.
Promote best-practice knowledge and enable business stakeholders to conduct self-service analysis rather than relying on IT-owned development.
Own self-service reporting datasets, including DAX measures, data models, and row-level security.
Translate business needs into clear analytical deliverables, manage stakeholder expectations, and iterate based on feedback.
Monitor report usage and data quality, proactively identifying and resolving issues.
Document data definitions, metric logic, and report lineage to support a data-literate culture across the agency.
Use technical tools to query, manipulate, and summarize data from multiple data sources.
Assist in designing, developing, maintaining, and updating databases to meet department and organizational needs.
Design and build star schema data warehouse objects in SQL Server, including fact tables, dimension tables, and aggregate layers.
Write and maintain T-SQL stored procedures, ETL pipelines, and staging-to-DWH data loads.
Develop and maintain source-to-target mapping documentation for new data domains.
Integrate data from source systems.
Contribute to data quality, pipeline reliability, and warehouse performance optimization.
Support self-service analytics adoption by building clean, well-documented datasets.
Document current data architecture, define logical and physical data, and establish an agency data blueprint.
Manage and support the data warehouse solution (Wherescape RED), SQL Server, and associated components.
Define operational monitoring and alerting tools to ensure trusted, high-quality data flows from source systems to consumption.
Establish best-practice standards and processes for data automation, orchestration, and transformation.
Identify, design, implement, and manage a master data management solution for client and employee subjects, including defining data quality standards and operational data quality processes with stakeholders.

Requirements

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; experience with alternative OLAP solutions including 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 and dimensional modeling 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 reporting.
Strong communication skills, including explaining data concepts clearly to non-technical stakeholders.
Advanced skill set with the Microsoft Office suite (Power BI), SQL, and experience with EMR systems (hospice, homecare, and/or mental health) desired.