Data Engineer

Mbi Llc

Harrisburg (Dauphin County)

On-site

USD 80,000 - 100,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading data management firm in Harrisburg is seeking a data systems manager to oversee the development and governance of PBDA data systems. The role includes designing data models, managing dashboards, and ensuring data quality for internal and external reporting. Candidates should possess solid SQL experience and familiarity with Power BI. This position involves strategic collaboration with various stakeholders to enhance data analytics and compliance efforts, contributing to significant broadband initiatives.

Qualifications

Solid SQL experience for data extraction and analysis.
Basic to intermediate skills in Power BI for dashboard management.
Data modeling skills required for ensuring data integrity.

Responsibilities

Lead the development and governance of PBDA data systems.
Design and manage data models and workflows for consistency.
Produce reports and visualizations for decision-making.

Skills

Solid SQL experience

Basic to intermediate Power BI experience

General data modeling and data integration skills

Exceptional communication skills

Comfort working with diverse datasets

Tools

Power BI

DAX

SQL

GIS

Job description

Responsibilities

Lead the development, maintenance, and governance of PBDA data systems, including programmatic, financial, geographic, and performance datasets.
Design and manage data models, schemas, and workflows to ensure consistency, accuracy, and reliability across PBDA programs (BIP, BEAD, Facilities, Technology, and related initiatives).
Establish and document data standards, definitions, and quality controls to support internal operations and external reporting requirements.
Work closely with PBDA staff, DCED partners, IT, and external vendors to integrate data from multiple systems into centralized, usable formats.
Maintain and update advanced Power BI dashboards and reports that communicate program status, performance metrics, financial activity, and geographic coverage.
Use DAX tools for measures and calculations within Power BI to support accurate, consistent, and repeatable analytics and reporting.
Write, optimize, and maintain SQL queries to extract, transform, and analyze data from relational databases and enterprise systems.
Ensure analytics products are scalable, repeatable, and aligned with leadership, board, legislative, and federal stakeholder needs.
Oversee publishing, access controls, and lifecycle management for analytic products in accordance with Commonwealth data and security policies.
Support PBDA leadership in identifying performance measures and key indicators for broadband infrastructure and other programs.
Produce internal and public-facing reports, dashboards, and data visualizations used for decision‑making, transparency, and accountability.
Assist with federal and state reporting requirements, including data submissions related to program monitoring, compliance, and outcomes.
Collaborate with GIS staff and contractors to ensure alignment between tabular program data and geographic datasets.
Maintain an awareness of GIS concepts, spatial data structures, and mapping requirements to support PBDA’s public‑facing maps and analyses.
Support integration of GIS outputs into dashboards, reports, and data products, without serving as the primary GIS developer.
Serve as a subject‑matter expert for PBDA data‑related decisions, advising leadership on data quality, analytics approaches, and reporting strategies.
Prepare high‑level briefings, presentations, and summaries for PBDA executive leadership, the Authority board, and external stakeholders.