Hybrid Data Warehouse & Reporting Analyst

Prince George's County Government

Largo (MD)

Hybrid

USD 65,000 - 110,000

Full time

7 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Prince George's County Government seeks an experienced System Analyst to design, build, and maintain a scalable reporting infrastructure, evolving it into a comprehensive data warehouse. You will collaborate with business units to translate data into actionable insights through clear reporting and dashboards using SQL Server Reporting Services (SSRS) and Power BI.

The role blends deep data modeling with hands-on development, requiring partnership to define KPIs and deliver meaningful

Qualifications

Bachelor's degree in CS, Business Administration, or a related field.
Valid Driver’s License.
Equivalent combination of education, experience and training may be considered.

Responsibilities

Assist Performance Officer in developing scalable data models for business needs.
Analyze and evaluate new and existing programs.
Develop, optimize, and manage data ingestion pipelines into the data warehouse from Infor, ProjectDox, and other systems.
Monitor data warehouse performance, optimize queries, and ensure efficient data storage and retrieval.
Plan and execute expansion of the data warehouse, integrating new data sources.
Use statistical tools to identify patterns, trends, and anomalies in data.
Implement and enforce data quality, integrity, and security standards.
Collaborate with business units to define KPIs and data needs.
Design, build, and deploy reports and dashboards using SSRS and Power BI.
Translate complex analytics into clear recommendations for non-technical audiences.
Maintain and support existing reports for data accuracy and timeliness.