Business Intelligence Engineer

CMT Services Inc•Baltimore, MD

1d•Hybrid

About The Position

Maryland Department of Health is creating an Enterprise Data Platform (EDP) to build a central Data warehouse/data lake with data across multiple programs. We are seeking a Business Intelligence Engineer (BIE) to design and build dashboards and reports using Amazon QuickSight. The BIE will be knowledgeable with the data in the reporting layer in QuickSight. This role requires working with the Business Owners/Stakeholders to define KPIs, reports, dashboards, and reusable visualization patterns. This role may support other projects or teams within MDH as needed.

Requirements

The proposed candidate must have a minimum of three (3) years of experience as a BI Developer.
The candidate should have experience as a BI developer or similar role with a strong understanding of data modeling and ETL processes.
The candidate should be proficient in SQL and experience with BI tools/software.
They should possess a strong understanding of data warehouse, data lakehouse, and data mart concepts.
A bachelor's or master's degree from an accredited college or university with a major in computer science, statistics, mathematics, economics, or related field.
Three (3) years of equivalent experience in a related field may be substituted for the bachelor’s degree.

Nice To Haves

5+ years in BI/Analytics Engineering roles with a focus on dashboarding and KPI design.
2+ years hands-on building Amazon QuickSight dashboards at scale (SPICE datasets, RLS, parameters/controls, custom actions, usage & cost optimization).
Strong SQL and dimensional modeling concepts for analytics consumption (star/snowflake, semantic layers) with performance-aware design.
Experience connecting QuickSight to Athena, Redshift, S3 (Parquet/Iceberg), Health Lake and operating as an analytics consumer under Lake Formation/IAM.
Demonstrated ability to define KPIs and produce executive and operational dashboards with clear narratives and drill paths.
Familiarity with healthcare/public sector data and privacy/security practices (HIPAA).
Excellent communication, stakeholder management, and documentation skills.

Responsibilities

Responsible for developing and operating business intelligence (BI) platforms, tools, and reports.
Design, develop and maintain BI solutions, extract, transform, load (ETL) processes, and dashboards.
Gather and analyze requirements from stakeholders to ensure the BI solution meets needs.
Develop data models to support reporting and analytics.
Implement ETL processes to analyze data from various source systems and data formats.
Create interactive dashboards, reports, and visualizations.
Collaboration with multiple teams to understand requirements and objectives.
Administer testing and troubleshooting.
Create and update documentation.
Stakeholder Engagement Lead requirements discovery with stakeholders across programs
Facilitate wireframing, prototyping, and user testing
Define, Design and maintain metric definitions, dashboards and reports with business logic ensuring clear lineage.
QuickSight Development & Governance Build and manage QuickSight analyses and dashboards, controls/parameters, custom actions, alerts, and exports.
Create and maintain QuickSight datasets (SPICE/direct query) sourced from curated tables provided by Data Engineering team; manage refresh schedules and SPICE capacity.
Implement Row-Level Security (RLS) and column-level restrictions; manage users, groups, folders, queries, refreshes, and visuals for performance; monitor usage with and permissions aligned to least-privilege IAM.
Establish dashboard standards for layout, color/contrast, drill paths, and mobile views; maintain versioning and release notes.
Data Modeling for Reporting Collaborate with Data Engineers on semantic-ready, dimensional models (star/snowflake) that support reusable metrics and performant SPICE.
Specify data contracts, acceptance criteria, and validation rules for each dataset consumed by QuickSight.
Perform QA on datasets and visuals; reconcile metrics against source-of-truth reports.
Performance, Cost & Reliability Tune dataset QuickSight and CloudWatch metrics.
Optimize SPICE capacity, usage tiers, and schedules for cost-effectiveness; recommend right-sizing.
Establish error handling and runbooks for dataset failures and broken visuals.
Security, Compliance & Auditability Enforce HIPAA-aligned practices for PHI/PII in dashboards and exports; coordinate with security on IAM, Lake Formation access (consumer side), and audit trails.
Support agency interoperability and program contexts by ensuring definitions align to each domain's processes.
Enablement & Documentation Produce authoring guides, style kits, and QuickSight templates to enable self‐service for analysts and power users.