<h3>Job Description</h3><div>Job Description<div>Will you help hard working San Franciscans get reimbursed for their health care? We're looking for an experienced Insights Data Analyst reporting to the Director of Product Management & Analytics. You will utilize advanced SQL queries and a strong knowledge of databases to extract and report on critical data components and help improve the accuracy of our outreach, answering important business questions for the San Francisco Medical Reimbursement Account (SF MRA) program. You will bring strong SQL skills, a good understanding of relational databases, the ability to develop detailed business requirements and fine-tuned attention to detail to check datasets for accuracy.Please note that while SFHP supports a hybrid work environment, this role will be required to be onsite and in-office a minimum of 4 days per month.Salary: $82,000 - $91,000/yearWHAT YOU WILL DO:<ul><li>Collaborate with colleagues with different levels of data literacy on the business side, as well as other Insights & Analytics team members and data engineers, to gather business requirements.</li><li>Learn about the numerous datamart tables and fields that house information on the SF MRA program, and combine this with your understanding of relational databases, so that you can write precise requirements and compare new datasets to existing ones.</li><li>Accurately write moderately sophisticated SQL queries, in a way that is easy for another analyst to understand, so that you can extract and manipulate data to answer business questions quickly. For example,<ul><li>Use appropriate joins</li><li>Pivot data from long to wide format</li><li>Simplify complex queries by using temporary tables</li><li>Use date functions</li></ul></li><li>Convert character variables to dates or dollar amounts and remain engaged with a complex data problem through to resolution.</li><li>Review your own and others’ work to catch obvious and not-so-obvious errors.</li><li>Learn about the SF MRA program, so that you are well placed to understand business needs and recommend appropriate data sources and analysis plans</li><li>Expand on core data analysis skills to take on more challenging work using a broader array of data tools.</li><li>Foster an environment that solicits and enlists diverse and inclusive perspectives and approaches to better serve our staff, our members and our providers. </li></ul>WHAT YOU WILL BRING<ul><li>A degree from a four-year college bachelors in Computer Science, Informational Technology or similar degrees which may be substituted with equivalent work experience</li><li>3-5 years of experience as a SQL Data Analyst, ideally in a healthcare environment</li><li>3 or more years experience using one or more other data tools like MS Excel, Tableau, Power BI, Stata, R or Python</li><li>Strong analytical and problem-solving skills with the ability to formulate and communicate recommendations for improvement.</li><li>Strong SQL skills to support data analysis on a daily basis.</li><li>Understanding of information systems, business processes.</li><li>Ability to produce accurate and precise work, detect discrepancies and resolve discrepancies all while meeting deadlines.</li><li>Ability to work effectively, independently, and as part of a team.</li><li>Strong organization, time management and multi-tasking abilities.</li></ul>WHAT WE OFFERA competitive and robust compensation package, including:<ul><li>Health benefits<ul><li>Medical: You’ll have a choice of medical plans, including options from Kaiser and Blue Shield of California. Employee-only coverage in the HMO plans is currently available at no cost and dependent coverage is heavily subsidized by SFHP.</li><li>Dental: You’ll have a choice of a basic dental plan or an enhanced dental plan which includes orthodontic coverage.</li><li>Vision: Employee vision care coverage is available through Vision Service Plan (VSP).</li></ul></li><li>Retirement – Employer-matched CalPERS Pension and 401(a) plans, 457 Plan</li><li>Time off – 23 days of Paid Time Off (PTO) and 13 paid holidays</li><li>Professional development: Opportunities for tuition reimbursement, professional license/membership.</li><li>An opportunity to work in a vibrant atmosphere with the most amazingly talented people who are shaping the future of healthcare!</li><li>The chance to make a difference in the lives of many San Francisco residents!</li></ul>Established in 1997, San Francisco Health Plan (SFHP) is an award winning, managed care health plan whose mission is to provide affordable health care coverage to the underserved low and moderate-income residents in San Francisco County. SFHP is chosen by eight out of every ten San Francisco Medi-Cal managed care enrollees and its 175,000+ members have access to a full spectrum of medical services including preventive care, specialty care, hospitalization, prescription drugs, and family planning services. SFHP was designed by and for the residents it serves and takes great pride in its ability to accommodate a diverse population that includes young adults, seniors, and people with disabilities.San Francisco Health Plan is proud to be an equal opportunity employer. We are committed to a work environment that supports, inspires, and respects all individuals and in which our people processes are applied without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, marital status, age, disability, national or ethnic origin, military service status, citizenship, or other protected characteristics.Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.San Francisco Health Plan is an E-Verify participating employer.Hiring priority will be given to candidates residing in the San Francisco Bay Area and California.</div></div>

