Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowPosted 78 days ago

BI & Analytics Analyst/Data Engineer

JSSA17 open roles

Where
200 Wood Hill Rd, Rockville, MD 20850, USA
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowBI & Analytics Analyst/Data EngineerJSSA · 200 Wood Hill Rd, Rockville, MD 20850, USA

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on JSSA's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

7.8% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 1.6%1 day
  2. 3.4%3 days
  3. 7.8%7 days
  4. 14.3%14 days
  5. 33.7%30 days
This job: posted 78 days ago

The posting

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, evaluates adherence to clinical best practice, and measures 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. 

Own self-service reporting datasets, including DAX measures, data models, and row-level security. 

Translate business requirements 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 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. 

  Data Engineering   

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 own 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 the adoption of self-service analytics by building clean, well-documented datasets. 

Document current data architecture, define logical/physical data and establish agency data blueprint. 

Management and support of data warehouse solution (Wherescape RED), SQL Server and associated te 

  Data Management   

Define operational monitoring and alerting tools to ensure end to end delivery of trusted, quality data from source systems to consumption. 

Establish best practice standards and processes for data automation, orchestration, and transformation. 

Identify, design, implement and manage master data management solution for client and employee subjects. Work 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 creation of 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.  

Salary 110-132K

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against JSSA's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on JSSA's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    JSSA's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.