Data Engineer

Pittsburgh Tomorrow; Pittsburgh (Allegheny County); Ibrido; USD 104.000 - 127.000; Tempo pieno

Vantaggi offerti da questo lavoro

Medical insurance

Dental insurance

Vision insurance

Group life insurance

Disability insurance

Maternity and paternity leave

Flexible spending accounts

Three weeks’ vacation

Ten paid holidays

Retirement plan with employer contrib.

Commuter benefits

Gym reimbursement

Employee assistance program

Descrizione del lavoro

The Pittsburgh Foundation is seeking a data engineer to lead the Microsoft Fabric data platform and reporting ecosystem, overseeing data integration, modeling, governance, and platform operations across Salesforce, NetSuite, Foundant, Blackbaud and future systems.

This role will own data pipelines, dimensional models, Power BI semantic layers, and cost optimization, while collaborating with stakeholders and executive leadership to define KPIs and future data needs in a hybrid work setting based

Competenze

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

Mansioni

• Own operations and long-term direction of the Fabric platform.
• Design and maintain data ingestion pipelines from enterprise apps.
• Develop data transformation logic and orchestration processes.
• Manage staging, integration, and reporting layers.
• Design dimensional models and star schemas for enterprise reporting.
• Build and optimize Power BI models, reports, and dashboards.
• Implement data quality monitoring and anomaly handling.
• Define data governance, lineage, and security within Fabric.
• Lead cross-department data initiatives and KPI definition.
• Evaluate new data sources and onboard into Fabric.
• Perform capacity monitoring and cost optimization.
• Maintain platform documentation and runbooks.
• Support advanced analytics and Copilot-enabled use cases.
• Serve as escalation point for data warehouse issues.

Conoscenze

Communication

Diversity & inclusion

Problem solving

Learning mindset

Independent work

Translate complex problems

Strumenti

Microsoft Fabric

Azure Data Services

Databricks

Power BI

SQL

Python

Spark

ETL/ELT

Data governance

Descrizione del lavoro

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

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, EQUITY AND INCLUSION.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Group life insurance
• Disability insurance
• Maternity and paternity leave
• Flexible spending accounts
• Three weeks’ vacation
• Ten paid holidays
• Retirement plan with employer contribution
• Commuter benefits
• Gym reimbursement
• Employee assistance program

ABOUT THE PITTSBURGH FOUNDATION

OUR MISSION: The Pittsburgh Foundation, established in 1945, works to improve the quality of life in the Pittsburgh region by evaluating and addressing community issues, promoting responsible philanthropy and connecting donors to the critical needs of the community.

OUR VISION: We commit to creating a vibrant, equitable and just Pittsburgh Region that supports everyone, regardless of race, identity or circumstance- to thrive and fulfill their potential.

OUR VALUES: Since its founding in 1945, The Pittsburgh Foundation's values have been evident in the deep relationships its people have forged in the region. As new strategies are developed to improve quality of life for everyone, the staff has identified these values and pledged to follow them in the work.

• Accountability
• Collaboration
• Community
• Racial Justice
• Trust

Learn more at www.pittsburghfoundation.org.