Senior Business Intelligence Engineer-ORCA (Term-Limited)

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

*This is a term-limited position currently funded for two years. Additional years are subject to project needs and funding approval*

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 minimal supervision, gathers regional business needs for data; models target schemas; participates in the creation, development, and maintenance of data extract-transfer-load (ETL) processes and data warehousing; provides data analysis and implements reports. Leverages pragmatic data management practices to ensure business users have reliable and high-quality reports. Work complements the IT Enterprise Architect, database administrators, ORCA agency business analysts, and report developers to provide fundamental data services and enable increasing end-user self-sufficiency with reporting. This is a term-limited position currently funded for two years. Additional years are subject to project needs and funding approval.

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.

• Responsible for gathering and documenting business data requirements and report design strategies.
• Defines queries, views, temporary tables, and other objects related to solving questions with data.
• Develops, documents, and maintains data collection procedures and definitions.
• Partners with Database Administrators (DBAs) to translate logical models into physical models so that ad-hoc queries, reports, and dashboards perform well and can be modified with ease.
• Plans, coordinates, and assesses the work of report developers; reviewing and evaluating work products, methods, and procedures; and meets with staff to identify and resolve problems.
• Helps to review and resolve issues with vendors and business users related to report generation and usage.
• Manages a consolidated view of reporting capabilities provided by the ORCA data warehouse and vendor provided data.
• Evaluates ad-hoc reports provided by agencies to identify candidates to promote to more business users.
• Provides status information, metrics, and reports related to report usage and availability to share with others when required.
• Provides ongoing input for the requirements of the data warehouse.
• Partners with the DBAs and IT Enterprise Architect to support the sustainability of the data warehouse. 
• Partners with Reports Developers to develop and maintains reports, graphs, and visualizations, including a catalog of available reports, allowing business users to easily find and understand information.
• Reviews, creates, and maintains scripts to monitor and report on data quality and troubleshoot issues which may comp