Prepare for and practice interview questions from City And County Of San Francisco.

City And County Of San Francisco Interview Questions

City And County Of San Francisco Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

City And County Of San Francisco Salaries by Position

<h3>Job Description</h3><div>Job Description<div>Company Description Hybrid Workplace: Our workplace has a hybrid/flexible weekly schedule, where colleagues work 1 day onsite (in the San Francisco office) and 4 days from home, subject to periodic review and approval.Controller’s Office The Controller is the City’s chief financial officer.  Our team includes financial, technology, analytical, and other professionals who work hard to secure the City’s financial integrity and promote efficient, effective, and accountable government.  We hold ourselves to high standards and strive to be a model for good government.  We value the diverse backgrounds, perspectives and lived experiences of our teams and clients in everything we do.  We work in a collaborative and inclusive environment, promote equal opportunity, and invest in the professional development and well-being of our team members.  You can expect to work alongside colleagues who are committed to serving the public with integrity and want to see positive impacts from their work.  We are looking for smart, motivated individuals who want to make a difference and use government to play a role in solving our City’s issues, including addressing long-standing and harmful disparities in our communities.  For a career with purpose and professional growth, join us in the Controller’s Office!   Systems Division of the Controller’s Office: The Systems Division of the Controller’s Office manages the City and County of San Francisco’s Enterprise Oracle and PeopleSoft Applications, which include Oracle Interaction Hub, PeopleSoft Human Capital Management (HCM), PeopleSoft Financials and Supply Chain Management (FSCM), PeopleSoft Enterprise Learning Management (ELM), and Oracle Business Intelligence.  These applications are branded locally as our SF Employee Portal, SF People & Pay, SF Financials, SF Procurement, SF Learning, and SF Reports and Analytics systems.  Collectively, these applications provide a robust, integrated platform that delivers mission-critical services to 55 City Departments, eliminating the need for hundreds of independent legacy systems and customized applications.  The division serves over 35,000 active City employees, 75,000 retirees and 25,000 City vendors (bidders and suppliers).  Peripheral and legacy applications also leveraged by the division include Oracle Identify & Access Management, Sherpa Budget Formulation & Management, Phire Architect, Control-M, and FreshWorks.  The technology implemented and maintained by the Systems Division provides standardization, transparency, and efficiency for the City’s crucial business processes. Users are fully supported to ensure adoption of these interconnected functionalities.Specific information regarding this recruitment process are listed below:  <ul><li>Application Opening:  6/14/2024</li><li>Application Deadline:  Continuous </li><li>Compensation:  $125,086 - $157,378</li></ul>Job Description The Reporting Analyst position will be part of the Business Intelligence and Reporting Team and will work with members of the project’s Functional and Change Management Teams and other City and County staff to Develop and Maintain Oracle Business Intelligence (OBIEE) system. The reporting analyst will perform both functional (business process and systems analysis, testing, user support) and technical (data extract, load and transformation, metadata modeling, Dashboard Development, Query tuning, and troubleshooting) tasks. Working knowledge with Oracle Business Intelligence tool sets like Oracle ODI/ OBIA / OBIEE is strongly desired.Essential duties include but are not limited to: analyzing the interrelationships of business processes, complex financial data and systems to develop reporting requirements and data structures; performing fit/gap analysis; defining and implementing application configuration settings; working with the project team on transition plans for re-engineered business processes; analyzing and testing security roles and permissions; writing technical specifications; designing and building solutions to specifications; developing and executing system and user acceptance test plans and evaluating test results; developing and providing support and training for users in person, on the phone and in workshops; writing business and system process and technical documentation; identifying, managing and escalating issues and risks throughout software development life cycle; performing other duties as assigned.Qualifications Education:  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 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].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.License and Certification: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:The stated desirable qualifications will be used to identify job finalists at the end of the selection process when candidates are referred for hiring.<ul><li>Hands on working experience with OBIA 11g (with ODI 12C), including the following:<ul><li>Oracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Time and Labor, Payroll)</li><li>OBIEE 12.2.1.1 and above (RPD and Dashboard Development)</li><li>Extending out-of-the-box OBIA RPD with custom fact tables and metrics</li></ul></li><li>Strong hands on experience with SQL Scripting and PL/SQL experience</li><li>Setup and integration of OBIEE/OBIA/ODI with various systems such as PeopleSoft and / or EBS</li><li>Working with DBAs, BI Dev, PeopleSoft and / or EBS Functional Teams, and Security teams to improve performance and data quality using Agile sessions</li><li>Deep understanding of Data Warehouse concepts and working knowledge of data modeling in large data warehouses.</li><li>Working knowledge with Business Intelligence tool sets like Oracle OBIEE/ SAP Business Objects / IBM Cognos / MS Power BI.</li><li>Experience analyzing, creating, documenting functional business/application solutions with clients and/or end users for large complex BI systems. This experience must include:</li><li>Experience with formal software development life cycle methodologies i.e. SDLC, .</li><li>Working knowledge of business process flows used to support a complex Data warehouse, and experience in developing and executing Data Extraction and Dashboards.</li><li>Expertise in utilizing appropriate tools for analyzing data, documenting processes, developing and testing prototype solutions, including Oracle SQL Query, Visio, MS Access, FTP.</li><li>Senior level experience in enterprise relational database and/or On-line Analytical Processing (OLAP) modeling and design. </li></ul>   Additional Information 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 at https://sfdhr.org/how-verify-education-requirementsNote: 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.SELECTION PLANInterviews:  Selected candidates will be invited to participate in one or more interviews at the Controller’s Office.Additional Information Regarding Employment with the City and County of San Francisco:<ul><li>Information About The Hiring Process</li><li>Conviction History</li><li>Employee Benefits Overview  </li><li>Equal Employment Opportunity </li><li>Disaster Service Worker</li><li>ADA Accommodation</li><li>Veterans Preference</li><li>Right to Work</li><li>Copies of Application Documents</li><li>Diversity Statement</li></ul><div></div>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.</div></div>

