Azure Analytics Developer Jobs

1 job found

Today

BI & Analytics Analyst/Data Engineer

Jewish Council for the Aging of Greater Washington Rockville, MD

Rockville, MD

Today

$110k - $132k/yr Full time Analyst Analytics Azure Analytics

Apply Now

Job Description

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

Location and Work Mode

Rockville, MD (hybrid)

Compensation

USD 110,000 - 132,000 per year

Key Responsibilities

Partner with IT business stakeholders and operational leaders to design analyses that identify opportunities for improvement in care, evaluate adherence to clinical best practice, and measure outcomes.
Collaborate with key staff to develop and implement standards and best practices that help ensure agency data repositories support consistent and reusable data.
Promote best-practice knowledge and adoption among business stakeholders to enable self-service analysis rather than IT-owned development.
Own self-service reporting datasets, including DAX measures, data models, and row-level security.
Translate business needs into 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.
Use technical tools to query, manipulate, and summarize data from multiple data sources.
Assist with designing, building, maintaining, and updating databases aligned with 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.
Create 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) and SQL Server along with related components.
Define operational monitoring and alerting tools to ensure trusted, high-quality data moves 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 DQ processes.

Required Qualifications

Bachelor’s degree required
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 (Azure Analysis Service, Azure Data Lake, Azure Synapse Analytics)
Experience integrating or working with EHR data (reports, APIs, or data exports)
Familiarity with star schema / 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 the ability to explain data concepts clearly to non-technical stakeholders

Preferred Skills

Master’s degree highly preferred
Advanced skill set with Microsoft Office suite (Power BI), SQL, and experience with EMR systems (hospice, homecare, and/or mental health) desired

Technology Focus

SQL Server, T-SQL, Power BI, DAX, Power Query
Wherescape OLAP, Wherescape RED
Azure Analysis Service, Azure Data Lake, Azure Synapse Analytics
Python
Microsoft Master Data Services (MDS), Microsoft Data Quality Services (DQS), SQL Server Integration Services (SSIS)
ETL, EHR data, EMR systems
Master data management

View full job page →

Get Azure Analytics Developer Jobs alerts

New Azure Analytics Developer Jobs, daily.