Senior Data Engineer || Lansing, MI (Hybrid)
Contract W2
Contract Corp To Corp
Contract Independent
12 Months
No Travel Required
Hybrid
Depends on Experience
Verito Solutions
Fitment
Dice Job Match Score™
⭐ Evaluating experience...
Job Details
Skills
- Data Engineer
Summary
Senior Data Engineer
Lansing, MI (Hybrid)
Phone + Video
Job description:
Lansing, MI (Hybrid)
Phone + Video
Job description:
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
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
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
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
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
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
QUALIFICATIONS
Required:
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:
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:
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
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
Equivalent combinations of education, technical training, professional certifications, and directly related experience may be considered
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)
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)
(“Believe you can and you’re halfway there.”)
– Theodore Roosevelt
Yogesh Sharma | Lead Tech Recruiter
An -E Verified Company
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: 91170457
- Position Id: 20632-40870-1785856464
- Posted 8 hours ago
Company Info
About Verito Solutions
At Verito Solutions, our core mission is to be an essential partner in our clients’ success. With a strong vision to become a global leader in delivering innovative and value-driven technology solutions, we are committed to exceeding expectations at every step. Our team is fueled by passion, expertise, and an unwavering determination to provide cutting-edge solutions tailored to the evolving needs of businesses.
We understand the challenges organizations face in today’s fast-paced digital landscape. That’s why we focus on delivering technology solutions that not only enhance efficiency but also save our clients valuable time, money, and effort. Whether it’s optimizing workflows, strengthening cybersecurity, or driving digital transformation, Verito Solutions is dedicated to empowering businesses with seamless, scalable, and future-ready technology.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs