About the role

Back to Jobs Senior Data Engineer - Hybrid Lansing, MI Long term w2 or c2c Apply to this Job Description ***Interview Mode :- WebCam Interview *** Very long term project(initial PO for 1 year and usually the project goes for 3-5 years with this customer) ***Hybrid ** Local to MI candidate Preferred***Linkedin required; need 2 references Position Summary TheClient 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 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...

Key responsibilities

check_circleCollaborate with the team on day-to-day project tasks
check_circleLearn tools and processes used by the organization
check_circleDocument work and participate in team meetings
check_circleSupport quality checks and continuous improvement

Requirements

check_circleDesign, develop, implement, and maintain enterprise dashboards, executive scorecards, and business intelligence solutions supporting statewide IT investment management.
check_circleDevelop standardized portfolio reporting supporting ITIF investments, project performance, portfolio governance, and executive oversight.
check_circleDesign meaningful Key Performance Indicators (KPIs), portfolio metrics, and visualizations that communicate organizational performance and portfolio health.
check_circleDevelop automated reporting processes that improve reporting accuracy, consistency, and timeliness.
check_circleProduce recurring and ad hoc executive reports supporting DTMB leadership, governance bodies, and agency stakeholders.
check_circleDesign, 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.
check_circleDevelop, optimize, and maintain complex SQL queries, data models, and transformation processes.
check_circleDesign scalable data models that support enterprise reporting and analytical capabilities.
check_circleEnsure data quality, consistency, integrity, and reliability across reporting environments.
check_circleRecommend improvements to enterprise data architecture supporting investment management and portfolio reporting.
check_circleAnalyze project, portfolio, financial, schedule, resource, governance, and operational data to identify trends, risks, opportunities, and emerging issues.
check_circleAssess project health, risk management effectiveness, deliverable quality, and compliance with applicable standards and governance requirements.

Skills & keywords

datadetailsengineerhybridmsysseniorsqltechnologiesview

Benefits & perks

check_circleMentorship
check_circleCertificate of completion
check_circleFlexible work arrangement where applicable