Data Engineer

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.

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.