À propos
CMT Services Inc. is a dynamic and small business supporting Federal, State, and Local government agencies. As an SBA-certified HUBZone, Woman Owned Small Business (WOSB), we deliver quality, professional services to support the missions and strategic business goals of our clients. Position Title: Business Intelligence Engineer Location: Baltimore City, MD Department: Maryland Department of Health Period of Performance: Primary place of performance is HYBRID with 40% onsite requirement in Baltimore City, MD. One week per month onsite is required. On-site attendance may also be required during system rollout activities in addition to the monthly requirement. May require travel to other offices as needed. The candidate shall provide their own transportation and must abide by all State of Maryland security policies. Position Summary: 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. General Experience: The proposed candidate must have a minimum of three (3) years of experience as a BI Developer. Essential Functions: 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. Role and Responsibilities: 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. Specialized Experience: 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. Education / Experience & Other Minimum Qualifications Required: 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. Join Our Team: At CMT Services, we believe that extraordinary results come from empowering exceptional people. If you're ready to lead innovative projects, solve complex challenges, and contribute to meaningful infrastructure development while advancing your career in a supportive, collaborative environment, we want to hear from you. Disclaimer: By submitting your resume for this job posting, you authorize CMT Services, Inc. to forward your resume to all applicable internal and external managers, agencies, and recruitment personnel for review and consideration to hire.
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.