SYSTEM INTEGRATION DEVELOPER

Career Opportunity

SYSTEM INTEGRATION DEVELOPER

Recruitment: RTF0130364-01018744

Published: January 06, 2023

Contact:

Carol Wong - carol.x.wong@flysfo.com

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

Department: Technology
Job class: 9976-Technology Expert I
Role type: Permanent Exempt What does this mean?
Hours: Full-time

About:

In addition to submitting your application, you MUST submit the Supplemental Questionnaire found here: https://forms.gle/e4YkiAhxBEwTFbBS9

Applicants must complete the supplemental questionnaire prior to starting the online application process. The application will not be reviewed without a completed supplemental questionnaire.

Why Work for the Department of Technology (DT)? The Department of Technology (DT) is the centralized technology services provider in CCSF. We deliver technology infrastructure and services to approximately 33,000 employees! With an annual operating budget of over $140M and approximately 260 employees, DT provides a host of services that includes:

People-Centered Solutions: Working for San Francisco, you can have a powerful, meaningful effect on the community every day. When we solve problems, people are the heart of every solution!

Benefits of Working for CCSF: In addition to challenging and rewarding work, the City provides a generous suite of benefits to its employees.

Job security, pension, and robust retirement options
Competitive pay with consistent bi-yearly or yearly increases
Generous paid time off, family leave, and more!
Diverse work environment in a diverse city
Union protections and representation
Career development and growth — move between departments, learn on the job, or take subsidized/reimbursed classes!

CLOSING THE DIGITAL DIVIDE — bring the benefits of the internet to low-income and marginalized residents!

SHINE A LIGHT ON WHAT MATTERS — join an award-winning production team at SFGovTV to help residents watch legislators or learn more about what makes this City great!

DRIVE INNOVATION — deliver new, cutting-edge technology to residents and city partners to help San Francisco serve its residents!

Role description

The Department of Technology is looking for a System Integration Developer responsible for performing all aspects of the design, development, integration, installation, and support of the city data sharing hubs, applications, processes, and integrations. The Developer will perform these functions for secure citywide data sharing in production, test, and development environments and the related applications and integration components. The position will work with system architects and developers to build, upgrade, and enhance low code applications and systems to continue to meet the business needs and satisfy local, state, and federal laws that govern user access, data protection, and network security. This position performs work of a complex, technical nature and requires a high level of functional and technical skills.

The Department of Technology provides infrastructure and data platforms for city business systems. Data integration is between the various business systems simplifies data maintenance, management and analysis. This position will contribute to important data management and integration development projects that build an API environment, data catalogs, manage data in cloud environments and facilitate secure access to data lakes. Systems such as Shared Spaces and the JUSTIS Data Hub are examples of multi-department data sharing to meet business goals and outcomes for residents.

System Integration Developer will join an existing development division within the Department of Technology that designs, enhances, and supports data exchange hubs that serves the 24x7x365 operations of 8 critical San Francisco agencies.

Under general direction of a DT Technical Project Director, this position will be responsible for creating, designing, programming, and maintaining data lakes, data hubs and integration resources. These data resources can be in an on-premise architecture or commercial cloud environment and will allow integration with department business systems (case management, work order management, asset tracking, etc). This role requires expert level of knowledge and understanding of databases and system integration using Python, ETL, API programming with modern tools including Open Source as defined by DT. This System Integration Developer will also possess in-depth knowledge of graphical user interface design, complex algorithm coding, statistical analysis, GIS/mapping data and programming and criminal record processes and operations, as well as industry standards and government requirements such as CLETS, CJIS, NIST.

Position Responsibilities

Work with business to define and refine requirements to work within existing frameworks and identify the modifications required to existing components in order to meet the business requirements.
Work with application developers to provide solutions meeting business requirements featuring stability and flexibility in a timely manner.
Perform senior-level programming, implementing, managing, and supporting data lakes, data integrations, data exchange Hubs and related technologies on government projects. Develop SQL database and integrations with ETLs, Python, and APIs for integrations and external web applications.
Create, document, maintain and validate backup and disaster recovery methodologies.
Ensure compliance with regulatory requirements for secure data transmission, storage and data access including documentation, testing and remediation.
Track and maintain work via SNOW or JIRA.
Automate routine processes such as product loads where possible using available tools: procedures, packages, bash scripts, etc.
Contribute to integration, system, and performance testing, including developing test tools
Build and perform unit testing and system integration testing and assist with user acceptance testing.
Ensure data quality throughout entire data management process.
Assist with troubleshooting customer problems and finding solutions in a timely fashion.
Observe information security policies and CJIS and HIPAA guidelines of conduct to ensure the privacy and security of nonpublic information.
Proven record of working in a demanding environment and high stress situation with high level of accuracy and output. Ability to work with other team members and willing to assist teammates.