Job Description

Project Name: Improving and Modernizing SFPUC's Water Data Management System

Reporting Location: 525 Golden Gate Ave., SF, CA 94102

Work Hours: Monday through Friday, 8:00am to 5:00pm (Hybrid)

The San Francisco Public Utilities Commission (SFPUC) Water Enterprise is looking for a Water Data Analyst to support the Hydrology and Water Systems (HAWS) group within the Water Administration and Analytics Division. The Water Data Analyst will perform various analytical tasks and report to the Senior Water Resources Engineer. The HAWS group plays a pivotal role in providing watershed and water systems analyses for water supply planning and operational purposes within the Water Enterprise. This involves collecting diverse climatic, hydrologic, and water resources data, which reside in the SFPUC’s database program. These data are essential in supporting streamflow forecasting, climate change studies, hydrologic modeling, water supply modeling, and other critical projects.

Essential Duties:

Upgrade, improve and modernize the water data management system

Perform complex data management, processing, and analysis activities of different projects related to streamflow forecasting, climate change studies, and water supply modeling

Collaborate with different teams within SFPUC Water Enterprise, SFPUC Information Technology Services, and software vendors to ensure seamless upgrades of the data management server and software version

Review and convert existing reporting tools to a modern scripting language (such as Python)

Develop and produce necessary training manuals and Standard Operating Procedures (SOPs) for SFPUC users

Perform other related duties as assigned.

Qualifications:

Education: 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 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].

Experience: One (1) year in the information systems field, including technical support, content management, administration of network applications or system analysis.

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:

One year of experience with computer programming languages. Experience with Python, R, and Visual Basic preferred.

One year of experience using and managing database programs.

Experience working with server management, software version control, and working experience in a cloud environment.

Experience in water and watershed-related data handling.

Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad.

Verification of Education and Experience:

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

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.

HOW TO APPLY

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit here to begin the application process.

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

Job Analyst Information: If you have any questions regarding this recruitment or application process, please contact the job analyst, Crystal Liu at cliu@sfwater.org

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

#J-18808-Ljbffr

