Sr Data Engineer

Our client is seeking an experienced Senior Data Engineer to support portfolio reporting, business intelligence, and data analytics for a current program. 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. Tasks Design, develop, implement, and maintain enterprise dashboards, executive scorecards, and business intelligence solutions supporting 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 leadership, governance bodies, and agency stakeholders. Design, develop, and maintain data pipelines integrating information from the 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. 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. 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. Identify opportunities to automate manual reporting activities and improve reporting efficiency. Participate in continuous improvement initiatives supporting the SUITE methodology, Investment Management program, and enterprise reporting capabilities. Provide knowledge transfer, documentation, and technical guidance to staff supporting long-term sustainability. Knowledge, Skills and Abilities Required Strong analytical and problem-solving skills with demonstrated experience performing root cause analysis, identifying trends, and making data-driven recommendations. 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. NOTE: Local candidates ONLY. Candidate MUST be located in Michigan at time of submission and be able to abide by the hybrid work schedule. Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. Wednesdays and Thursdays Are Required Onsite Days. Location: Lansing, MI Contract: 1 year Skills Required Strong project management reporting & portfolio analytics experience 4-7 years - 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 Bl or comparable business intelligence platforms. Experience working directly with business stakeholders to define reporting requirements, key performance indicators (KPls), and performance measures Demonstrated experience analyzing portfolio, project, financial, operational, or governance data to support executive decision-making. Experience developing and optimizing SQL queries, data models, and data transformation processes. Bachelor's degree in Computer Science, Information Systems, Data Science, Business Analytics, Management Information Systems, Mathematics, Statistics, Engineering, or another closely related field. Skills Desired – A plus to have 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. Microsoft Power BI, Microsoft Fabric, Azure Data Factory, Azure SQL, Microsoft SQL Server, or comparable Microsoft analytics technologies. 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. One or multiple of the following certifications: 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) Rate depends on experience Candidates authorized to work in the US are encouraged to apply. We can accept H1b, , TN, and other valid work visas for IT. However, we cannot accept OPT or CPT visas at this time. Companies submitting candidates should only submit direct W2 employees for this position. Please submit your resume by using the "URL" below #J-18808-Ljbffr