Project Management Information System (PMIS) Data Engineer - (Term-Limited)

Sound Transit; Seattle (WA); Hybrid; USD 80,000 - 175,000; Full time

Job summary

An innovative transit agency is seeking a skilled PMIS Data Engineer to design and implement robust data solutions. This role involves automating data pipelines, integrating diverse data sources, and ensuring data quality across the organization. You will collaborate with cross-functional teams to enhance data reliability and efficiency, leveraging advanced technologies and practices. With a commitment to diversity and inclusion, this opportunity offers a competitive salary and a comprehensive benefits package, including generous paid time off and professional development support. Join us in transforming data into actionable insights for better decision-making.

Benefits

Health Benefits

Long-Term Disability Insurance

Paid Time Off

Parental Leave

Tuition Reimbursement

Pet Insurance

Retirement Plans

Employee Assistance Program

ORCA Card

Inclusive Reproductive Health Support

Qualifications

• Bachelor's degree in Computer Science or related field required.
• 5 years of experience in data engineering, business intelligence, and analytics.

Responsibilities

• Design and implement enterprise-class data solutions.
• Develop and operationalize data pipelines for data consumption.
• Collaborate with teams to optimize data ingestion and quality.

Skills

SQL

Data Engineering

ETL Workflows

Data Warehousing

Data Modeling

Cloud Platforms

