Senior Data Engineer

Title: Senior Data Engineer
Location: Michigan (Hybrid - Local Candidates Only)
Duration: 12 Months with Possible Extension

Key Responsibilities
Portfolio Reporting & Business Intelligence

• Design, develop, implement, and maintain enterprise dashboards, executive scorecards, and BI solutions.
• Develop standardized portfolio reporting supporting IT investments, project performance, governance, and executive oversight.
• Create meaningful KPIs, portfolio metrics, and visualizations.
• Automate reporting processes to improve accuracy and efficiency.
• Produce recurring and ad hoc executive reports.

Data Engineering & Integration

• Design and maintain data pipelines integrating data from:
  • Project Portfolio Management (PPM) platforms
  • Business intelligence environments
  • Financial systems
  • Governance repositories
  • Enterprise data sources
• Develop and optimize complex SQL queries.
• Build and maintain data models and transformation processes.
• Ensure data quality, integrity, consistency, and reliability.
• Recommend improvements to enterprise data architecture.

Portfolio Analytics

• Analyze project, portfolio, financial, schedule, resource, and operational data.
• Identify trends, risks, opportunities, and emerging issues.
• Perform root cause analysis.
• Develop predictive and trend-based reporting.
• Provide recommendations to support executive decision-making.

Business Analysis & Stakeholder Engagement

• Work with business stakeholders to define reporting requirements.
• Gather and document business and technical requirements.
• Translate business needs into reporting and dashboard solutions.
• Define KPIs, metrics, visualization strategies, and reporting standards.
• Maintain technical documentation and data definitions.

Continuous Improvement

• Identify opportunities to automate manual reporting.
• Improve reporting processes and BI capabilities.
• Support statewide reporting standards.
• Provide knowledge transfer, documentation, and technical guidance.

Minimum Qualifications
Candidates must have:

• 3+ years of professional experience in:
  • Data Engineering
  • Business Intelligence
  • Data Analytics
  • Related IT disciplines
• Experience developing and maintaining enterprise reporting and BI solutions.
• Experience integrating and transforming data from multiple enterprise systems.
• Experience creating Power BI dashboards, scorecards, and executive reports.
• Experience gathering requirements and translating business needs into technical solutions.
• Experience analyzing portfolio, project, financial, operational, or governance data.
• Strong SQL query development and data modeling skills.
• Experience performing data analysis, root cause analysis, and identifying trends.
• Ability to communicate technical information to technical and non-technical audiences.
• Ability to manage multiple assignments and priorities independently.

Required Skill Data engineering, business intelligence, data analytics, or related IT experience Project management reporting and portfolio analytics experience Integrating, transforming, and analyzing data from multiple enterprise systems SQL and modern data engineering techniques Developing interactive dashboards, scorecards, and executive reporting Microsoft Power BI or comparable BI platforms Gathering reporting requirements and defining KPIs/performance measures Working directly with business stakeholders Strong written and verbal communication skills