Lansing, MI - IT - CSS - EPMO - EPMO - Portfolio - Senior Data Engineer
Sunrise Systems Inc
- Lansing, MI
- Today
Want to know if you’re a fit?
Upload your resume and let our AI show you.
Upload your resume and let our AI show you.
Skills
- Agile Programming Methodologiesunmatched
- Analysis Skillsunmatched
- Application Programming Interface (API)unmatched
- Automationunmatched
- Budgetingunmatched
- Business Analysisunmatched
- Business Architectureunmatched
- Business Intelligenceunmatched
- Business Solutionsunmatched
- Business Supportunmatched
- CSS (Cascading Style Sheet)unmatched
- Communication Skillsunmatched
- Comparative Analysisunmatched
- Computer Scienceunmatched
- Continuous Improvementunmatched
- Corrective Actionunmatched
- Data Analysisunmatched
- Data Managementunmatched
- Data Modelingunmatched
- Data Processingunmatched
- Data Qualityunmatched
- Data Scienceunmatched
- Data Warehousingunmatched
- Database Administrationunmatched
- Database Extract Transform and Load (ETL)unmatched
- Decision Supportunmatched
- Documentationunmatched
- Employee Orientationunmatched
- Enterprise Architectureunmatched
- Financial Managementunmatched
- Financial Operationsunmatched
- Financial Systemsunmatched
- Fundingunmatched
- Governmentunmatched
- Identify Issuesunmatched
- Information Systems/Technology IS/IT Administrationunmatched
- Information Technology & Information Systemsunmatched
- Internet Securityunmatched
- Investment Capitalunmatched
- Investment Fundsunmatched
- Investment Managementunmatched
- Investment Reportingunmatched
- Kanbanunmatched
- Knowledge Transferunmatched
- Leadershipunmatched
- Maintain Complianceunmatched
- Management Reportingunmatched
- Management of Information Systems/Technology (MIS)unmatched
- Mathematicsunmatched
- Metadataunmatched
- Metricsunmatched
- Microsoft Product Familyunmatched
- Microsoft Projectunmatched
- Microsoft SQL Serverunmatched
- Microsoft Windows Azureunmatched
- Performance Analysisunmatched
- Performance Managementunmatched
- Performance Metricsunmatched
- Portfolio Analysisunmatched
- Power BIunmatched
- Presentation/Verbal Skillsunmatched
- Problem Solving Skillsunmatched
- Process Improvementunmatched
- Process Modelingunmatched
- Project Evaluationunmatched
- Project Management Body of Knowledge (PMBOK)unmatched
- Project Management Professional (PMP)unmatched
- Project Portfolio Management (PPM)unmatched
- Project Trackingunmatched
- Project/Program Managementunmatched
- Query Optimizationunmatched
- Regulatory Complianceunmatched
- Reporting Dashboardsunmatched
- Reporting Skillsunmatched
- Requirements Managementunmatched
- Risk Analysisunmatched
- Risk Managementunmatched
- Root Cause Analysisunmatched
- SQL (Structured Query Language)unmatched
- Scorecardingunmatched
- Scripting (Scripting Languages)unmatched
- Scrum Project Management and Software Developmentunmatched
- ServiceNowunmatched
- Standards Developmentunmatched
- Statisticsunmatched
- Sustainabilityunmatched
- Technical Leadershipunmatched
- Technical Supportunmatched
- Technical Writingunmatched
- Time Managementunmatched
- Trend Analysisunmatched
- Writing Skillsunmatched
Description
Job Title: Senior Data Engineer
Job ID: 26-03837
Location: Lansing, MI
Duration: 12 Months of contract
Job Description
Top Skills & Years of Experience:
Job ID: 26-03837
Location: Lansing, MI
Duration: 12 Months of contract
Job Description
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.
Position Summary
The Michigan Department of Technology, Management and Budget (DTMB) 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 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.
Education
- Bachelor's 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 DTMB's 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 State's 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 State's Project Portfolio Management and Investment Management programs.
Contact:
Vinay Kumar: Vinay.c@sunrisesys.com Direct: (732) 837-0448 | URL: Sunrise Systems Inc.
Numbers & Facts
| Location | Lansing, MI |
| Industry | Staffing/Employment Agencies |
| Company Size | 100 to 499 employees |
| Year Founded | 1990 |
| Website | http://www.sunrisesys.com/ |
About Company
Sunrise Systems was founded in 1990 with a clear vision to deliver world-class staffing service solutions in all labor categories, including IT consulting and solutions; all with the commitment to provide service that exceeds expectations and become the most trusted name in the industry. More than two and a half decades later, we pride ourselves on being at the forefront of the staffing industry. Combining our deep industry expertise, insights, and global resources, we have partnered with our clients to connect them with top professionals across several different industries.
We provide cost-effective Managed Staffing Solutions, Information Technology and Information Technology Consulting Services to several Fortune 500 companies and U.S. Government agencies. We provide our clients with flexible engagement models and customized products that are budget and time specific. Understanding the challenges that every business faces, we offer our services either on-site at the clients' site or from one of our globally distributed technology centers. Our onshore and offshore development capabilities ensure that we excel at meeting customer requirements every single time.
Our collective business experience spans over two and a half decades and ranges from:
- Business, management, and technical fields
- Information technology consulting and software solutions.
- Providing strategic support for the development and long-term growth of new business ventures across several industries including but not limited to; accounting, banking, finance, and recruitment.
- Motivating technology staff and establishing partnerships with Fortune 500 companies
Sunrise Systems has a vast range of competence in:
- Design, development, and support of cloud-based solutions from simple to highly complexed
- Database administration of multi-platform applications, complex databases, and web-based environments that include all aspects of installation, planning, maintenance, and monitoring.
- Data processing and data migration
- Application re-engineering and platform migration
- Working with the Information Systems and end-user communities at all levels to resolve issues and establish consensus.