Infrastructure Analyst

Responsibilities

• Transform project data into actionable insights through advanced analytics and visualization techniques
• Develop comprehensive dashboards and reports using PowerBI to communicate key performance metrics effectively
• Collaborate with cross-functional teams to identify data-driven opportunities and establish best practices
• Automate data workflows using Python/R to improve efficiency in reporting and analytics
• Maintain data integrity by identifying and resolving inconsistencies across project management information systems
• Create visualizations that tell compelling stories about project performance for both technical and non-technical stakeholders
• Document analytical methodologies for knowledge transfer and reproducibility

Requirements

• Minimum of 3+ years of experience in data analysis and business intelligence, preferably in project environments
• Strong proficiency in PowerBI for creating advanced dashboards and interactive visualizations
• Demonstrated experience with Python or R for data processing, analysis, and workflow automation
• Experience with SQL for data extraction and manipulation from various database systems
• Knowledge of Project Management Information Systems (PMIS)
• Exceptional skill in transforming complex data into compelling narratives, with proven ability to present insights at conferences and stakeholder meetings
• Strong problem-solving skills with experience handling large datasets from multiple sources
• Engage directly with clients to understand their needs and respond effectively to impromptu requests for data analysis and reporting with minimal supervision

Qualifications

• Masters/PhD degree in Analytics, Computer Science, Information Technology, Engineering, or related STEM field
• Experience with transportation and/or infrastructure projects and programs
• Knowledge of data governance and reporting compliance standards
• Hands-on experience integrating multiple data sources into unified reporting solutions
• Demonstrated ability to work independently while collaborating effectively with diverse teams
• Proficiency with PowerBI Report Builder for creating custom reporting solutions
• Familiarity with geospatial analytics and mapping visualization techniques
• Ability to train various types of machine learning models based on client needs to deliver predictive and prescriptive outcomes

Benefits

• Health insurance, including an option with a Health Savings Account
• Dental insurance
• Vision insurance
• Flexible Spending Accounts (Healthcare, Dependent Care and Transit and Parking where applicable)
• Disability insurance
• Life Insurance and Accidental Death & Dismemberment
• 401(k) Plan
• Retail Counseling
• Employee Assistance Program
• Paid Time Off (starting at 16 days)
• Paid Holidays (9 days)
• Back-Up Dependent Care (up to 10 days per year)
• Parental Leave (up to 80 hours)
• Continuing Education Program
• Professional Licensure and Society Memberships