Senior Data Engineer

Position Responsibilities

The Senior Data Engineer will perform duties including, but not limited to, the following:

Portfolio Reporting and Business Intelligence

• Design, develop, implement, and maintain enterprise dashboards, executive scorecards, and business intelligence solutions supporting IT investment management.

• Develop standardized portfolio reporting to support IT investments, project performance, portfolio governance, and executive oversight.

• Design meaningful Key Performance Indicators (KPIs), portfolio metrics, and visualizations that clearly communicate organizational performance and portfolio health.

• Develop automated reporting processes that improve reporting accuracy, consistency, and timeliness.

• Produce recurring and ad hoc executive reports for organizational leadership, governance bodies, and business stakeholders.

Data Engineering and Integration

• Design, develop, and maintain data pipelines that integrate information from the organization’s Project Portfolio Management (PPM) platform, business intelligence environment, financial systems, governance repositories, and other enterprise data sources.

• Develop, optimize, and maintain complex SQL queries, data models, and data transformation processes.

• Design scalable data models that support enterprise reporting and analytical capabilities.

• Ensure data quality, consistency, integrity, and reliability across reporting environments.

• Recommend improvements to the enterprise data architecture supporting investment management and portfolio reporting.

Portfolio Analytics

• Analyze project, portfolio, financial, schedule, resource, governance, and operational data to identify trends, risks, opportunities, and emerging issues.

• Assess project health, risk management effectiveness, deliverable quality, and compliance with applicable standards and governance requirements.

• Perform root-cause analysis to identify systemic portfolio issues and recommend corrective actions.

• Identify risks and opportunities that require escalation to portfolio management and executive leadership.

• Develop predictive and trend-based reporting to support proactive portfolio management and investment decision-making.

Business Analysis and Stakeholder Engagement

• Facilitate meetings with business stakeholders to identify reporting requirements, performance measures, and analytical needs.

• Gather, analyze, and document business and technical requirements for enterprise reporting solutions.

• Translate business requirements into technical reporting, dashboard, and data solutions.

• Recommend reporting strategies, visualization approaches, and analytical solutions that improve executive decision-making.

• Document business requirements, technical specifications, data definitions, metadata, and reporting standards.

Continuous Improvement

• Identify opportunities to automate manual reporting activities and improve reporting efficiency.

• Recommend enhancements to portfolio reporting processes, governance metrics, and business intelligence capabilities.

• Support the development and maintenance of enterprise reporting standards for project and investment management.

• Participate in continuous improvement initiatives supporting organizational methodologies, investment management practices, and enterprise reporting capabilities.

• Provide knowledge transfer, documentation, and technical guidance to internal staff to support long-term sustainability.

Minimum Requirements

The selected candidate must possess:

• A minimum of three years, preferably four to seven years, of professional experience in data engineering, business intelligence, data analytics, or a related information technology discipline.

• Demonstrated experience designing, developing, implementing, and maintaining enterprise reporting and business intelligence solutions.

• Experience integrating, transforming, and analyzing data from multiple enterprise systems using SQL and modern data engineering techniques.

• Experience developing interactive dashboards, scorecards, and executive reports using Microsoft Power BI or a comparable business intelligence platform.