Business Intelligence Analyst

State of Maryland•Baltimore City, MD

6d•Onsite

About The Position

The Business Intelligence Analyst will design, develop, and oversee reporting, data, and analytics solutions for the LTSSMaryland system to support program operations, policy decisions, and business oversight. The role plans, designs, develops, and integrates system improvements and applications, and serves as the primary authority for LTSS ad hoc reporting, data definitions, and reporting standards to ensure accuracy, consistency, and usability across business units. The analyst leads the modernization of LTSSMaryland reporting by transitioning legacy SSRS/SSAS reporting to a modern business intelligence and data analytics platform. The role translates stakeholder business needs into usable report requirements and supports reporting needs while improving data scalability, performance, and accessibility for LTSS business stakeholders. The position may also support, consult on, or be responsible for projects within the Medicaid IT project ecosystem as assigned.

Requirements

Seven years of experience designing, developing, testing, implementing, and maintaining application, communication, database, or operating systems software.
Qualifying education and experience substitutions are available, including specified college coursework, an IT-related bachelor's degree combined with three years of relevant experience, certain computer operations experience, or qualifying U.S. Armed Forces experience.

Nice To Haves

Experience leading or supporting migration to a modern BI platform, such as Power BI, Tableau, or cloud analytics.
Experience working with Medicaid or the MDH LTSSMaryland System.
Strong SQL and data modeling skills.
Experience with SSRS/SSAS or similar legacy tools.
Experience consolidating, standardizing, and retiring reports in large environments.
Familiarity with data dictionaries, data lineage, and governance practices.

Responsibilities

Design and deliver ad hoc and recurring reports, ensuring accuracy, timeliness, and alignment with business rules.
Partner with stakeholders to gather requirements, refine needs, and translate data into clear insights and recommendations.
Lead planning, design, and implementation of the transition from legacy SSRS/SSAS reporting to a modern BI platform for LTSSMaryland.
Oversee report migration by assessing existing reports, consolidating or retiring them where appropriate, and ensuring accuracy after migration.
Maintain and standardize data structures, definitions, and reporting logic, including data dictionaries and data lineage.
Establish and enforce reporting standards, validation checks, and quality controls.
Monitor report usage and performance to identify improvements and reduce redundancy.
Provide guidance, documentation, and support to improve adoption and effective use of reporting tools.
Coordinate with vendors and internal teams to deliver reporting and analytics solutions aligned with business needs.
Support, consult on, or take responsibility for Medicaid IT ecosystem projects as assigned.