Data Warehouse & Reporting Systems Analyst

Prince George's County, Maryland; Largo (MD); Hybrid; USD 65,000 - 90,000; Full time

Job summary

The Prince George’s County Department of Permitting, Inspections, & Enforcement seeks an experienced System Analyst 1A to design, build, and expand a data warehouse and reporting infrastructure. This hybrid role focuses on turning data into actionable insights through clear reporting.

You will develop data models, pipelines from Infor and ProjectDox, and create dashboards with SSRS and PowerBI, while collaborating with business units to define KPIs and ensure data quality.

Qualifications

• Bachelor's degree in Computer Science, Business Administration or a related field or graduation from a vocational school.
• Possess a valid Driver’s License.
• An equivalent combination of education, experience and training which provides the required knowledge, skills and abilities may be considered.

Responsibilities

• Develop, optimize, and manage data ingestion pipelines from various sources into the data warehouse (Infor, ProjectDox, and other systems).
• Design, build, and deploy meaningful reports, data visualizations, and interactive dashboards using SSRS and PowerBI.
• Collaborate with leaders from business units to understand data needs and define KPIs.
• Monitor data warehouse performance, optimize queries, and ensure efficient data storage and retrieval.
• Maintain data quality, integrity, and security standards across the data warehouse.

Education

Bachelor's degree in Computer Science, Business Administration or a related field

Tools

SSRS

PowerBI

SQL Server

Job description

The Prince George’s County Department of Permitting, Inspections, & Enforcement seeks an experienced System Analyst 1A to design, build, and expand a data warehouse and reporting infrastructure. This hybrid role focuses on turning data into actionable insights through clear reporting.

You will develop data models, pipelines from Infor and ProjectDox, and create dashboards with SSRS and PowerBI, while collaborating with business units to define KPIs and ensure data quality.