Azure Analytics Engineer 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

Drive end-to-end BI and data engineering for agency analytics solutions in a hybrid role split between Power BI delivery and hands-on engineering.

Responsibilities

Partner with IT business teams and operational leaders to design analyses that support improvement in care, assess adherence to clinical best practice, and measure outcomes
Collaborate with key staff to develop, implement, and guide standards and best practices so agency data repositories produce consistent, reusable data
Enable business stakeholders to self-serve analytics by promoting best-practice knowledge and supporting adoption patterns that reduce 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 across the agency
Use technical tools to query, manipulate, and summarize data from multiple data sources
Assist with designing, developing, maintaining, and updating databases aligned to 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 the agency data blueprint
Manage and support the data warehouse solution including Wherescape RED and SQL Server (plus associated components listed in the technologies stack)
Define operational monitoring and alerting tools to ensure trusted, high-quality data delivery from source systems through 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; define data quality standards and operational DQ 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: 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 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 reporting
Strong communication skills, including explaining data concepts clearly to non-technical stakeholders
Advanced Microsoft Office skills (including Power BI), plus SQL; experience with EMR systems (hospice, homecare, and/or mental health) desired

Technologies

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

Job Details

Location: Rockville, MD (hybrid)
Salary: USD 110,000 - 132,000 per year
Pay Type: Salary

View full job page →

Get Azure Analytics Engineer Jobs alerts

New Azure Analytics Engineer Jobs, daily.