What are the responsibilities and job description for the 9976-Technology Expert I position at DataSF?

Apply using SmartRecruiters, the City and County of San Francisco's application portal.

For a complete understanding of this opportunity, and what will be required to be a successful applicant, read on.

San Francisco International Airport (SFO), an enterprise department of the City & County of San Francisco, has a workforce of approximately 1,700 City employees and strives to be a diverse, equitable, and inclusive employer.

SFO’s mission is delivering an airport experience where people and our planet come first, and our core values are Safety and Security, Teamwork, Excellence, Care, and Equity.

Specific information regarding this recruitment process is listed below :

Application Opening : February 28, 2024
Application Deadline : Interested applicants are encouraged to apply as soon as possible as this announcement may close at any time after 5 : 00pm on March 6, 2024.
Compensation Range : $157,326 to $213,148 annually
Hours : Full-time
Recruitment ID : TEX-9976-143549 (RTF0143548-01155105)

Appointment Type : Temporary-Exempt. This position is exempt from Civil Service Commission rules pursuant to the City and County of San Francisco, Charter Section 10.104, and incumbents serve at the discretion of the Appointing Officer. The duration of the appointment shall not exceed 36 months.

Duties and Responsibilities

Lead and develop the organization's overall data strategy, aligning data initiatives with business objectives and ensuring that data resources are used effectively including anticipating future data needs and trends.

Collaborate with business stakeholders to develop the necessary domain knowledge and data models to enable and support data-driven decision making.

Design and create data models that define how data should be structured, categorized, organized, and accessed within the organization's data infrastructure.

Develop the data vocabularies, conceptual, domain, logical, semantic, and physical data models relevant to the airport and aviation essential to develop a Data Architecture for SFO.

With the support of the ITT Data Engineering team, design, develop, and maintain the organization's data infrastructure that includes the database repositories and storage, data pipelines, data catalog, and integration with SFO’s Enterprise Message Bus.

Manage high volumes of real-time, structured, unstructured, time-series, and geo-spatial data according to their lifecycle to ensure high performance, availability, and security through the implementation of data pipelines.

Working with data analysts and data scientists, the data architect shall create data infrastructure to support the execution of analytic reports, machine learning, and artificial intelligence models in a standard, repeatable manner utilizing the appropriate tools and frameworks to support integration.

Working with the ITT Enterprise Bus Integration team, the data architect shall collaborate to define the integration patterns and technologies to integrate data from various sources within the organization.

Develop ETL (Extract, Transform, Load) and ELT (Extract, Load and Transform) processes, data pipelines, data warehousing, and the creation of the Airport Operations Database (AODB).

Collaborate with the ITT Cybersecurity and Compliance team to secure data in transit and at-rest, define and enforce data governance policies, ensure data quality and integrity, consistency, and compliance with regulatory and retention requirements.

Implement security measures to protect sensitive data from unauthorized access or breaches, including defining access controls, encryption, and data masking where necessary.

Collaborate with the ITT Cloud Infrastructure and Data Engineering teams to use Continuous Integration and Development (CI / CD) practices, and methodologies.

Monitor and manage data infrastructure resources to optimize cost efficiency, develop budgets, and forecast future growth.

Analyze growth impacts on network and cloud resources to perform cost analysis and forecasting.

Improve the availability and Service Level Agreements (SLAs) for data services.

Research new technologies, frameworks, managed cloud services, and cloud resources to provide leadership and recommendations to enable new capabilities or to improve operations and resolve problems.

Mentor staff to improve capabilities and to adopt new methods and practices.

How to qualify

Education :

An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits / units (i.e., at least sixty (60) semester or ninety (90) quarter credits / units with a minimum of twenty (20) semester or thirty (30) quarter credits / units in computer science or a closely-related field).

Experience :

10 years in IT service delivery with the last five years in technical delivery in data engineering or data architecture.

Substitution :

Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

One-year full-time employment is equivalent to 2,000 hours. Any overtime hours that you work above 40 hours per week are not included in the calculation to determine full-time employment.

