Senior Reporting Analyst-Project Management Information Systems (term-limited)

ST Public Branding•Seattle, WA

20h•Hybrid

About The Position

The Senior Reporting Analyst is responsible for designing, developing, and delivering high-quality reports, dashboards, and insights using data from ERP and Project Management Information Systems (PMIS). This role partners closely with capital delivery, finance, IT, and leadership teams to support data-driven decision-making, ensure data accuracy, and improve reporting processes. This is a term limited position with an anticipated end date at 5 years of service.

Requirements

Bachelors degree in Technology or related field.
Five years of experience in reporting, analytics, business, systems analysis or business intelligence roles
Experience with reporting and visualization tools (e.g., Power BI, Tableau, SSRS, Excel)
Strong understanding of financial, operational, and project-related data
Strong communication skills with both the ability to translate requirements to technical resources and explain data to non-technical stakeholders
Experience working closely with centralized or enterprise reporting teams in a cross-departmental organization

Nice To Haves

Certified Analytics Professional (CAP)
Power BI Certifications
Business Analysis Certifications (CBAP, Certificates, etc.)
Experience working with PMIS platforms (e.g., Kahua, Unifier, Primavera P6, etc.)
Experience working with ERP systems (e.g., JD Edwards, SAP, Oracle, Workday, Microsoft Dynamics, NetSuite)
Experience integrating data across ERP, PMIS, and data warehouse environments
Knowledge of project accounting, budgeting, forecasting, and earned value metrics
Prior experience in a senior or lead analyst role
Certifications in PMIS/ERP systems, BI tools, business analysis, or project management
Experience in the Architectural/Engineering/Construction, transportation, or public infrastructure sector
Familiarity with capital delivery processes, project controls, and system-based governance model

Responsibilities

Design, develop, and maintain complex reports and dashboards using ERP and PMIS data
Serve as a subject matter expert for ERP and PMIS reporting capabilities and data structures
Translate business, financial, and project reporting requirements into effective analytical solutions
Ensure data accuracy, consistency, and integrity across multiple systems
Perform data validation, reconciliation, and quality checks
Develop and maintain documentation for reports, metrics, and data definitions
Collaborate with IT, finance, and project teams on system enhancements and reporting automation
Train and support end users on reporting tools and dashboards
Identify opportunities to improve reporting efficiency, automation, and standardization
Support Program & Project Controls by enabling PMIS- and ERP-based data views related to cost, schedule, change management, trends, and forecasts
Support reporting needs associated with project baselines, current budgets, forecasts, and Estimates at Completion (EAC)
Partner with Finance and Project Controls to ensure alignment between PMIS data and ERP financial records
Assist in establishing and maintaining standard PMIS data structures, business rules, and metrics used across capital projects
Support PMIS and ERP data governance efforts by enforcing consistent data definitions and reporting conventions
Participate in PMIS implementations, upgrades, and post-deployment stabilization from a reporting and analytics perspective
Support audit, oversight, and compliance data requests by ensuring PMIS and ERP data is complete, traceable, and well-documented
Champions and models Sound Transit's core values and demonstrates values-based behaviors in everyday interactions across the agency.
Contributes to a culture of diversity, equity and inclusion in alignment with Sound Transit’s Equity & Inclusion Policy.
It is the responsibility of all employees to follow the Agency safety rules, regulations, and procedures pertaining to their assigned duties and responsibilities, which could include systems, operations, and/or other employees.
It is the responsibility of all employees to integrate sustainability into everyday business practices.
Other duties as assigned.

Benefits

Health Benefits: We offer two choices of medical plans, a dental plan, and a vision plan all at no cost for employee coverage; comprehensive benefits for employees and eligible dependents, including a spouse or domestic partner.
Long-Term Disability and Life Insurance.
Employee Assistance Program.
Retirement Plans: 401a – 10% of employee contribution with a 12% match by Sound Transit; 457b – up to IRS maximum (employee only contribution).
Paid Time Off: Employees accrue 25 days of paid time off annually with increases at four, eight and twelve years of service. Employees at the director level and up accrue additional days. We also observe 12 paid holidays and provide up to 2 paid floating holidays and up to 2 paid volunteer days per year.
Parental Leave: 12 weeks of parental leave for new parents.
Pet Insurance.
ORCA Card: All full-time employees will receive an ORCA card at no cost.
Tuition Reimbursement: Sound Transit will pay up to $5,000 annually for approved tuition expenses.
Compensation Practices: We offer competitive salaries based on market rates and internal equity. In addition to compensation and benefits, you’ll find that we provide work-life balance, opportunities for professional development and recognition from your colleagues.