Data Analyst III, Data Office
Summary
Senior Data Analyst III in a community health center's Data Office, querying medical/billing/patient data in relational databases, building reports and dashboards, and optimizing production applications using SQL Server, PowerBI, SSRS, PowerShell, R, and Excel.
For more than 55 years, Family Health Centers of San Diego’s (FHCSD) mission has been to provide caring, affordable, high-quality health care and supportive services to everyone, with a special commitment to uninsured, low-income and medically underserved persons.
FHCSD is one of the top 10 largest federally qualified health centers (FQHCs) in the country. We operate more than 90 sites across San Diego County, including 29 primary care clinics, 23 behavioral health facilities, 10 physical rehabilitation clinics, nine dental clinics, five vision clinics, four outpatient substance use treatment programs, three mobile medical units, two mobile counseling centers, two urgent care centers, and a pharmacy.
Our staff provides care to over 227,000 patients each year, of whom 91% are low-income and 29% are uninsured. FHCSD provides care to all. Services include, but are not limited to adult care, chronic disease management, pediatrics, comprehensive women’s care including obstetrics, dental, vision, case management, physical rehabilitation, speech therapy for children, vaccinations, infectious diseases, behavioral health, substance use counseling and a host of specialty services including cardiology, podiatry, endocrinology, dermatology, among others. FHCSD also offers supportive services to those who are unsheltered and in need of intensive case management.
The breadth of our clinic locations, services and programs has grown over the last five decades, making us the largest community clinic provider of health care to the uninsured in the county and one of the top 10 largest community clinic organizations in the nation. We are also the largest health care safety-net provider, largest school-based health care provider and the largest mental health provider in the San Diego region.
Family Health Centers of San Diego is looking for a Data Analyst III within the Data Office. The Data Analyst III is dedicated to ensuring that data quality, data integrity, and data security align to support the many decision-making processes across the organization. By skillfully querying thousands of relational databases containing medical information, billing information, patient feedback, and more, these technical experts can monitor trends, illuminate patterns, and make predictions, ultimately shaping the future of healthcare delivered to our patients. Whether they are working to optimize operational efficiency, or to evaluate adherence to clinical quality guidelines, or to improve patient experiences, Data Analysts serve as the bridge between raw data and actionable insights. Their work ensures that the organization’s decisions are evidence-based and rooted in clear, data-driven logic. Data Analysts require a unique combination of technical skills from the fields of information technology, computer and data science, and healthcare. The Data Analyst III within the Data Office provides support for the decision-making processes of Family Health Centers of San Diego through the creation of standard and ad-hoc reports of organization data. This senior level role requires interviewing end users, making changes in production-level applications, and documenting processes with a focus on continuous improvement.
EXPERIENCED (LEVEL 3): Experienced professional who knows how to apply theory and put it into practice with in-depth understanding of the professional field; independently performs the full range of responsibilities within the function; possesses broad job knowledge; analyzes problems/issues of diverse scope and determines solutions.
Responsibilities:
Independently and accurately estimates time to create new reports
Fine-tunes SQL Server queries
Create scripts using PowerShell
Creates reports using a variety of applications (e.g., Microsoft Excel, PowerBI, R) that require specific programming skills
Creates accurate reports that are audience appropriate.
Automates reports based on end-user needs and timelines through use of SSRS/Reporting Services or Scripts
Modify the organization’s production-level applications in order to optimize reporting capabilities
Uses interviewing skills to get requirements from end users; coaches lower-level staff on effective interviewing skills
Documents efficient processes, with a focus on continuous process improvement
Performs other duties as assigned
Requirements:
Bachelor's degree in Computer Science, Information Systems, or closely related field required
Completion of courses in information systems, computer science, relational databases, data management, and/or statistics
Microsoft Certification MS SQL preferred
9+ years of experience using SQL Server
9+ years of experience creating reports using a variety of applications (e.g., Microsoft Excel, PowerBI, R) that require specific programming skills
Experience with a web-based acquisition tool and ETL processes preferred
Advanced knowledge of SQL Server to query databases and manipulate data
Advanced knowledge of the organization’s relational database architecture
Intermediate knowledge of statistical principles and methods to describe data
Critical thinking; ability to approach problems logically and formulate solutions
Attention to detail; ability to approach tasks with a high level of accuracy
Advanced organizational skills including time-management skills, and strong motivation to meet deadlines and achieve goals
Communication skills; ability to communicate requirements and results effectively to end-users through non-technical terms
Ability to work well in both a team-based environment and independently
Knowledge of applicable data privacy practices and laws
Traveling between sites and other locations is occasionally required. Must have a valid California driver’s license, an automobile, and proof of minimum levels of car insurance as required under California law, although limits of $100,000 are recommended. An acceptable driving record is also required. California law requires all drivers to obtain a valid California driver’s license within ten days of establishing residency. Reasonable accommodation may be provided on a case-by-case basis. Mileage and other reimbursement governed by policy.
Rewards:
Job type: Regular Full Time (Onsite)
Competitive Salary with Excellent Benefits
Retirement Plan with Employer Match
Paid Time Off, Extended Sick Leave and Paid Holidays
Medical/Dental/Vision/FSA/Life Insurance
Employee Discounts and Wellness Programs
The successful candidate will have a demonstrated commitment to community medicine and providing culturally competent care to the medically underserved.
We are excited to share that the salary range for this position is:
$73,819.00 - $107,946.00Information on our extensive benefits package can be found here: FHCSD Wellness – Employee Hub (gobenefits.net)
FHCSD provides Equal Employment Opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, transfer, leave of absence, compensation, and training.