Data Engineer (Hybrid - Local To Pennsylvania)

Position: Mid-Level Data Engineer Interview Type: In-person interview required Work Schedule: 40 hours per week, hybrid role with 2 days remote and 3 days onsite. Remote and onsite schedule can be discussed during the in-person interview. Location: Harrisburg, PA Position Overview We are seeking a Data Engineer to serve as the lead for performance management, analytics, and reporting for broadband-related programs. This role will focus on designing, maintaining, and improving data infrastructure to support program operations, reporting, and decision-making. Description of Work • Lead the development, maintenance, and governance of data systems, including programmatic, financial, geographic, and performance datasets. • Design and manage data models, schemas, and workflows to ensure consistency, accuracy, and reliability across multiple programs and initiatives. • Establish and document data standards, definitions, and quality controls to support internal operations and external reporting requirements. • Work closely with internal staff, partner teams, IT, and external vendors to integrate data from multiple systems into centralized and usable formats. • Maintain and update advanced Power BI dashboards and reports that communicate program status, performance metrics, financial activity, and geographic coverage. • Use DAX 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 data and security policies. • Support leadership in identifying performance measures and key indicators for broadband infrastructure and related 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 awareness of GIS concepts, spatial data structures, and mapping requirements to support 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 data-related decisions, advising leadership on data quality, analytics approaches, and reporting strategies. • Prepare high-level briefings, presentations, and summaries for executive leadership, boards, 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 Desired Skills • Experience with DAX optimization • GIS familiarity • Data governance concepts • Federal reporting experience Nice to Have • Advanced GIS skills • Advanced Power BI administration skills • Programming languages experience