Data Architect - ITT - SFO (9976)

Company DescriptionSan 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 (https://www.youtube.com/watch?v=nMh58Cer8kk&feature=youtu.be) .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. Learn more about careers at SFO. (https://www.youtube.com/watch?v=ifIUySwbSV0&feature=youtu.be) For more information about SFO, visit www.flysfo.com. Follow us on Twitter (https://www.twitter.com/flysfo)  and Facebook (https://www.facebook.com/flysfo) .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 after5:00pm on March 6, 2024.

Compensation Range:$157,326 to $213,148 annually

Please note, the last three steps in this salary range represent extended ranges that require department approval based upon recruitment/retention, special skills, limited duration, or exemplary performance.

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 (http://chrome-extension/efaidnbmnnnibpcajpcglclefindmkaj/https:/sfgov.org/civilservice/sites/default/files/34-Exempt-Appointments.pdf) , 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 are 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. This includes 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.

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 (2,000 hours of qualifying work experience is based on a 40-hour work week). 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 trough 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.

VerificationApplicants 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 athttps://sfdhr.org/how-verify-education-requirements.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 PROCEDURESSelection 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. Per Civil Service Commission Rule Section 110.9.1, every applicant for an examination must possess and maintain the qualifications required by law and by the examination announcement for the examination. Failure to obtain and maintain security clearanceCustoms ClearanceThis 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. Per Civil Service Commission Rule 110.9.1, every applicant must possess and maintain the qualifications required by law and by the examination announcement for this examination. Failure to acquire or maintain customs access, a requirement for this position, may be basis for termination from employment with the Airport Commission. Customs Access Seal requirements and procedures are located in the Code of Federal Regulations, Title 19, Part 122, Sections 181 or 189.Additional Information Regarding Employment with the City and County of San Francisco:

Information About The Hiring Process (https://sfdhr.org/information-about-hiring-process)

Conviction History

Employee Benefits Overview (https://sfdhr.org/benefits-overview)

Equal Employment Opportunity (https://sfdhr.org/equal-employment-opportunity)

Disaster Service Worker (https://sfdhr.org/disaster-service-workers)

ADA Accommodation

Right to Work (https://sfdhr.org/information-about-hiring-process#identification)

Copies of Application Documents

Diversity Statement (https://sfdhr.org/information-about-hiring-process#diversitystatement)

HOW TO APPLYApplications for City and County of San Francisco jobs areonlyaccepted through an online process. Visithttps://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/and begin the application process. Select the “I’m Interested” button and follow instructions on the screenApplicants 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. Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter. To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu, @smartalerts.info, and @smartrecruiters.com).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 atGabriella.a.rodriguez@flysfo.com.The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.