Work Location

Incumbent will conduct the majority of work at the Department of Technology located at 1 South Van Ness Avenue, 2nd Floor, San Francisco, CA 94103. However, there may be situations where the incumbent will be required to work at other sites throughout the City of San Francisco as necessary. DT has a hybrid work schedule that requires a minimum of 4 days of in-office time per month (every week or every two weeks).

Nature of Work

Incumbent must be willing to work a 40-hour week as determined by the department. Travel within San Francisco is required.

How to qualify

An associate degree in computer science or 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].
AND
Experience: Five (5) years of experience in software development experience building web applications and interfaces using web services, data conversions and application extensions (ETL, APIs), hands-on experience designing and implementing government business applications.

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 or forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

Desirable Qualifications

15+ years of experience years software development experience building web applications and interfaces using web services, data conversions and application extensions (ETL, APIs)
15+ years of hands-on experience designing and implementing government business applications
Must be able to complete a federal background investigation.
Knowledge of data pipelines built-in either the Open-Source or Microsoft Stack
Strong knowledge of data modeling concepts
Experience working with source control systems such as GIT or JIRA
Ability to execute projects and tasks with minimal guidance and supervision
Excellent oral and written communication skills
Excellent data gathering, analytical, and problem-solving skills
Experience with modern technology service architectural hosting, security, and risk management concerns (e.g., Data Warehouse, Data Engineering Pipeline, Data Preparation and Modeling, Advanced - Analytics, Data Services, and Consumption).
Experience in Agile/Scrum, or ITIL principals with experience implementing one of these practices preferred.
Final job offer is conditional on the applicant's passing a background check

Note:

1. Security Clearances & Background Investigations: Positions in this classification may require that successful candidates who become eligible for appointment may be required to go through a background investigation to determine the candidate’s suitability for employment in this classification. Factors considered in the investigation may include employment history, use of illegal/controlled substances. Reasons for rejection based on this investigation may include, but not limited to: applicable convictions, repeated or serious violations of the law, inability to accept supervision, inability to follow rules and regulations, falsification of application materials and/or other relevant factors. Failure to obtain and maintain security clearance may be basis for termination.

Verification: Applicants may be required to submit verification of qualifying education and experience at any point in the application and/or departmental selection process. Written verification (proof) of qualifying experience must verify that the applicant meets the minimum qualifications stated on the announcement. Written verification must be submitted on employer’s official letterhead, specifying name of employee, dates of employment, types of employment (part-time/full-time), job title(s), description of duties performed, and the verification must be signed by the employer. City employees will receive credit for the duties of the class to which they are appointed. Credit for experience obtained outside of the employee’s class will be allowed only if recorded in accordance with the provisions of the Civil Service Commission Rules. Experience claimed in self-employment must be supported by documents verifying income, earnings, business license and experience comparable to the minimum qualifications of the position. Copies of income tax papers or other documents listing occupations and total earnings must be submitted. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at http://sfdhr.org/index.aspx?page=456.

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.

What else should I know?

Appointment Type: Permanent Exempt (PEX) - Full Time, this position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointment officer. The duration of this position is up to 36 months.

Compensation:
$150,124 to $188,812 annually ($72.1750 to $90.7750 hourly)

How to Apply:

In addition to submitting your application, you MUST submit this supplemental questionnaire
Your application MUST include a resume. To upload, please attach using the "additional attachments" function.

You may contact Carol Wong via email at carol.x.wong@sfgov.org with questions regarding this opportunity.

Late or incomplete submissions will not be considered. Mailed, hand delivered or faxed documents/applications will not be accepted.

Helpful Information

All your information will be kept confidential according to EEO guidelines.

CONDITION OF EMPLOYMENT: All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

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.