<h3>Job Description</h3><div>Job Description<div>Company Description Appointment Type: Permanant Exempt (PEX), this position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer. AMENDED: This is a Full-Time position. The San Francisco Digital Services (SFDS) Team is transforming how residents interact with the City, by building services designed around the people that use them. The team improves the public’s experience with the city by delivering high-quality, accessible experiences for the website, in-person experiences and for the city employees supporting these services.SFDS is composed of product managers, designers, developers, and content strategists. As a member of this team, you would be part of a new and growing movement, with an opportunity to shape the City’s approach to technology.Our ValuesWe are committed to equity in our hiring, team culture, and product outcomes and to fostering an inclusive work environment. We are building a team that reflects a diverse set of lived experiences and identities. This effort includes considering qualified candidates across a spectrum of races, colors, religions, genders, gender identities, sexual orientations, national origins, genetics, disabilities, ages, or veteran status.  If you’re looking for a team where you can make an impact and improve the lives of all San Francisco residents, then we want to hear from you.Job Description The Chief Data Officer (CDO) is a senior technical leader in the City and a champion for transparency and better services through data sharing. This position is a Mayoral Appointment and is enshrined in the City’s Administrative Code (Sec. 22.D).A primary responsibility is to ensure the code is met by continuing DataSF’s work to develop the City’s open data portal and working with departments to bring their data online in useful and usable formats.Under the direction of the Chief Digital Services Officer, the CDO leads a team of six specializing in data and analytics. Responsibilities include setting data standards and governance, setting the Citywide data strategy, and working closely with our departments to support them on data transparency both internally and externally.The CDO also: <ul><li>Oversees the ongoing development of San Francisco’s open data platform, and continue work with departments to create data transparency through this central directory.</li><li>Owns, develops and implements the City’s Data Strategy</li><li>Works in coordination with the City Administrator’s Office to adopt rules and regulations that are consistent with the Charter and that implement the Privacy First Policy, including the privacy principles stated in Charter Section 16.130(e).</li><li>Engages with departments and stakeholders across the City to communicate the importance of open data, analytics, and internal data sharing for better services and decision-making</li><li>Identifies opportunities for internal data sharing that will lead to better services and better data for decision making.</li><li>Establishes and sustain citywide training programs for data practices</li><li>Leads critical analytics projects driven by mayoral priorities</li><li>Participates as a leader within Digital and Data Services, and as a respected senior technologist</li></ul>Work Location: Incumbent will conduct the majority of work at San Francisco Digital Services (1 S Van Ness, Ave San Francisco, CA 94103).  Employees may be permitted to work a hybrid schedule with supervisor approval, after which they must work at least one day in the office every week.Qualifications Minimum qualifications<ul><li>Possession of a baccalaureate degree from an accredited college or university; AND</li><li>Five (5) years of professional experience within a governmental or private sector organization, developing and implementing policies related to open data and/or data governance</li><li>Three (3) years of experience managing professional staff.</li></ul>Desirable Qualifications<ul><li>A bachelor or master’s degree in either a data or policy field</li><li>Experience managing data and data products in regulated industries or government</li><li>Experience with any of our major service domains: affordable housing, city planning, business permitting, public health, emergency services, grantmaking, budget transparency, etc</li><li>Experience managing Data teams specifically</li><li>Experience working in multidisciplinary teams with product managers, designers, engineers, and policy staff</li><li>Experience teaching and mentoring data professionals</li><li>Public sector experience of any kind as a professional or volunteer</li><li>Past experience as a hands-on engineer or analyst working with data</li><li>Past excellent relationships with cross-disciplinary peers</li><li>Experience presenting and negotiating at executive level, with technical and non-technical audiences</li><li>Strong communicator orally and in writing - persuasive, authentic, and clear</li><li>Bilingual experience is always valuable to our team</li><li>Self awareness and humility</li></ul> Additional Information Application Opening: August 16, 2024  (amended August 19, 2024) Applicants are encouraged to apply immediately as this recruitment may close at any time, but not before Friday, August 30, 2024.Salary Range: $77.70 - $99.1375 (hourly) / $161,616 - $206,206 (annually)You may contact Lawlun Leung via email at lawlun.leung@sfgov.org with questions regarding this opportunity.Important: Your application must include a resume and a cover letter that explains why you are applying for this job, and how your experience makes you a good fit for this role. To upload these items, please attach using the "additional attachments" function.Guidance for Applying:  Applicants must include all relevant job experience in the online application.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. Late or incomplete submissions will not be considered. Mailed, hand delivered or faxed documents/applications will not be accepted.Helpful Information <ul><li>Information About The Hiring Process </li><li>Conviction History </li><li>Employee Benefits Overview   </li><li>Equal Employment Opportunity  </li><li>Disaster Service Worker </li><li>ADA Accommodation </li><li>Veterans Preference </li><li>Right to Work </li><li>Copies of Application Documents </li><li>Diversity Statement </li></ul>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.<div></div>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.</div></div>

