Data Engineer

Reports to: Director of Information Technology
Position Status: Full-Time/Exempt
Location: Hybrid, in-person attendance required Tu-Th, must live in PA
Starting Salary: $115,000

Back to Careers page

POSITION SUMMARY

The data engineer is responsible for the support, administration, enhancement, architecture and long-term strategic direction of The Pittsburgh Foundation's (TPF) Microsoft Fabric data platform and reporting ecosystem. This individual will lead data integration, data modeling, governance, platform operations and Power BI enablement while ensuring the organization maintains a trusted enterprise data foundation across Salesforce, NetSuite, Foundant, Blackbaud and future strategic systems.

PRIMARY DUTIES AND RESPONSIBILITIES

• Own day-to-day operations, technical architecture, and long-term direction of the Microsoft Fabric platform, including OneLake, Lakehouse, Warehouse, Data Factory, Notebooks and Semantic Models.
• Design, develop and maintain data ingestion pipelines from enterprise applications.
• Develop and support data transformation logic, orchestration processes, and enterprise data models.
• Manage and optimize staging, integration, curated (gold) and reporting layers.
• Design and maintain dimensional models and star schemas to support enterprise reporting and analytics.
• Build, maintain, and optimize Power BI semantic models, reports, dashboards and data products.
• Implement data quality monitoring, reconciliation controls, exception handling and operational alerting.
• Independently establish and make decisions regarding data governance, platform standards, integrations, technical solutions, lineage, security and access management within Fabric.
• Lead significant cross-departmental data initiatives and partner with business stakeholders and TPF's executive leadership team to define KPIs, conduct data analysis, establish reporting requirements and plan for future data needs.
• Evaluate new data sources and lead onboarding activities into the Fabric platform.
• Perform capacity monitoring, performance tuning and cost optimization.
• Develop and maintain platform documentation, runbooks, support procedures and technical standards.
• Support advanced analytics, AI and Copilot-enabled use cases as the platform matures.
• Serve as the primary technical escalation point for data warehouse and reporting issues.

KEY SKILLS AND ABILITIES

• Proven ability to work successfully with diverse populations and demonstrated commitment to promote and enhance diversity, equity and inclusion.
•  Commitment to the Foundation’s values of accountability, collaboration, community, racial justice and trust.
• Excellent communication and organization skills.
• Ability to work well with all levels of internal management and staff, as well as outside vendors.
• Excellent customer service approach and problem-solving skills.
• Self-starter with a learning mindset along with the ability to work independently and in a team environment.
• Ability to translate complex business problems into simplified workflows, increasing efficiencies through an appropriate application of technology.

QUALIFICATIONS AND EXPERIENCE

• 4+ years of experience in data engineering or analytics engineering.
• Hands-on experience with Microsoft Fabric, Azure Data Services or Databricks.
• Strong SQL, Python, Spark, and ETL/ELT development skills.
• Experience building dimensional models, semantic layers and enterprise reporting platforms.
• Advanced Power BI development and administration experience.
• Knowledge of data governance, data quality and master data management practices.
• Experience integrating CRM, ERP and financial systems into enterprise data platforms.

THE PITTSBURGH FOUNDATION IS AN EQUAL OPPORTUNITY EMPLOYER COMMITTED TO DIVERSITY AND INCLUSION.

Learn more about:

 our mission and values    employee benefits