Top Skills & Years of Experience:
- Candidates MUST have strong project management reporting & portfolio analytics experience
- A minimum of three (3), and preferably four to seven (4 7) years, of professional experience in data engineering, business intelligence, data analytics, or a related information technology discipline.
- Experience integrating, transforming, and analyzing data from multiple enterprise systems using SQL and modern data engineering techniques.
- Experience developing interactive dashboards, scorecards, and executive reporting using Microsoft Power BI or comparable business intelligence platforms.
- Experience working directly with business stakeholders to define reporting requirements, key performance indicators (KPIs), and performance measures.
Demonstrated experience analyzing portfolio, project, financial, operational, or governance data to support executive decision-making.
Education: Bachelor's degree in Computer Science, Information Systems, Data Science, Business Analytics, Management Information Systems, Mathematics, Statistics, Engineering, or another closely related field.
Clear and concise written and verbal communication is crucial to success and productivity in this role.
Preferred Skills
One or multiple of the following certifications: Microsoft Certified: Power BI Data Analyst Associate Microsoft Certified: Fabric Analytics Engineer Associate Microsoft Azure Data Engineer Associate Microsoft Azure Database Administrator Associate Certified Business Intelligence Professional (CBIP) Project Management Professional (PMP) PMI Agile Certified Practitioner (PMI-ACP) Certified Data Management Professional (CDMP)
The Senior Data Engineer shall 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 statewide IT investment management.
- Develop standardized portfolio reporting supporting ITIF investments, project performance, portfolio governance, and executive oversight.
- Design meaningful Key Performance Indicators (KPIs), portfolio metrics, and visualizations that communicate organizational performance and portfolio health.
- Develop automated reporting processes that improve reporting accuracy, consistency, and timeliness.
- Produce recurring and ad hoc executive reports supporting DTMB leadership, governance bodies, and agency stakeholders.
Data Engineering and Integration
- Design, develop, and maintain data pipelines integrating information from the State'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 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 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 requiring escalation to the EPMO and DTMB executive leadership.
- Develop predictive and trend-based reporting supporting 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 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 portfolio reporting processes, governance metrics, and business intelligence capabilities.
- Support development and maintenance of statewide reporting standards supporting project management and investment management.
- Participate in continuous improvement initiatives supporting the SUITE methodology, Investment Management program, and enterprise reporting capabilities.
- Provide knowledge transfer, documentation, and technical guidance to State staff supporting long-term sustainability.
Never miss an opportunity! Create an alert based on the job you applied for.