Data Engineer

The Pittsburgh Foundation

Pittsburgh (Allegheny County)

Híbrido

USD 104.000 - 127.000

Jornada completa

hace 38 horas
Sé de los primeros/as/es en solicitar esta vacante

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Descripción de la vacante

The Pittsburgh Foundation is seeking a Data Engineer to lead the design, implementation, and ongoing operation of the organization’s Microsoft Fabric data platform and reporting ecosystem. You will own data ingestion, modeling, governance, platform operations, and Power BI enablement across Salesforce, NetSuite, Foundant, Blackbaud, and future systems.

This full-time hybrid role requires in-person attendance Tue-Thu in PA.

Formación

  • 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.

Responsabilidades

  • 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.

Conocimientos

Data engineering
SQL
Python
Spark
ETL/ELT
Power BI
Dimensional modeling
Data governance
CRM integration
ERP integration
Azure Data Services
Microsoft Fabric
Databricks

Herramientas

Microsoft Fabric
Azure Data Services
Databricks

Descripción del empleo

Reports to: Director of Information Technology

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

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.

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Data Engineer
Data Engineer

The Pittsburgh Foundation • Pittsburgh

Híbrido
USD 104.000 - 127.000
Medical insurance
Dental insurance
Vision insurance
+7
Data Engineer
Data Engineer

Life in Pittsburgh • Pittsburgh

Híbrido
USD 104.000 - 127.000
Medical insurance
Dental insurance
Vision insurance
+10
Data Engineer: Microsoft Fabric & Power BI Lead (Hybrid PA)
Data Engineer: Microsoft Fabric & Power BI Lead (Hybrid PA)

Pittsburgh Tomorrow • Pittsburgh

Híbrido
USD 104.000 - 127.000
Medical insurance
Dental insurance
Vision insurance
+10
Data Platform Engineer - Fabric & Power BI (Hybrid PA)
Data Platform Engineer - Fabric & Power BI (Hybrid PA)

Breathe Project • Pittsburgh

Híbrido
USD 104.000 - 127.000
Medical insurance
Dental insurance
Vision insurance
+7
Hybrid Data Engineer: Fabric & Power BI Lead
Hybrid Data Engineer: Fabric & Power BI Lead

The Pittsburgh Foundation • Pittsburgh

Híbrido
USD 104.000 - 127.000
Data Engineer
Data Engineer

Fracht Group - North America • Houston (TX)

Presencial
USD 140.000 - 190.000
Data Engineer
Data Engineer

Calqulate Metrics Ltd • Pittsburgh

Presencial
USD 90.000 - 130.000
Platform Data Engineer
Platform Data Engineer

360insights • EE. UU.

A distancia
USD 110.000 - 170.000
Data Infrastructure Engineer
Data Infrastructure Engineer

Sterling St James LLC • Pittsburgh

Híbrido
USD 110.000 - 140.000
Data Engineer
Data Engineer

betterdebtsolutions • Irvine (CA)

Presencial
USD 140.000 - 155.000