Data Engineer – Information Technology - San Francisco Human Services Agency (1053) (151506)

Data Engineer – Information Technology - San Francisco Human Services Agency (1053) (151506)

• Full-time
• Certification Rule: Rule of 3
• Exam Type: Position Based Test
• Work Hours: Regular
• Job Code and Title: 1053-IS Business Analyst-Senior
• Fill Type: Permanent Civil Service
• Eligible List Type: Combined Promotive and Entrance

This is a Position-Based Test conducted in accordance with CSC Rule 111A.

Who We Are

At the San Francisco Human Services Agency (HSA), we believe in a San Francisco where everyone has the opportunity and support to achieve their full potential. We are comprised of the Department of Benefits and Family Support, and the Department of Disability and Aging Services, and are united by our commitment to deliver essential services that support and protect people, families, and communities.

From financial, nutritional and employment support to child and adult protective services, health care coverage, and in-home services for older adults and persons with disabilities, our team lends support for all in need.

Our Commitment to Racial Equity

As we work towards our vision of an inclusive San Francisco, we embrace our responsibility to root out systemic racism by creating services and a workforce which reflect the lived experiences and strengths of the people we serve. We are committed to fostering a work environment where our differences are celebrated and everyone has what they need to thrive--no matter their race, age, ability, gender, sexual orientation, ethnicity, or country of origin.

Under general direction, this role serves as an expert for data integration projects and supports the completion of various data initiatives. Key responsibilities include assisting with all phases of data integration projects, optimizing data integration jobs to ensure efficient and reliable data ingestion from various data sources and working collaboratively with architects, business analysts, and data analysts.

ESSENTIAL DUTIES AND FUNCTIONS

According to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job code/class and are not intended to be an inclusive list; this position may include additional duties as assigned.

• Coordinates and conducts end user sessions to understand the business and document business processes.
• Assists in preparing comprehensive data requirements for data warehousing and data integration efforts.
• Design dimensional models for a data warehouse that supports advanced analytics and reporting ensuring data consistency and scalability.
• Supports with building complex ETL/data integration solutions using Microsoft SSIS or Oracle Data Integrator (ODI) to populate the data warehouse.
• Aids in performing unit testing and regression testing of data integration solutions developed in Microsoft SSIS & ODI.
• Collaborates effectively with data scientists, data analysts and stakeholders to design, implement and optimize data models and data flows for different analytics needs.
• Evaluate and optimize database queries and ETL processes for performance, ensuring timely data delivery and improving data latency.
• Analyzes and develops complex ad hoc data extracts, reports to support decision makers.
• Ensures data results are verified and data issues are debugged.
• Maintains thorough documentation of data architecture, data model and data integration processes.

Minimum Qualifications:

1. Education:
a) An associate degree in business administration, public administration, information systems, economics, finance, computer science or a closely related field from an accredited college or university
OR
b) 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 one of the fields above or a closely-related field).

AND

2. Experience: Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

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 one of the fields above or a closely related field.

Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

DESIRABLE QUALIFICATIONS:

• Three (3) years of experience with Microsoft SSIS or Oracle Data Integrator (ODI)
• Three (3) years of experience with SQL tuning or Query Optimization

The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

VERIFICATION OF EXPERIENCE AND/OR EDUCATION:

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process.

Selection Procedures:

Candidates who meet the Minimum Qualifications will be invited to complete the Supplemental Questionnaire Examination. This exam is designed to measure knowledge, skills and/or abilities in job-related areas which may include but not be limited to: problem-solving skills; a deep understanding of data integration, optimizing data feeds; experience with cloud platforms; prepare technical specifications; produce complex reports, coordinate technical procedures and complex reporting requirements; knowledge of information systems; ability to assist with developing and implementing policies, systems and procedures; ability to identify, analyze and report upon activities, issues, and problems and recommend appropriate solutions; ability to establish and maintain effective working relationships.

A passing score must be achieved on the Supplemental Questionnaire Examination in order to continue in the selection process.

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.

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.