The Office of City Administrator and its 20+ divisions and departments operate core internal and public-facing services. Our vision is to lead the nation in public administration and to enable City departments to effectively deliver critical public services. We aim to help the City run better, to connect San Francisco residents and constituents to the vital public services they seek, and to create a meaningful, diverse and inclusive work culture that is the place of choice for people who are invested in a career in public service. To learn more about our departments, divisions, and programs, click here: https://sf.gov/departments/city-administrator IMPORTANT: AS PART OF THE APPLICATION PROCESS, PLEASE SUBMIT AN APPLICATION AND CLICK ON THE LINK BELOW TO SUBMIT A RESPONSE TO THE SUPPLEMENTAL QUESTIONNAIRE. BOTH ARE REQUIRED AS PART OF THE APPLICATION PROCESS. 1822-Project & Data Analyst - Government Operations Recovery Initiative (Gov Ops)- Supplemental Questionnaire (https://forms.office.com/g/1j5TT4D4ES) About Gov Ops During the Citys response to and recovery from the COVID-19 pandemic, we saw firsthand how some of the Citys core operational processes could be improved. This includes contracting and procurement, where the Citys processes can be complex, time-consuming, and resource-intensive for both City staff and suppliers. In April 2022, the City Administrators Office, Controllers Office, and Department of Human Resources came together to launch the Government Operations Recovery Initiative (Gov Ops), a special initiative aimed at addressing staff shortages, contracting backlogs, and financial system challenges that make it difficult to operate effectively and efficiently. Under this initiative, the three offices have created project teams to serve as project managers, subject-matter-experts, and business analysts to plan and manage complex projects to streamline processes related to hiring, procurement and financial operations. The Contract Reform Team The Project & Data Analyst will join the Gov Ops Contracting & Procurement Reform Team under the City Administrators Office. Our team works on special projects that help reduce administrative burden and lower barriers to participating in public procurement opportunities to advance the Citys equitable contracting goals. While this core team is small, the team works in close partnership with a number of other City departments and divisions who are involved in procurement and contracting, including but not limited to the Office of Contract Administration (OCA), the Contract Monitoring Division (CMD), the Department of Technology (DT), the Controllers Office (CON), and contracts managers and analysts from around the City. In our work, we strive to be dynamic and responsive to City staff and supplier needs, and we are guided by the key questions such as: + How do we build better systems while minimizing unintended consequences and any potential adverse effects of change and transitions? + How do we orient our work around the challenges that small, local businesses, and community providers face to ultimately lower barriers to accessing public procurement opportunities for all? + How do we balance a bold vision for the future with practicality and feasibility? Job Description As a Project & Data Analyst, you will play a critical part in crafting and implementing reform projects to improve the Citys procurement and contracting processes and support its supplier community. In addition, you will work alongside other team members to build out reports, dashboards, and data infrastructure to support the teams performance portfolio. This is an exciting opportunity for someone who is motivated by complex but compelling challenges in governance, excels in robust data collection, analysis, and presentation, is interested in finding the balance between incremental and transformational changes, is dedicated to ensuring that public institutions serve communities equitably, enjoys bringing order to ambiguity, and sees themselves as a budding public sector leader. The projected responsibilities for this role are described below. We are interested in bringing on someone who will grow and thrive in this role, so we encourage anyone who has an emerging interest in public procurement and data analysis and enjoys learning new skills and concepts to apply. The candidate who fills this role will be supported by members of our team and will enjoy increasing ownership and agency over projects over time. Business Process Analysis and Project Management + Analyze business processes, identify opportunities for improvement, and make recommendations for new procedures and applications. + Take ownership of multiple projects and/or workstreams, from conceptualization to hand-off and/or close-out, with the support of the Gov Ops team. + Conduct research and analysis on promising procurement practices, policies, administrative, and regulatory issues pertaining to procurement and contracting. Data Analysis, Reporting, & Dashboarding + Work with key stakeholders to identify challenges and prioritize business and information needs. + Acquire data from primary and secondary data sources; perform data extraction, transformation, and loading (ETL) to prepare data for analysis. + Develop and present key insights from data; design and develop reports and dashboards to assist in data-driven decision-making, support auditing activities, and meet management needs. + Identify procurement trends and prepare reports with recommendations and appropriate justifications based on studies and surveys. + Maintain databases and data systems in support of this work. Partnership and Communications + Coordinate action items across multiple implementation partners and monitor project progress to ensure that deliverables are fulfilled in a timely manner. + Support the creation of memos, slide decks, and other deliverables to communicate recommendations and project milestones. + Maintain project tracking tools to ensure proper resourcing, timelines, stakeholder engagement, etc. are implemented. Other projects, tasks, and duties as assigned. Desirable Qualifications + Experience with data visualization software such as Tableau, Power BI, Oracle BI, etc. + Experience using databases and developing queries. + Excellent written and verbal communication skills. + Strong analytical and problem-solving skills. + Is creative, flexible, collaborative, and adaptable. + Experience coordinating projects across many stakeholders. Education: Possession of a baccalaureate degree from an accredited college or university, and Experience: One (1) year full-time equivalent experience performing professional-level analytical work. Qualifying professional-level analytical work includes analysis, development, administration, and reporting in major programs and functions of an organization in areas such as budgets, contracts, grants, policy, or other functional areas related to the duties of positions in the 182X Class series. Substitution: Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework in specialized subject matter areas such as public or business administration, management, business law, contract law, public policy, urban studies, economics, statistical analysis, finance, accounting or other fields of study closely related to the essential functions of positions in the Class series may be substituted for the required one (1) year of experience. Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of 2 years). Thirty (30) semester units or forty-five (45) quarter units equal one year. + 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 + Veterans Preference (http://sfdhr.org/information-about-hiring-process#veteranspreference) + Right to Work + Copies of Application Documents (https://sfdhr.org/information-about-hiring-process#copies) + Diversity Statement + Interested candidates are encouraged to apply AND complete the Supplemental Questionnaire as soon as possible, as this job announcement will close at any time, but not earlier than August 30, 2024 at 11:59pm. + Late or incomplete submissions will not be considered. Mailed, hand delivered or faxed documents/applications will not be accepted. + For questions or inquiries, please contact: Elbi Magana, Human Resources Analyst at elbi.magana@sfgov.org + Your application MUST include a resume. To upload these item, please attach using the "additional attachments" function. 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 employers 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 employees 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 ones 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. Applications will be screened for relevant qualifying experience. Additional screening mechanisms may be implemented in order to determine candidates qualifications. Only those applicants who most closely meet the needs of the Agency will be invited to participate in the selection process. Applicants meeting the minimum qualifications are not guaranteed advancement to the interview. Qualified applicants with disabilities requiring reasonable accommodation in the selection process must contact the Agency by phone at (415) 554-6065 or, if hearing impaired at (415) 554-6015 (TTY). 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.

