SALARY: Negotiable

GENERAL PURPOSE:

Work independently under general supervision to envision, build, and oversee the agency’s enterprise data and analytics platform, including its associated technology environment, data governance, standards, policies, and services. As part of the enterprise architecture group, this position will work closely with key agency stakeholders to define the future state data environment that enables quicker, more flexible, data-based decision making, as well as enable strategic agency goals through data. Key to this role is to strive towards a new model of data self-service, enabling the business units to be more agile, rather than constrained through a more traditional and rigid enterprise approach.

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.

• Conceptualize, roadmap, and plan the agency’s enterprise data strategy.

• Design and manage the agency’s reference architecture for data marts, warehouses, tooling, and analytic environments.

• Partner with infrastructure architecture to design and direct the implementation of on-premise and cloud-based data technology components.

• Partner with the data and information services team to perform detailed design and implementation of data platform and business solutions.

• Develop, approve, and promote the creation of agency data standards and practices.

• Design, initiate, and support agency data governance needs.

• Maintain awareness of capacity, demand, value and cost, and work closely with the data and information team to optimize ongoing cloud or other expenses.

• Determine the need for and lead the development of agency policy, procedures, and standards for the effective use of data both within and outside of the enterprise.

• Determine the need for, own and oversee the creation of any enterprise schemas, taxonomies, and related master data.

• Participate in technology and data change management efforts.

• Perform as the service architect for ITSM-focused data services.

• Provide data solution architecture support as needed, including analysis of needs, schema design, and ELT/ETL design.

• Remains current on emerging technologies and makes recommendations for pursuing new products and technologies.

• Foster an inclusive and collaborative environment, partnering with data stewards, champions, and owners to build an effective cross-functional team to lead the evolution of the agency’s data needs.

• Demonstrates Sound Transit’s Values in every interaction.

• 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 Information Technology/Computer Science or related field, Master’s degree preferred.

• Six years of senior-level experience as a Data Applications Developer/Engineer or Database Administrator; or three years of experience as a Data Architect.

• Experience with cloud data warehouse technologies, Microsoft Azure data platform services.

• Experience in building a broad data-focused capability.

Required/Preferred Licenses or Certifications:

Azure Data Engineer, or Azure Solution Architect preferred.

Required Knowledge of:

• Expert level knowledge of data architecture principles, approaches, best practices, and emerging technologies related to data and data hosting.

• Knowledge of data classification, protection. data privacy, compliance, and security principles.

• Knowledge of data ingestion design patterns, including streaming analytics, complex event processing, and micro-services.

• Data management concepts, including data catalogs, ETL, ELT, Kimball, OLTP, OLAP.

• ITIL and ITSM concepts.

• Knowledge of data development and data discovery methodologies.

• Knowledge of transit, industrial operations or related disciplines preferred.

• Knowledge of service bus and web service integration concepts are preferred.

• Knowledge of more modern data architectures that support data science, such as data lakes and data mesh preferred.

• Data lakes, data marts and warehouses, and data pipelines.

• Real-time data acquisition, processing, analysis, and dash-boarding.

• Data management tools including SQL Server, SSIS, and Azure Data Platform services such as Azure Data Lake, Azure Data Factory, Azure Synapse etc.

• Data analysis tools, including SSAS, Power BI, Azure Analysis Services and Data Lake Analytics

• Big data platforms, solutions and tools

Required Skills:

• Data services and Data as a Service architecture.

• Data governance processes and structures.

• Design, management and use of semantic models.

• Data Quality Management and Data Cleansing techniques.

• Creating conceptual, logical, and physical designs for data and platform layers.

• Executive engagement, presentations and communications.

• Master data management best practices and the ability to lead in their implementation and maintenance.

• Translation of agency strategy into strategic technology plans for data and data platforms.

• Development and oversight of contract SOWs and vendors preferred.

• Maintain oversight of the risks and issues associated with data and direct analysis and problem-solving efforts as needed.

• Incremental delivery and continuous improvement.

Physical Demands / Work Environment:

• Work is performed in a standard office environment.

• Subject to standing, walking, bending, reaching, stooping, and lifting of objects up to 25 pounds.

• 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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)