Data Engineer

• 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 Skills:

• Solid SQL experience
• Basic to intermediate Power BI experience
• General data modeling experience
• Data integration experience
• Exceptional communication skills
• Comfort working with diverse datasets

Preferred Skills:

• Experience with DAX optimization
• Light GIS familiarity
• Data governance concepts
• Federal reporting experience

Optional Skills:

• Advanced GIS skills
• Advanced Power BI administration skills
• Programming languages experience