1043 Senior IS Engineer - BI Engineer
|Department||Human Services Agency|
|Date Opened||4/18/2017 08:00:00 AM|
|Filing Deadline||6/12/2017 5:00:00 PM|
|Salary||$55.53 - $69.83/hour; $9,624.00 - $12,103.00/month; $115,492.00 - $145,236.00/year|
|Job Type||Permanent Exempt|
Applications will be accepted on a continuous basis, until position is filled. Qualified applicants are encouraged to apply immediately as the announcement can close at ANY time but not before May 10, 2017.
Permanent Exempt appointment not to exceed three (3) years. – This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer.
ABOUT THE BUSINESS INTELLIGENCE AND DATA WAREHOUSING TEAM
Business Intelligence (BI) and Data Warehouse is a new unit in the Human Services Agency (HSA) Department of Information Technology established to consolidate data from different data sources, validate data and to empower our agency to develop Operational and Strategic reporting capabilities. The objective of integrating different data bases and developing the capabilities to slice and dice data will help our Agency derive better insights in order to improve our operations and increase our customer satisfaction. The scope of the project is to provide the ability of performing business analysis and intelligence across Human Services Agency. The team is responsible for procuring and integrating data from the various systems within the HSA to build out executive dashboards and ad hoc reporting solutions.
The BI & Data Warehousing team at HSA is on the move! With that, we are seeking technologists that are committed to using their tech skills to enrich the lives of others and the community. HSA is looking for a Report Designer to architect, design and support the implementation and maintenance of critical dashboards and subject areas for its reporting teams. You will be collaborating directly with the different analysts in the organization to decipher reporting requirements. You will be working on delivering key reports and building out new subject areas to support critical analytics that would help our residents and the community. We are looking for an expert in their field who is technical, strategic, collaborative and analytical. If you are committed to serving the City of San Francisco, city agencies and its residents, we want to speak to you today!
1. Develop reports in Oracle on-premise, Oracle BI cloud, Hyperion or similar business intelligence reporting tools.
2. Develop and create BI reporting solutions by utilizing the Microsoft BI/Oracle BI stack which includes: SQL Server (i.e. t-sql, stored procedures, query optimization), Reporting Services, Analysis Services (OLAP), Power BI and Excel pivot tables & graphs.
3. Validate source data against output to ensure data quality and validate ETL design.
4. Create and manage ad-hoc/canned reports and dashboards.
5. Determine operating characteristics and requirements; develop or modify and document general system design; write detailed design specifications; conduct "walkthroughs" for proposed solutions to system problems.
6. Design and develop program specific business intelligence reports; program specific ad-hoc reports; appropriate ETL for Oracle B.I database; Oracle business intelligence dashboards.
7. Perform other duties as assigned.
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].
Three (3) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of an enterprise network system.
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.
How To Apply
Applications for City and County of San Francisco jobs are only accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.
-Select the desired job announcement (PEX-1043-075734)
-Select “Apply” and read and acknowledge the information
-Select either “I am a New User” if you have not previously registered, or “I have
-Follow instructions on the screen
Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.
Applicants may be contacted by email about this announcement 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).
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.
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.
Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.
If you have any questions regarding this recruitment or application process, please contact the exam analyst, Zach DeRossette, by telephone at 415.557.6402, or by email at firstname.lastname@example.org
The selection process will include evaluation of applications in relation to minimum requirements. Applicants meeting the minimum qualifications are not guaranteed advancement through the selection process. 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.
Only candidates who are most qualified and whose backgrounds best match the position will continue in the selection process.
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. Refer to the following links for verification:
Verification Guidelines: http://www.sfdhr.org/index.aspx?page=20#verification
Education Verification: http://www.sfdhr.org/modules/showdocument.aspx?documentid=18441
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.
As a finalist for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a finalist. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:
- Candidates applying for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
- Candidates applying for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.
Having a conviction history does not automatically preclude you from a job with the City.
If you are selected as a finalist, the hiring department will contact you to schedule a fingerprinting appointment.
Disaster Service Workers
All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.
TERMS OF ANNOUNCEMENT
Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. The correction of clerical errors in an announcement may be posted on the Department of Human Resources website at www.jobaps.com/sf.
Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at:
General Information concerning City and County of San Francisco Employment Policies and Procedures:
Important Employment Information for the City and County of San Francisco can be obtained at http://www.sfdhr.org/index.aspx?page=20 or hard copy at 1 South Van Ness Avenue, 4th Floor.
Copies of Application Documents:
Applicants should keep copies of all documents submitted, as these will not be returned.
Right to Work:
All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.
Amended on 4/26/2017 to reflect changes in filing period.
Issued: April 18, 2017
Recruitment No.: PEX-1043-075734
Micki Callahan, Director
Department of Human Resources
Team: HSA/ZD 415.557.6402
All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.