Overview

Job Title: Senior Data Engineer - Business Intelligence & Portfolio Reporting Overview / Summary We are seeking an experienced Senior Data Engineer to support enterprise portfolio reporting, business intelligence, and data analytics for an investment management program. This role is responsible for designing, developing, implementing, and maintaining enterprise reporting and business intelligence solutions that support portfolio governance, performance management, and executive decision-making. The successful candidate will collaborate with executive leadership, portfolio managers, project managers, business stakeholders, and technical teams to transform data from multiple enterprise systems into actionable insights supporting investment management, project oversight, risk identification, compliance monitoring, and portfolio performance. The role also supports the development of reporting and analytical capabilities for broader project portfolio management and investment management processes. Key Responsibilities Portfolio Reporting & Business Intelligence Design, develop, implement, and maintain enterprise dashboards, executive scorecards, and business intelligence solutions. Develop standardized portfolio reporting supporting investment management, project performance, portfolio governance, and executive oversight. Design key performance indicators (KPIs), portfolio metrics, and visualizations that communicate portfolio health and organizational performance. Develop automated reporting processes to improve reporting accuracy, consistency, and timeliness. Produce recurring and ad hoc executive reports for leadership, governance bodies, and stakeholders. Data Engineering & Integration Design, develop, and maintain data pipelines integrating information from project portfolio management platforms, business intelligence environments, financial systems, governance repositories, and other enterprise data sources. Develop, optimize, and maintain complex SQL queries, data models, and transformation processes. Design scalable data models supporting enterprise reporting and analytics. Ensure data quality, consistency, integrity, and reliability across reporting environments. Recommend improvements to enterprise data architecture supporting portfolio reporting and investment management. 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 governance requirements. Perform root cause analysis to identify systemic portfolio issues and recommend corrective actions. Identify risks and opportunities requiring escalation to leadership. Develop predictive and trend-based reporting to support proactive portfolio management and investment decision-making. Business Analysis & 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 and dashboard 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 reporting processes, governance metrics, and business intelligence capabilities. Support development and maintenance of enterprise reporting standards supporting project and investment management. Participate in continuous improvement initiatives supporting reporting and investment management processes. Provide knowledge transfer, documentation, and technical gu