Senior Reporting Analyst-Project Management Information Systems - Seattle, Washington, , United States

Salary range is $81k to $170k with a midpoint of $118k. New hires typically receive between minimum and midpoint, however, we may go slightly higher based on experience, internal equity and market.  · Sound Transit also offers a competitive benefits package with a wide range of o ...

Job description

Salary range is $81k to $170k with a midpoint of $118k. New hires typically receive between minimum and midpoint, however, we may go slightly higher based on experience, internal equity and market. 

Sound Transit also offers a competitive benefits package with a wide range of offerings, including:

• 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.

This is a term limited position with an anticipated end date at 5 years of service.

GENERAL PURPOSE: 

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.  

ESSENTIAL FUNCTIONS:

The following duties are a representative summary of the primary duties and responsibilities. Incumbent(s) may not be required to perform all duties listed and may be required to perform additional, position-specific duties.

• 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. 

MINIMUM QUALIFICATIONS:

Education and Experience: Bachelors degree in Technology or related field. Five years of experience in reporting, analytics, business, systems analysis or business intelligence roles; Or an equivalent combination of education and experience.

Preferred Licenses or Certifications:  

• Certified Analytics Professional (CAP)
• Power BI Certifications
• Business Analysis Certifications (CBAP, Certificates, etc.)

Required Knowledge and Skills:

• 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

Preferred Knowledge and Skills:

• 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

Physical Demands / Work Environment:  

• Work is performed in a standard hybrid office environment with a three days per week in-office requirement.
• The Agency promotes a safe and healthy work environment and provides appropriate safety and equipment training for all personnel as required. 

Sound Transit is an equal employment opportunity employer. No person is unlawfully excluded from employment action based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status or other protected class.