Recruitment ID: PBT-1823-147216 / RTF0147215-01062105This is a Position-Based Test conducted in accordance with CSC Rule 111A.Specific information regarding this recruitment process is listed below:Application Opening: Tuesday, April 30, 2024Filing Deadline: Monday, May 20, 2024 at 5:00 p.m. The filing deadline may be extended if there are not enough qualified applicants.Who We Are. Join our team and help the Department of Children, Youth and Their Families (DCYF) make San Francisco a great place to grow up!DCYF is a strong voice at the heart of the City's commitment to children, youth, transitional adult youth (TAY) and their families. We have administered San Francisco's Children and Youth Fund since 1991, bringing together government agencies, schools and community?based organizations (CBOs) to help our city's youth and their families lead lives full of opportunity and happiness. DCYF and our partners have a proud history of funding high quality, culturally relevant and empowering services with a deep commitment to advancing equity and healing trauma.DCYF provides grants and technical assistance to CBOs and supports partnerships with public agencies to provide services in all San Francisco's neighborhoods. Our funding areas include Early Care and Education; Educational Supports; Emotional Well-Being; Enrichment, Leadership & Skill Building; Family Empowerment; Justice Services; Mentorship; Outreach & Access; Out of School Time; and Youth Workforce Development.Through our funding, partnerships and community engagement efforts we seek to support a continuum of services that provides children, youth, TAY and their families with opportunities to be healthy, succeed in school, prepare for the future, engage in positive activities and live in safe and supported communities.What You Will Do. This position performs complex, sensitive, detailed, and difficult professional-level analytical work in the areas of legislative and administrative policy and data analysis related to children, youth and family services. It supports Departmental functions with data management, policy analysis and program evaluation, and conducts key research and strategic planning. This position will report to the Data and Analytics Manager and will also provide analytical support to program managers in other teams in the department.Role descriptionRole Description - The essential duties of this position include:* Conduct qualitative and quantitative analysis. Tasks may include evaluating and analyzing internal data collected in DCYF's Contract Management System (CMS), developing simple surveys, analyzing survey responses, analyzing outside data from sources that may include the Census and American Community Survey (ACS), San Francisco Unified School District and other City Departments. Quantitative analysis and data management may be completed using statistical software such as R, SQL, and/or EXCEL; geospatial software such as GIS; and data visualization software such as Power BI. Areas of analysis may include early care and education/child care, out-of-school time programming, mentorship, youth workforce development, youth empowerment, wellness, Justice System, and family support services.* Provide support for major Departmental deliverables such as the development of the Community Needs Assessment (CNA), Local Action Plan (LAP), Services Allocation Plan (SAP), and Request for Proposals (RFPs) by gathering and analyzing information from the CMS, youth surveys, other original data sources and relevant research.* Analyze trends in Department-funded services, prepares statistical reports; coordinate and monitor departmental reporting including the reporting of data by DCYF-funded programs.* Work with staff from various teams to define and monitor key metrics in initiatives and with the Department's contracts with nonprofit providers that ensure alignment with system-wide goals and support performance accountability.* Prepare recommendations with appropriate supporting documentation regarding how to comply with legislation and regulations, Mayor's and Board of Supervisors' directives, law, court decisions and/or memoranda of understanding; develops implements and monitors new and revised reporting systems required by legislation and/or new policy.* Develop reports and create dashboards with program outcomes, indicators, and systems for tracking the progress for both public reporting and internal management purposes.* Conduct other ad hoc research and data analysis as needed, which may include matching client data across multiple large datasets and databases, researching industry best practices, evaluating the effectiveness of pilot programs or reform efforts using quantitative and qualitative methods, or administering and analyzing surveys.* Work collaboratively with department staff to perform additional research, data and evaluation work.* Assist in the production of written analysis and presentation materials demonstrating the Department's research, data and evaluation activities.* Develop, create and edit materials in formats that include reports, briefs, fact sheets, handouts, guides, videos and webinars.How to qualifyEducation: Baccalaureate degree from an accredited college or university; ANDExperience: Three (3) years 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 the areas of budgets, contracts, grants, policy, or other functional areas related to the duties of positions in the 182X Class series. ANDCandidates must possess these two (2) Special Conditions:* Policy Analysis. Experience conducting complex and comprehensive analyses to analyze performance outcome measures and/or policy relating to strengthening families; early care and education; prevention and early intervention; health and well being; youth workforce development and empowerment; out of school time; violence response and truancy prevention; or community building. - 6 months of experience.* Community Development. Experience with the development, implementation, monitoring, and support of programs and services that focus on strengthening families; early care and education; prevention and early intervention; health and well being; youth workforce development and empowerment; out of school time; violence response and truancy prevention; or community building - 6 months of experience.In addition to the above minimum qualifications, applicants will need to meet the two (2) Special Conditions associated with the position to be filled. They may differ from the standard minimum qualifications associated with this classification.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 one (1) year of required 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.Important Notes:* One-year full-time employment is considered equivalent to 2000 hours (2000 hours of qualifying work experience is based on a 40-hour work week). Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time employment.* Applicants must meet minimum qualification requirements by the final filing date unless otherwise noted.* Please make sure it is absolutely clear in your application exactly how you meet the minimum qualifications. Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process.* Please be aware that any misrepresentation of this information may disqualify you from this recruitment or future job opportunities.What else should I know?Selection Procedures: After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:Minimum Qualification Supplemental Questionnaire (MQSQ): (Weight: Qualifying) This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQ) for this position. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications.Written Core Examination: (Weight: 40%). Qualified candidates will be invited to participate in a written, multiple-choice examination, designed to measure their relative knowledge, skills and abilities in job-related areas. The "core" multiple-choice examination component may include but not be limited to:* Ability to evaluate/analyze information/data and to exercise good judgment relative to that evaluation or analysis.* Ability to communicate written information (includes ability to proofread).* Knowledge of, and ability to apply, financial/fiscal principles (including the ability to use mathematical and statistical formulas).* Ability to comprehend and understand written information.* Ability to use various computer software programs.* Ability to conduct research.* Ability to establish and maintain cooperative and effective working relationships.* Knowledge of, and the ability to apply, principles, practices and procedures involving office operations.Please note: this examination is only held in San Francisco. This is a standardized examination, and, therefore, test questions and answers are not available for public inspection or review.The score you achieve on this examination shall be valid and 'banked' for three years, starting from the date of the examination. This means that, during this three-year time period, you will not be required to take any test components for which you have already attained a score. If the selection process for the future announcement is held within one year of the date of this examination, your score will be automatically applied to that announcement. However, after one year, you have the option to either (a) apply your test score(s) to the other announcement or (b) re-take the test component(s). Re-testing is permitted no sooner than one year from the date of the examination and only in association with your eligibility for another announcement for which the test component is used. Please note that, should you re-test, your re-test score would become your official score since it is the most recent.Supplemental Questionnaire Evaluation: (Weight: 60%). Qualified candidates with a passing score on the Written Core Examination will be sent a link to complete an online Supplemental Questionnaire. Applicants will be given a deadline to return the Supplemental Questionnaire. The Supplemental Questionnaire is designed to measure knowledge, skills, and/or abilities in job-related areas which have been identified as critical for positions in class 1823 Sr. Research, Evaluation and Data Analyst.Failure to complete these steps by the established deadlines will result in disqualification.A passing score on both the Written Core Examination and Supplemental Questionnaire Evaluation must be achieved in order to be placed/ranked on the Eligible List. Candidates will be placed on the eligible list in rank order according to their final score.Eligible List/Score Report: A confidential eligible list of applicant names that have passed the civil service examination process will be created and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.The duration of the eligible list resulting from this examination process will be twelve (12) months and may be extended with the approval of the Human Resources Director.Certification Rule: The certification rule for the eligible list resulting from this examination will be Rule of Ten Scores, pending approval from the union for an expanded certification rule.Terms of Announcement and Appeal Rights: 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. Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at https://careers.sf.gov/.The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is 'abuse of discretion' or 'no rational basis' for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.HOW TO APPLY: Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.sf.gov/ and begin the application process.Exam Analyst Information: If you have any questions regarding this recruitment or application process, please contact the exam analyst, Gilda Cassanego at Gilda.Cassanego@sfgov.org..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. 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.Additional Information Regarding Employment with the City and County of San Francisco: Information About the Hiring Process* Conviction History* Diversity Statement* Employee Benefits Overview* Equal Employment Opportunity* Disaster Service Worker* ADA Accommodation* Veterans Preference* Right to WorkThe 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.

Data Analyst Cisco Jobs

Quality Data Analyst
June 1, 2024

Business Data Analyst
May 23, 2024

Insights Data Analyst
May 20, 2024

Research Data Analyst 1
May 12, 2024

1823 Sr Research Evaluation Data Analyst Dept Of Children Youth And Their Families
May 11, 2024

Data Analyst
May 10, 2024

Research Data Analyst 1
May 8, 2024

Quick filters

Top companies

Data Analyst Cisco Jobs

Quality Data AnalystJune 1, 2024

Business Data AnalystMay 23, 2024

Insights Data AnalystMay 20, 2024

Research Data Analyst 1May 12, 2024

1823 Sr Research Evaluation Data Analyst Dept Of Children Youth And Their FamiliesMay 11, 2024

Data AnalystMay 10, 2024

Research Data Analyst 1May 8, 2024