DCED - AR1 A4 SC2 (Data Engineer)
Role summary
The Department of Community and Economic Development (DCED) seeks a mid-level Data Engineer for the Pennsylvania Broadband Development Authority (PBDA). This contract role involves leading the development, maintenance, and governance of PBDA data systems, including programmatic, financial, geographic, and performance datasets. The engineer will design and manage data models, schemas, and workflows, establish data standards, and integrate data from multiple systems. Responsibilities include maintaining Power BI dashboards and reports, writing SQL queries for data extraction and analysis, and ensuring analytics products meet stakeholder needs. The position requires solid SQL, basic-intermediate Power BI, general data modeling, data integration, and strong communication skills. Preferred qualifications include DAX optimization, GIS familiarity, data governance concepts, and federal reporting experience.
Engagement Type
Contract Short Description
Please see the complete description.
IT Staff Aug Position for Department of Community and
Economic Development - Pennsylvania Broadband Development Authority
Complete Description
DCED seeks a mid-level Data Engineer.Position is 40 hours a week (part-time telework (2-days remote) & 3-days onsite (5th floor of The Keystone Building, located at 400 North Street, Harrisburg, PA 17120)). Remote days and onsite days set up can be discussed during the in-person interview.
Client would prefer candidates local to the Harrisburg, PA Area.
Position: The Department of Community and Economic
Development is actively seeking a data engineer to serve as the
lead for performance management, analytics, and reporting for the Pennsylvania
Broadband Office. In the role, you will have the opportunity to design,
maintain, and improve the PA Broadband Office's data infrastructure to support
our broadband programs.
Description of Work:
Leads the development, maintenance, and governance of PBDA data systems,
including programmatic, financial, geographic, and performance datasets.
Designs and manages data models, schemas, and workflows to ensure
consistency, accuracy, and reliability across PBDA programs (BIP, BEAD,
Facilities, Technology, and related initiatives).
Establishes and documents data standards, definitions, and quality
controls to support internal operations and external reporting requirements.
Works closely with PBDA staff, DCED partners, IT, and external vendors to
integrate data from multiple systems into centralized, usable formats.
Maintains and updates advanced Power BI dashboards and reports that
communicate program status, performance metrics, financial activity, and
geographic coverage.
Familiar with DAX tools for measures and calculations within Power BI to
support accurate, consistent, and repeatable analytics and reporting.
Writes, optimizes, and maintains SQL queries to extract, transform, and
analyze data from relational databases and enterprise systems.
Ensures analytics products are scalable, repeatable, and aligned with
leadership, board, legislative, and federal stakeholder needs.
Oversees publishing, access controls, and lifecycle management for
analytic products in accordance with Commonwealth data and security policies.
Supports PBDA leadership in identifying performance measures and key
indicators for broadband infrastructure and other programs.
Produces internal and public-facing reports, dashboards, and data
visualizations used for decision-making, transparency, and accountability.
Assists with federal and state reporting requirements, including data
submissions related to program monitoring, compliance, and outcomes.
Collaborates with GIS staff and contractors to ensure alignment between
tabular program data and geographic datasets.
Maintains an awareness of GIS concepts, spatial data structures, and
mapping requirements to support PBDA’s public-facing maps and analyses.
Supports integration of GIS outputs into dashboards, reports, and data
products, without serving as the primary GIS developer.
Serves as a subject-matter expert for PBDA data-related decisions,
advising leadership on data quality, analytics approaches, and reporting
strategies.
Prepares high-level briefings, presentations, and summaries for PBDA
executive leadership, the Authority board, and external stakeholders.
Required: solid SQL, basic-intermediate Power BI, general data modeling,
data integration, communication skills, and comfort working with diverse
datasets.
Preferred: experience with DAX optimization, light GIS familiarity,
data governance concepts, or federal reporting experience.
Optional: advanced GIS, advanced Power BI administration, or programming
languages.
Required/Desired Skills Skill Required/Desired Amount of Experience solid SQL experience Required basic to intermediate Power BI experience Required general data modeling experience Required data integration experience Required exceptional communication skills Required comfort working with diverse datasets Required experience with DAX optimization Desired GIS familiarity Desired data governance concepts Desired federal reporting experience Desired advanced GIS skills Nice to have advanced Power BI administration skills Nice to have programming languages experience Nice to have
