Data Engineer (Project Management) - Lansing, MI

DTS is looking for Data Engineer (Project Management) for a direct client position in Lansing, MI 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. Role description:
Senior Data Engineer – Portfolio Reporting and Business Intelligence

Position Summary:

The successful candidate will serve as a technical and analytical resource within the Enterprise Portfolio Management Office (EPMO), supporting the Investment Management and Project and Portfolio Management Support teams within the Portfolio Division. The resource will be responsible for designing, developing, implementing, and maintaining enterprise reporting and business intelligence solutions that enable effective portfolio governance and performance management. Working collaboratively with executive leadership, portfolio managers, project managers, business stakeholders, and technical teams, the Senior Data Engineer will transform data from multiple enterprise systems into actionable business intelligence supporting investment management, project oversight, risk identification, compliance monitoring, and executive decision-making.

While the primary focus of this position will be supporting ITIF-funded initiatives, the resource may also develop reporting and analytical capabilities supporting the broader statewide IT portfolio, Project Portfolio Management (PPM) environment, and Investment Management processes. Position Responsibilities 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…