Hybrid Workplace: Our workplace has a hybrid/flexible weekly schedule, where colleagues work 1 day onsite (in the San Francisco office) and 4 days from home, subject to periodic review and approval. Controllers Office The Controller is the Citys chief financial officer. Our team includes financial, technology, analytical, and other professionals who work hard to secure the Citys financial integrity and promote efficient, effective, and accountable government. We hold ourselves to high standards and strive to be a model for good government. We value the diverse backgrounds, perspectives and lived experiences of our teams and clients in everything we do. We work in a collaborative and inclusive environment, promote equal opportunity, and invest in the professional development and well-being of our team members. You can expect to work alongside colleagues who are committed to serving the public with integrity and want to see positive impacts from their work. We are looking for smart, motivated individuals who want to make a difference and use government to play a role in solving our Citys issues, including addressing long-standing and harmful disparities in our communities. For a career with purpose and professional growth, join us in the Controllers Office! Systems Division of the Controllers Office: The Systems Division of the Controllers Office manages the City and County of San Franciscos Enterprise Oracle and PeopleSoft Applications, which include Oracle Interaction Hub, PeopleSoft Human Capital Management (HCM), PeopleSoft Financials and Supply Chain Management (FSCM), PeopleSoft Enterprise Learning Management (ELM), and Oracle Business Intelligence. These applications are branded locally as our SF Employee Portal, SF People & Pay, SF Financials, SF Procurement, SF Learning, and SF Reports and Analytics systems. Collectively, these applications provide a robust, integrated platform that delivers mission-critical services to 55 City Departments, eliminating the need for hundreds of independent legacy systems and customized applications. The division serves over 35,000 active City employees, 75,000 retirees and 25,000 City vendors (bidders and suppliers). Peripheral and legacy applications also leveraged by the division include Oracle Identify & Access Management, Sherpa Budget Formulation & Management, Phire Architect, Control-M, and FreshWorks. The technology implemented and maintained by the Systems Division provides standardization, transparency, and efficiency for the Citys crucial business processes. Users are fully supported to ensure adoption of these interconnected functionalities. Specific information regarding this recruitment process are listed below: + Application Opening: 6/14/2024 + Application Deadline: Continuous + Compensation: $125,086 - $157,378 The Reporting Analyst position will be part of the Business Intelligence and Reporting Team and will work with members of the projects Functional and Change Management Teams and other City and County staff to Develop and Maintain Oracle Business Intelligence (OBIEE) system. The reporting analyst will perform both functional (business process and systems analysis, testing, user support) and technical (data extract, load and transformation, metadata modeling, Dashboard Development, Query tuning, and troubleshooting) tasks. Working knowledge with Oracle Business Intelligence tool sets like Oracle ODI/ OBIA / OBIEE is strongly desired. Essential duties include but are not limited to: analyzing the interrelationships of business processes, complex financial data and systems to develop reporting requirements and data structures; performing fit/gap analysis; defining and implementing application configuration settings; working with the project team on transition plans for re-engineered business processes; analyzing and testing security roles and permissions; writing technical specifications; designing and building solutions to specifications; developing and executing system and user acceptance test plans and evaluating test results; developing and providing support and training for users in person, on the phone and in workshops; writing business and system process and technical documentation; identifying, managing and escalating issues and risks throughout software development life cycle; performing other duties as assigned. Education: 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 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]. 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. License and Certification: 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: The stated desirable qualifications will be used to identify job finalists at the end of the selection process when candidates are referred for hiring. + Hands on working experience with OBIA 11g (with ODI 12C), including the following: + Oracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Time and Labor, Payroll) + OBIEE 12.2.1.1 and above (RPD and Dashboard Development) + Extending out-of-the-box OBIA RPD with custom fact tables and metrics + Strong hands on experience with SQL Scripting and PL/SQL experience + Setup and integration of OBIEE/OBIA/ODI with various systems such as PeopleSoft and / or EBS + Working with DBAs, BI Dev, PeopleSoft and / or EBS Functional Teams, and Security teams to improve performance and data quality using Agile sessions + Deep understanding of Data Warehouse concepts and working knowledge of data modeling in large data warehouses. + Working knowledge with Business Intelligence tool sets like Oracle OBIEE/ SAP Business Objects / IBM Cognos / MS Power BI. + Experience analyzing, creating, documenting functional business/application solutions with clients and/or end users for large complex BI systems. This experience must include: + Experience with formal software development life cycle methodologies i.e. SDLC, . + Working knowledge of business process flows used to support a complex Data warehouse, and experience in developing and executing Data Extraction and Dashboards. + Expertise in utilizing appropriate tools for analyzing data, documenting processes, developing and testing prototype solutions, including Oracle SQL Query, Visio, MS Access, FTP. + Senior level experience in enterprise relational database and/or On-line Analytical Processing (OLAP) modeling and design. 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 https://sfdhr.org/how-verify-education-requirements Note: Falsifying ones 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. SELECTION PLAN Interviews: Selected candidates will be invited to participate in one or more interviews at the Controllers Office. 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 + Veterans Preference (http://sfdhr.org/information-about-hiring-process#veteranspreference) + Right to Work + Copies of Application Documents (https://sfdhr.org/information-about-hiring-process#copies) + Diversity Statement 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.

City And County Of San Francisco Interview Questions

City And County Of San Francisco Interview Guides

City And County Of San Francisco Interview Questions

City And County Of San Francisco Salaries by Position

City And County Of San Francisco Opening Jobs