Data Analyst-PSO

Salary is $60k to $140k, with a midpoint of $95k.  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.

GENERAL PURPOSE:

Under general direction of the Manager- Project Management Office, the Data Analyst – researches, recommends and develops improvements to data and processes in support of the Project Management and Resourcing Team and the agency. This role will play a critical part in advancing data-driven decision-making and improving operational efficiency for Program/Portfolio Management across the agency. 

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.

• Define requirements, research options, and recommend software solutions to meet various business needs.
• Form strategy and detailed plans to integrate and manage data from various sources to ensure data quality and consistency.
• Work independently and with agency peers, consultants, and vendors to design, develop, and maintain interactive dashboards with GIS capabilities and user-defined reports, providing actionable insights for data-driven decision-making.
• Analyze and develop strategies to streamline business processes, improve overall efficiency and reduce manual intervention.
• Assist in development and management of Power Apps and SharePoint sites.
• Monitor and research industry trends, emerging technologies, and best practices to recommend improvements and enhancements to the agency's systems and tools.
• Collaborate and communicate with agency employees to facilitate data sharing and alignment with agency data governance.
• Develop and maintain comprehensive documentation of systems, processes and tools to ensure knowledge transfer and continuity.
• Ensure data security and compliance with relevant regulations, including data privacy and retention policies.
• 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: Bachelor's degree in Computer Science, Statistics, Information Systems, or a related field and four years of experience in data management, systems integration, GIS, dashboard development, and Microsoft Power Platform; Or an equivalent combination of education and experience.

Required Knowledge and Skills:

• Proficiency in Microsoft Power Platform (Power BI, Power Apps, Power Automate, Data Warehouse).
• Proficiency with Microsoft 365 applications and services (Excel, SharePoint, Teams, etc). 
• Ability to maintain and updating a Geographic Information System (GIS). 
• Strong analytical, problem-solving and project management skills.
• Ability to create meaningful and clear data visualizations.
• Excellent verbal and written communication and interpersonal skills, with the ability to engage with stakeholders at all levels and present complex information in an understandable manner.
• Knowledge of data governance, security, and compliance best practices.
• Experience with change management and facilitating the adoption of new systems, tools, and processes.
• Experience with data cleaning, transforming, and preparing data for analysis. 
• Attention to detail and follow-through on small and large tasks.
• Strong relationship management and interpersonal skills, especially working with a variety of people. 
• Ability to establish and maintain effective working relationships with other agency staff, management, vendors, and outside agencies.
• Excellent presentation skills and ability to articulate complex concepts to simplified language for a diverse audience.
• Adaptability to meet changing demands.

Preferred Knowledge and Skills:

• Experience working in a transit agency or other public governmental agency.
• Experience with industry leading project/portfolio management software (ex. Oracle Suite). 
• Experience with user experience (UX) design and accessibility principles.
• Familiarity with business process analysis and optimization techniques.

Physical Demands / Work Environment:

• Work will be performed in a standard hybrid office environment.
• 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.