Senior Data Engineer #163970

Senior Data Engineer

Duration: 1 year with possible extension
Hybrid: two days a week. Wednesdays and Thursdays are required onsite days.
Lansing Michigan

Senior Data Engineer - Portfolio Reporting and Business Intelligence

Position Summary
Client is seeking an experienced Senior Data Engineer to support statewide
portfolio reporting business intelligence and data analytics for the
State Unified Information Technology Environment (SUITE) Investment
Management program.
DTMB administers the Information Technology Investment Fund (ITIF) a
legislative appropriation that provides funding for critical information
technology modernization cybersecurity innovation and infrastructure
initiatives across State of Michigan agencies. Given the size
visibility and complexity of these investments DTMB requires timely
accurate and actionable reporting to support executive oversight
portfolio governance and informed investment decision-making.
The successful candidate will serve as a technical and analytical
resource within the Enterprise Portfolio Management Office (EPMO)
supporting the SUITE 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 SUITE 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 States 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.

Education
- Bachelors degree in Computer Science Information Systems Data
Science Business Analytics Management Information Systems
Mathematics Statistics Engineering or another closely related
field.
- Equivalent combinations of education technical training
professional certifications and directly related experience may be
considered.

Desired Certifications
The following certifications are preferred but not required:
- 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)
Expected Outcomes
The successful candidate will:
- Strengthen DTMBs oversight of the IT investment management
portfolio through timely accurate and actionable reporting.
- Improve visibility into the health and performance of statewide IT
investments through standardized dashboards and executive reporting.
- Enhance the States ability to identify portfolio risks emerging
trends compliance issues and opportunities for proactive
intervention.
- Reduce manual reporting effort through automation standardized
reporting processes and improved data integration.
- Support informed executive decision-making through high-quality
analytics and business intelligence solutions.
- Establish scalable reporting capabilities that support the ongoing
evolution of the States Project Portfolio Management and Investment
Management programs.

Required Skills:

AZURE DATA FACTORYKANBANMICROSOFT SQL SERVERPROJECT GOVERNANCEMICROSOFT ANALYTICSAGILEAZURE SQLPMI-ACPSQLPMI PMBOKMICROSOFT POWER BIDATA MODELS