Technical Project Manager–Data & Business Intelligence-ORCA (term-limited)

We need to output HTML fragment with sections: Salary range, Benefits, maybe Pay? The instructions: Use

for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Include a section ONLY when posting has real, specific content for it. So we need to include sections for Salary (Pay) and Benefits. Possibly also "Responsibilities" (Essential Functions) and "Qualifications" (Minimum Qualifications, Preferred Licenses And Certifications, Required Knowledge And Skills, Preferred Knowledge and Skills). Also maybe "About the role" (General Purpose). We must not repeat job title as heading. Also we must not include Job ID etc. Remove boilerplate like EEO, etc. Also remove application instructions (none present). Also remove duplicated lines. We need to preserve all substantive information. So we need to include content under each heading. We need to decide which headings to use: "About the role" (General Purpose), "Responsibilities" (Essential Functions), "Qualifications" (Minimum Qualifications, Preferred Licenses And Certifications, Required Knowledge And Skills, Preferred Knowledge and Skills), "Skills" maybe combine required/preferred? But we can have separate sections: "Qualifications" and "Skills". However instructions say we can use those headings if content exists. We have qualifications (education, experience). We have required knowledge and skills (list). We have preferred knowledge and skills (list). Could combine into "Qualifications" and "Skills". But we need to avoid thin sections. Perhaps better: "Qualifications" includes education, experience, certifications. "Skills" includes required and preferred knowledge and skills. Or we could have "Requirements" for minimum qualifications, "Preferred Qualifications" for preferred licenses/certs, but we only have set headings list. Use "Qualifications" for both minimum and preferred? Might be okay. We also have "Physical Demands/Work Environment" but not in list of allowed headings; we could maybe put under "About the role" or drop? The instruction: Use

for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It says e.g., not limited to those? Probably we should stick to those allowed headings. Physical Demands/Work Environment could be omitted or placed under "About the role" as a paragraph. But we must preserve all substantive information; we could include it as a paragraph under "About the role" or maybe under a separate heading not listed? The instruction says use those headings for section headings; doesn't forbid other headings but says use

for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Likely they expect us to use those headings only. So we should map content to those. Thus: - Pay: Salary range info. - Benefits: Benefits list. - About the role: General Purpose + Physical Demands/Work Environment maybe. - Responsibilities: Essential Functions. - Qualifications: Minimum Qualifications + Preferred Licenses And Certifications. - Skills: Required Knowledge And Skills + Preferred Knowledge and Skills. We must not include headings with filler like "commensurate with experience". We have specific content. We need to output only HTML fragment, no /, no markdown fences. We'll produce something like:

Pay

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

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.
• Inclusive Reproductive Health Support Services.

About the role

General Purpose Under the supervision of the Deputy Director – ORCA Business Operations (ORCA BI Program Manager), the Technical Project Manager is responsible for planning, coordinating, and supporting the successful delivery of medium to large scale data, analytics, and business intelligence projects involving multiple technical and business stakeholders.

Physical Demands/Work Environment Work is performed in a hybrid environment with an expectation of working in office a minimum of 3 days per week.The Agency promotes a safe and healthy work environment and provides appropriate safety and equipment training for all personnel as required.

Responsibilities