Applicants must meet the minimum qualification by the final filing date unless otherwise noted.

Desirable Qualifications :

A Bachelor’s Degree in computer science, management information systems, data processing, electrical engineering, or a closely related field.

Additional 5 years of recent experience in IT service delivery in technical delivery in data engineering or data architecture.

Excellent communication skills both written and oral with the ability to influence stakeholders in closing architectural and design decisions in a timely manner.

Project management skills to ensure delivery of data products and services on schedule with high quality.

Practice in Agile Methodology to lead developers and staff through the software lifecycle development process.

Practice in mentoring staff to develop capabilities in data pipeline engineering and data architecture.

Takes API-First approach to integration with data products and services. Extensive experience in API design and in system and component design with attention to API security.

Expertise in data modeling utilizing Entity Relationship Diagrams (ERD) and Uniform Modeling Language (UML) to document designs and architecture.

Use experience in TOGAF, ADM, ZACHMAN and frameworks to support SFO’s Data Architecture.

Practice in developing conceptual, logical, semantic, and physical data models and vocabularies that best support various business domains.

Practice in designing and implementing data warehouses and marts in a cloud environment.

Practice in the design and implementation of data pipelines in cloud environments using a data integration platform.

Knowledge of event-driven architecture and integration using Apache Kafka.

Knowledge and practice of CI / CD using Jenkins and GitHub.

Recent and verifiable experience in data related technologies (AWS RDS, S3, Aurora, Boomi Data Catalog, RDBMS, NoSQL, Databricks, Kafka, PowerBI, Snowflake, Spark, Tableau, etc.).

Recent and verifiable experience in cloud environments and managed services using Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform, and Oracle Cloud.

Verification

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at this link.

Note : Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

All work experience, education, training, and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application. Applications completed improperly may be cause for ineligibility, disqualification, or may lead to lower scores.

SELECTION PROCEDURES

Selection Procedure : The selection process will include evaluation of applications in relation to minimum requirements. Applicants meeting the minimum qualifications are not guaranteed advancement to interview. Depending on the number of applicants, the Department may establish and implement additional screening mechanisms to comparatively evaluate the qualifications of candidates. If this becomes necessary, only those applicants whose qualifications most closely meet the needs of the Department will be invited for an interview.

NOTE : Applicants who meet the minimum qualifications are not guaranteed advancement through all of the steps in the selection procedure.

Transportation Security Administration (TSA) Security Clearance : Candidates for employment with the San Francisco Airport Commission are required to undergo a criminal history record check, including FBI fingerprints, and Security Threat Assessment in order to determine eligibility for security clearance and may be required to undergo drug / alcohol screening.

Customs Clearance

This position requires that the incumbent be qualified for unescorted access to the San Francisco International Airport U.S. Customs Security Area. An application for a U.S. Custom Access Seal may be submitted to Customs ONLY after employment has commenced. Employment in this position requires that the incumbent submit an application for, successfully acquire and maintain a Customs Access Seal.

What else should I know?

Additional Information Regarding Employment with the City and County of San Francisco :

Select the “I’m Interested” button and follow instructions on the screen.

Applicants may be contacted by email about this recruitment and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date. Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file. Applicants should retain this confirmation email for their records. Failure to receive this email means that the online application was not submitted or received.

If you have any questions regarding this recruitment or application process, please contact recruitment analyst Gabriella Rodriguez at Gabriella.a.rodriguez@flysfo.com.

The City and County of San Francisco encourages women, minorities, and persons with disabilities to apply.

J-18808-Ljbffr

Salary : $157,326 - $213,148

Apply for this job

Receive alerts for other 9976-Technology Expert I job openings

9976-Technology Expert I

What are the responsibilities and job description for the 9976-Technology Expert I position at DataSF?

What is the career path for a 9976-Technology Expert I?

Job openings at DataSF

Not the job you're looking for? Here are some other 9976-Technology Expert I jobs in the San Francisco, CA area that may be a better fit.

We don't have any other 9976-Technology Expert I jobs in the San Francisco, CA area right now.

AI Assistant is available now!