Data Engineer
*Local to Harrisburg, PA preferred
*This is a hybrid position with 3 days/week onsite
Description:
- The client 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.
Responsibilities:
- 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, the client, 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 PBDAs 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/Knowledge/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
Proper email communication will only be done to and from @astyra.com email addresses. Please ensure you are communicating with approved Astyra recruiters by checking this point when receiving offers and messages from us. Please ensure you are communicating within these guidelines and proper channels for the quickest possible interview consideration!
#AC