• Under the direction of the ORCA BI Program Manager, manage the day-to-day planning and delivery of assigned medium- to large-scale data, analytics, business intelligence, reporting, and related technology projects.
• Develop and maintain project plans that clearly define scope, objectives, deliverables, milestones, schedules, resource needs, dependencies, and budgets.
• Work with the ORCA BI Program Manager to establish appropriate project governance, decision-making processes, escalation paths, and stakeholder engagement strategies.
• Use project management software and tools to provide transparent, current information regarding project scope, schedule, budget, milestones, dependencies, risks, issues, decisions, and overall project status.
• Monitor project performance against approved plans and proactively identify and escalate schedule, resource, scope, and budget variances.
• Coordinate activities across multiple workstreams, technical disciplines, stakeholder groups, and vendors.
• Manage project changes through established scope and change-control processes.
• Prepare concise project status reports and communicate progress, risks, decisions, and issues to the ORCA BI Program Manager, project sponsors, governance bodies, and other stakeholders.
• Plan and facilitate stakeholder meetings, workshops, requirements sessions, solution discussions, project reviews, and decision-making sessions.
• Facilitate and document business, functional, reporting, data, and technical requirements in partnership with business stakeholders, the Senior Business Intelligence Engineer, and other subject matter experts.
• Translate complex stakeholder discussions into clear requirements, decisions, action items, and next steps.
• Maintain documentation of project decisions, assumptions, requirements, action items, and stakeholder commitments.
• Build alignment among stakeholders with differing business needs, technical perspectives, priorities, and levels of technical expertise.
• Escalate unresolved decisions, risks, scope questions, and issues to the ORCA BI Program Manager as appropriate.
• In partnership with the Sr. Business Intelligence Engineer, facilitate evaluation of solution alternatives, including business requirements, technical feasibility, dependencies, constraints, risks, costs, and tradeoffs.
• Coordinate participation by appropriate technical subject matter experts in requirements development, solution analysis, design, testing, and implementation activities.
• Support the technical leads in ensuring proposed solutions are evaluated for alignment with applicable architecture, data governance, security, integration, and technology standards.
• Maintain traceability between business needs, requirements, solution decisions, project deliverables, and testing outcomes.
• Ensure technical decisions and recommendations are appropriately documented and incorporated into project plans and deliverables.
• In partnership with business stakeholders, develop and coordinate project-level testing strategies, schedules, responsibilities, entry and exit criteria, and acceptance processes.
• Facilitate user acceptance testing (UAT) and coordinate testing activities among business users, technical teams, vendors, and other stakeholders.
• Track defects, issues, and required remediation through resolution.
• Ensure testing results, approvals, and acceptance decisions are appropriately documented.
• Coordinate implement3ation readiness, deployment planning, stakeholder communications, training, documentation, and transition to operations or ongoing support.
• Facilitate project closeout activities, including lessons learned and documentation of outstanding operational items.

Qualifications

• Minimum Qualifications Bachelor’s degree in project management, information technology, computer science, business administration, information systems, data analytics, or a related field; or an equivalent combination of education and relevant professional experience.
• Five or more years of progressively responsible project management experience, including experience managing medium- to large-scale technology projects.
• Preferred Licenses And Certifications Project Management Professional (PMP) certification highly preferred.

Skills

• Required Knowledge And Skills Demonstrated experience managing data-related projects, such as data warehouse, data integration, data migration, business intelligence, analytics, reporting, data platform, or similar initiatives.
• Demonstrated experience facilitating and documenting stakeholder engagement, requirements gathering, solution analysis, technical and business decision-making, and testing activities.
• Experience managing projects involving multiple business units, technical teams, vendors, or stakeholder organizations.
• Demonstrated ability to develop and maintain project scope, schedules, budgets, resource plans, risk and issue logs, decision logs, and project status reporting.
• Experience using project management and work-management software to provide stakeholders with visibility into project scope, schedule, deliverables, dependencies, risks, and budget.
• Strong understanding of project management methodologies and the ability to apply traditional, Agile, hybrid, or other approaches based on project needs.
• Strong meeting facilitation, written communication, documentation, presentation, and interpersonal skills.
• Demonstrated ability to communicate effectively with both technical and nontechnical audiences.
• Ability to manage multiple priorities and workstreams while maintaining attention to project dependencies, commitments, and deadlines.
• Demonstrated ability to work effectively in environments requiring significant cross-functional coordination, stakeholder consensus, and formal decision-making.
• Data warehouses, data lakes, and modern data platforms knowledge
• Business intelligence and reporting solutions
• Data integration, ETL/ELT, and APIs
• Relational databases and data models
• Cloud-based data environments
• Data quality and validation
• System integrations and upstream/downstream dependencies
• Software development and system implementation lifecycles
• Testing methodologies, including system, integration, regression, and user acceptance testing
• Information security, privacy, and access-control considerations applicable to data projects
• Preferred Knowledge and Skills Project Management Professional (PMP) certification highly preferred.
• Experience managing projects in a public-sector, transportation, government, or similarly complex multi-stakeholder environment.
• Experience managing projects involving external vendors, consultants, or systems integrators.
• Experience with tools such as Microsoft Project, Smartsheet, Jira, Azure DevOps, or comparable project/work-management platforms.
• Familiarity with business intelligence platforms such as Microsoft Power BI or comparable technologies.
• Familiarity with Microsoft Azure or other cloud data environments.
• Experience