Programming (C#, Java, Python)

Agile Methodologies

Data Governance

Data Quality Assurance

Education

Bachelor's Degree in Computer Science

Experience in Data Engineering

Tools

Azure Data Factory

Microsoft SQL Server

Power BI

Kafka

Git

Docker

Job description

Join to apply for the Project Management Information System (PMIS) Data Engineer - (Term-Limited) role at Sound Transit

Join to apply for the Project Management Information System (PMIS) Data Engineer - (Term-Limited) role at Sound Transit

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 data governance initiatives and influences the development of sustainable data management and governance practices across the agency.
• Creates and maintains architecture diagrams, system documentation, data models, mapping documents, business rules, data flow diagrams and other design related artifacts.
• Actively participates in architecture design, and code review sessions with peers, solution architects, consultants, and vendors.
• Attends professional group meetings; stay abreast of new trends and innovations in the field of information technology.
• Conducts research and makes recommendations on emerging technologies, toolsets, applications, and systems, considering among other factors cost savings, adoption, standardization/simplification, flexibility, and reuse.
• Troubleshoots and resolves production issues quickly to ensure system uptime meets service level agreements.
• Performs peer reviews for other data engineer’s work.
• Follows agency’s data classification policies and procedures and maintain compliance with established security standards and best practices.
• Communicates statuses of all assigned tasks clearly and concisely to the project team, stakeholders, and management.
• Works cooperatively with coworkers, product managers, customers, project managers and vendors.
• 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, Information Technology, Engineering, or closely related field and five years of experience in information technology in the areas of data engineering, business intelligence and analytics; OR an equivalent combination of education and experience.

Required Knowledge And Skills

• Basic principles of computer science, database technologies and information systems.
• Advanced principles, best practices, methods, and techniques used in data engineering, business intelligence, data management, data warehousing concepts, data mapping, data modeling, reporting, analytics, and data science.
• Relational database management systems, NoSQL databases and Big Data ecosystem.
• Data pipelines, stream processing, Supervisory Control And Data Acquisition (SCADA) and Internet of Things (IoT).
• Enterprise data catalog, meta-data and master-data concepts and management.
• Full-stack DevOps engineering with understanding of compute, network, storage with cost optimized implementations.
• DevOps tools like ADO, Git, Jenkins, Dockers etc.
• Enterprise application systems related to Finance, Human Resources, Asset Management, Transit Rider Technologies, and other subject areas as needed.
• Evaluating business requirements and developing information technology solutions.
• Operational characteristics of a variety of computer and network systems, applications, hardware, software, and peripheral equipment, including enterprise business systems.
• Various methods of service delivery including agile and waterfall.
• Software development life cycle, source code version control systems, release management, change management, and ITIL processes (Incident and Change Management).
• Principles, practices, methods, and techniques used in the installation, troubleshooting, and maintenance of software systems and applications.
• Quality Assurance techniques and automated testing practices.
• Principles and practices of project management.
• Pertinent federal, state, and local laws, codes, and regulations.
• Designing and implementing Business Intelligence/Analytics platforms using Azure services such as Azure Synapse Analytics, Azure Data Factory, Azure Data Lake to improve and speed up delivery of data services.
• Relational Database Management Systems (RDBMS), Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and other relevant technologies.
• Message based integration using Kafka and/or Azure Event Hub
• Logical and physical data modeling for both OLTP and OLAP.
• Reporting technologies including but are not limited to Microsoft SQL Server Reporting Services (SSRS), Microsoft Report Builder, Power BI, Crystal Reports, Business Objects Enterprise, etc.
• Working knowledge and advanced skills in Excel as a data source and reporting tool.
• Big Data tools like Spark, MapReduce, Hive, Pig, Oozie, etc.
• NoSQL solutions like HBase, MongoDB, Cassandra etc.
• Programming using C#, Java, Scala, and Python; scripting using PowerShell.
• Creating and consuming various data formats such as CSV, XML, JSON, etc. including using of APIs or web services for data acquisition.
• Learning new applications, programming languages, development tools, and technologies quickly.
• Establishing and maintaining effective working relationships with peers, other department staffs, managements, vendors, outside agencies, community groups, external business partners and the public.
• Effective oral and written communication and the ability to convey technical details to non-technical stakeholders, senior leadership, and executives both in written and verbal form.
• Working effectively under pressure, meeting tight deadlines, and adjusting to changing priorities.
  
  

Physical Demands / Work Environment

• Work is performed in a standard hybrid office environment.
• Position is responsible for creating visuals such as charts, graphs, etc; may be subject to seeing.
• Position is occasionally responsible for performing patches during off hour times including nights and weekends.
• 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Project Management and Information Technology

Referrals increase your chances of interviewing at Sound Transit by 2x

Get notified about new Project Management Specialist jobs in Seattle, WA.

Seattle, WA $116,000.00-$166,000.00 2 weeks ago

Seattle, WA $70,900.00-$151,700.00 6 days ago

Special Project Manager III - Harborview Bond Program Office

GenAI Project Manager, Product Data Operations

Seattle, WA $93,000.00-$136,000.00 2 weeks ago

Assistant Project Manager - Kiewit Power Delivery Engineering

Sr. Supply Chain Manager, Project Kuiper

Redmond, WA $103,900.00-$181,400.00 2 weeks ago

Sr. PM, Back Of House and Vendor Managed Inventory, Amazon Fresh Stores

CX Customer Delivery Project Manager - Amazon

Seattle, WA $125,700.00-$164,500.00 3 weeks ago

Manager, Program Management, Project Amelia

Development Services Office Project Requirements Manager (Mgr. 2)

Technical Marketing Project Manager, Partner Marketing, Global Operations

Technical Program Manager, Quality Assurance Lead, Project Starline

Lifecycle Engineering Project Manager, GES Sustainability & Automation

Bellevue, WA $66,800.00-$142,800.00 2 weeks ago

Technical Project Manager- Energy, Utilities and Transportation

Seattle, WA $140,800.00-$269,550.00 2 weeks ago

Sr. Program Manager - Amazon Gift Cards , Amazon Gift Cards

Sr Manager, Operations Technical Program Management - Electronic Supply Chain, Project Kuiper

Redmond, WA $175,200.00-$302,900.00 6 days ago

Bellevue, WA $104,100.00-$185,000.00 2 weeks ago

Seattle, WA $90,000.00-$120,000.00 3 months ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.