Search Jobs | Dice.com

Job Details

Skills

SQL
Power BI
Business Intelligence
Data Analytics
Clarity
Data Engineering
Azure Data Factory
PLANVIEW
ServiceNow PPM
Microsoft Fabric

Summary

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.

Minimum Requirements

The selected candidate must possess:

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.
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 reporting using Microsoft Power BI or comparable business intelligence platforms.
Experience gathering, analyzing, and documenting business requirements and translating those requirements into technical reporting and analytical solutions.
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.
Strong analytical and problem-solving skills with demonstrated experience performing root cause analysis, identifying trends, and making data-driven recommendations.
Experience developing and optimizing SQL queries, data models, and data transformation processes.
Excellent written and verbal communication skills with the ability to communicate technical information effectively to both technical and non-technical audiences.
Demonstrated ability to work independently while managing multiple assignments, priorities, and stakeholder expectations.

Preferred Qualifications

Preference will be given to candidates with experience in one or more of the following:

Project Portfolio Management (PPM) systems such as Clarity, ServiceNow PPM, Planview, Microsoft Project Online, or similar enterprise portfolio management platforms.
Portfolio management, investment management, project governance, or executive portfolio reporting.
Microsoft Power BI, Microsoft Fabric, Azure Data Factory, Azure SQL, Microsoft SQL Server, or comparable Microsoft analytics technologies.
Enterprise data warehousing, semantic models, or business intelligence architecture.
Developing automated reporting solutions using APIs, ETL processes, scripting languages, or data integration platforms.
Government, public sector, or other large enterprise reporting environments.
Project management methodologies including PMI PMBOK, Agile, Scrum, Kanban, or SAFe.
Financial management, capital investment management, or portfolio performance reporting.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91071031
Position Id: 2026-14829
Posted 2 hours ago

Sr Senior Data Engineer

Hybrid in Lansing, Michigan

•

Today

Hi, Greetings from DIA SOFTWARE SOLUTIONS LLC! We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position? Direct client Req:: Need Senior Data Engineer ,Hybrid, MI PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM ! Job Description: Senior Data Engineer Portfolio Reporting and Business Intelligence Position Summary Portfolio Reporting and Business Intelligence Design,

Easy Apply

Contract, Third Party

Depends on Experience

Filter Results

Job post features

Posted date

Work settings

Employment type

Distance

Employer type

Work authorization

EPMO - Portfolio - Senior Data Engineer

Skills

Summary

Dice Job Match Score™

Similar Jobs

EPMO - Portfolio - Senior Data Engineer

Job Details

Skills

Summary

Dice Job Match Score™

Similar Jobs