Business Intelligence Analyst - Reporting & Benchmarking

Salary range is $81k to $144k with a midpoint of $98k. 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.

Under general direction, provides professional data, data visualization and reporting services to the Executive department and the agency at large by working with internal and external data sets to create visual representations of data such as charts, maps, infographics, graphs, and dashboards that illustrate and clarify information used both for public information and internal decision-making. Uses principles of storytelling to help audiences understand key messages.

Focuses on larger initiatives, with the ability and authority to lead and manage projects. Expected to interface with and understand interest holder needs to provide strategic analytics, enterprise data management, and executive-level or departmental reporting.

Uses industry-standard techniques, tools and software to design, develop, and implement visualizations, transforming raw data into clear and compelling visuals. Serves as the Coordinating Data Steward within the department’s data domain and supports active participation of data owners and data stewards to ensure data used for decision making is fit for purpose and of high quality.

The Business Intelligence Analyst is an experienced data analyst responsible for BI reporting, data modeling, and business performance monitoring. They will focus on transforming meaningful business insights and storytelling through reporting and analysis. Core focus will be on reporting, data visualization, and benchmarking.

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.

• Collaborate with business teams to support the use of BI tools and processes that support data-informed decision-making throughout the organization.
• Identifies useful data sources throughout the agency. Gathers and documents data and data processes. Build and maintain dashboards and reports using Microsoft’s Power BI and other business intelligence tools
• Analyze business trends and performance metrics to uncover and share actionable insights for key business issues.
• Prepare reports assessing the agency’s performance in maintaining quality, minimizing cost, delivering service, ensuring safety, improving employee morale, achieving sustainability and meeting Sound Transit’s civil rights equity and inclusion goals
• Document processes for business intelligence reports, data source mapping and action items that result from review of the business intelligence reports.
• Extract, transform and load data from complex…