BUSINESS INTELLIGENCE ANALYST IT SYSTEMS TECHNICAL SPECIALIST

State of Maryland; Maryland; Sur place; USD 90 000 - 120 000; Plein temps

Résumé du poste

State of Maryland’s LTSSMaryland program needs a seasoned BI Analyst to design, develop, and oversee reporting and analytics solutions. You will drive the modernization of legacy SSRS/SSAS reporting into a scalable BI platform, enabling accurate, timely insights for policy decisions and operations.

You’ll partner with stakeholders to gather requirements, establish data dictionaries and governance, and mentor teams on best practices in reporting and data quality across MDH’s LTSSMaryland

Qualifications

• Seven years of experience designing, developing, testing, implementing and maintaining software systems.
• Experience leading or supporting migration to a modern BI platform (Power BI, Tableau, cloud analytics).
• Strong SQL and data modeling skills.
• Experience with SSRS/SSAS or similar legacy tools.
• Experience consolidating, standardizing, and retiring reports in large environments.

Responsabilités

• 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 the transition from legacy reporting tools (SSRS/SSAS) to a modern BI platform, including planning, design, and implementation for LTSSMaryland system.
• Oversee report migration: assess current reports, consolidate or retire where needed, and ensure accuracy post-migration.
• Maintain and standardize data structures, definitions, and reporting logic (e.g., data dictionary, 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.

Connaissances

SQL

Data modeling

BI platform migration

Reporting standards

Data dictionary

Formation

Bachelor’s degree (not required)

Outils

SSRS/SSAS

Power BI

Tableau

Description du poste

Agency Mission

Maryland's health depends on great technology.

Help us build it.

OET is the engine behind MDH - one team driving innovation across every department serving Maryland's most vulnerable residents.

Introduction

Agency Mission

Maryland's health depends on great technology.

Help us build it.

OET is the engine behind MDH - one team driving innovation across every department serving Maryland's most vulnerable residents.

We're looking for Technologists ready to reimagine how public health works.

That’s our mission - backed by benefits and a team serious about getting it right.

Your Skills. Maryland's Health. Let’s Build It Together.

GRADE

STD0021

LOCATION OF POSITION

MDH Office of Enterprise Technology (OET)

201 W. Preston Street

Baltimore, MD 21201

Main Purpose of Job

This full-time Business Intelligence Analyst position will design, develop, and oversee reporting, data, and analytics solutions for the LTSSMaryland system that supports program operations, policy decisions, and business oversight. This position will plan, design, develop, and integrate system improvements and applications. This position will also serve as the primary authority for LTSS ad hoc reporting, data definitions, and reporting standards to ensure accuracy, consistency, and usability across business units. Furthermore, this position will take lead in supporting LTSSMaryland stakeholders by translating business needs into usable report requirements.

This role leads the modernization of LTSSMaryland reporting by transitioning legacy SSRS/SSAS reporting to a modern business intelligence and data analytics platform. This position also ensures business reporting needs are met while improving scalability, performance, and accessibility of data for LTSS business stakeholders.

Additionally, this position supports, consults, and may be responsible for projects within the Medicaid IT project ecosystem as assigned.

POSITION DUTIES

• 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 the transition from legacy reporting tools (SSRS/SSAS) to a modern BI platform, including planning, design, and implementation for the LTSSMaryland system.
• Oversee report migration: assess current reports, consolidate or retire where needed, and ensure accuracy post-migration.
• Maintain and standardize data structures, definitions, and reporting logic (e.g., data dictionary, 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.

Minimum Qualifications

Applicants must meet the minimum qualification(s) to be considered. Include clear and specific information on your application regarding your qualifications.

Experience : Seven years of experience designing, developing, testing, implementing and maintaining application, communication, database or operating systems software.

Notes

• Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate and thirty credit hours from an accredited college or university in Computer Science, Computer Technology, Management Information Systems or other information technology-related field to include coursework in application, communication, database or operating systems software technology for four years of the required experience.
• Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate and one year of experience designing, developing, testing, implementing and maintaining application, communication, database or operating systems software for four years of the required experience.
• Candidates may substitute experience operating computer systems; or scheduling, controlling input and output to process data on computer systems; or evaluating, implementing and maintaining computer hardware and software; or converting data from project specifications by developing program code using generally accepted computer programming languages on a year-for-year basis for a high school education.
• Candidates may substitute the possession of a Bachelor's degree from an accredited college or university in Computer Science, Computer Information Technology, Management Information Systems or other information technology-related field to include coursework in application, communication, database or operating systems software technology and three years of experience designing, developing, testing, implementing and maintaining application, communication, database or operating systems software for the required experience.
• Candidates may substitute U.S. Armed Forces military service experience as a commissioned officer in the Computer Systems Operations classifications or Computer Systems Operations specialty codes in the Information Technology field of work on a year-for-year basis for the required experience.

Desired Or Preferred Qualifications

• Experience leading or supporting migration to a modern BI platform (e.g., Power BI, Tableau, cloud analytics).
• Experience working with the 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.
• Experience and familiarity with data dictionaries, data lineage, and governance practices.

SELECTION PROCESS

Applicants who meet the minimum (and selective) qualifications will be included in further evaluation. The evaluation may be a rating of your application based on your education, training and experience as they relate to the requirements of the position. Therefore, it is essential that you provide complete and accurate information on your application. Please report all related education, experience, dates and hours of work. Clearly indicate your college degree and major on your application, if applicable. For education obtained outside the U.S., any job offer will be contingent on the candidate providing an evaluation for equivalency by a foreign credential evaluation service prior to starting employment (and may be requested prior to interview).

Complete applications must be submitted by the closing date. Information submitted after this date will not be added.

Incorrect application forms will not be accepted. Resumes will not be accepted in lieu of a completed application.

Candidates may remain on the certified eligible list for a period of at least one year. The resulting certified eligible list for this recruitment may be used for similar positions in this or other State agencies.

Benefits

People with disabilities and bilingual candidates are encouraged to apply.

As an equal opportunity employer, Maryland is committed to recruitment, retaining and promoting employees who are reflective of the State's diversity.