Project Management Information System (PMIS) Data Engineer - (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.

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.
• Inclusive Reproductive Health Support Services.
• 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 opportunity with an anticipated duration of 2 years.

GENERAL PURPOSE:  

Under minimal supervision, the PMIS Data Engineer designs, builds, tests, and delivers, end-to-end, automated data pipelines over complex on-premises and off-premises platforms. Automates the collection of data from multiple source systems containing structured, semi-structured and unstructured data; integrates, transforms, organizes, stores, and serves data to data analysts, data scientists, and other data consumers within the agency departments. Possesses excellent programming, debugging, testing and problem-solving skills. Leverages pragmatic data management practices and principles to ensure coherent movement of data that are relied upon across the agency as the single source of truth.

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.

• Analyzes business requirements, designs, and implements enterprise-class data solutions for new data projects.
• Develops and operationalizes data pipelines to make data available for consumption.
• Owns the design, development, and ongoing maintenance of data warehouses, data marts, multidimensional cubes, and data lakes.
• Writes complex SQL queries, stored procedures, ETL workflows, views, temporary tables, and other database objects.
• Utilizes latest data technologies and cloud platforms; collects, integrates, ingests, transforms, and organizes, and serves data and information to support data analyses, reporting, dashboarding and modern analytics across the agency.
• Works in tandem with tech leads, data architects and peer data engineers to design data pipelines and recommends ongoing optimization of, data ingestion, data quality, data storage and orchestration.
• Evaluates existing legacy data solutions, redesigns and implements modern data infrastructure for robustness and greater scalability.
• Assists customers with their data related technical issues and data platform needs.
• Builds analytics tools that ingest data from large disparate datasets to draw actionable insights into operational efficiencies and key business performance metrics.
• Identifies ways to improve data reliability and efficiency.
• Develops automated test scripts to monitor and report on data quality issues; conducts root cause analyses in response to data issues and implements cost effective resolutions for data anomalies.
• Collaborates with the IT Enterprise Architecture team to define data architecture framework and implement data solutions and toolsets.
• Provides input into d