> Markdown version of [/jobs/ext/127106-data-analyst-hybrid-position-in-los-angeles-california](https://www.wearedevelopers.com/jobs/ext/127106-data-analyst-hybrid-position-in-los-angeles-california). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst-Hybrid position in Los Angeles, California - **Company:** Partners Llc - **Location:** San Fernando, CA, United States - **Experience:** Expert - **Salary:** $58,240.0 - $79,040.0 - **Contract:** Permanent contract - **Skills:** Microsoft Access, Microsoft Word, Microsoft Excel, Application Programming Interfaces (APIs), Agile Methodology, Software Applications, Batch Processing, Big Data, Microsoft Outlook, Software Quality, Databases, System Configuration, Customer Data Management, Data Cleansing, Extract Transform Load (ETL), Data Mart, Data Mining, Data Structures, Data Synchronization, Data Visualization, Data Warehousing, Dimensional Modeling, Document-Oriented Databases, EndNote, Web Browsers, Job Scheduling, Microsoft Office, Microsoft SQL Server, Performance Tuning, Software Tools, DataOps, Salesforce.Com, Microsoft SharePoint, Software Deployment, Software Systems, SQL Stored Procedures, SQL Databases, Talend, Transact-SQL, Web Applications, Manual Data Entry, Backend, Vba Programming Language, Salesforce Object Query Language (SOQL), Software Version Control - **Published:** May 16, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=20eb25cd887302dc ## About the Role Do you have experience in VBA?, + Minimum of 10 years of experience required with data and metrics analysis. + Minimum of five years experience working in analytics with hospitals and health plans. + Advanced proficiency required with VBA, SQL, Salesforce, Excel and Access. + High-level skills using web applications and all browsers; ability to teach others how to use web-based database functions. + Demonstrated experience using Microsoft Office computer applications, including Word, Access, Outlook and SharePoint. Advanced knowledge of Excel required. + Detail-oriented with strong follow-through and ability to work independently given standard guidelines and checklists. + Good writing and communication skills. Able to draft grammatically correct and professional email messages. + Demonstrated experience in working successfully with minimal supervision. + Must have knowledge of medical and health care terminology. + Ability to complete HIPAA training and implement high-level protections on patient information and confidentiality. + Must work effectively independently and in a team setting. + Ability to relate well with internal and external customers. ## Description + Gather and perform analysis on data from Salesforce, Loopback, Excel, and other databases as required. + Perform data cleaning as needed to ensure data are consistent and analyzable. + Create data reports, charts, graphs and tables for regular reporting to program leads and external partners. + Export data from software systems and program tracking logs for agency reporting. + Assemble reports, papers and presentation materials as directed. + Collect data through phone and in-person interviews. + Record or transcribe data in accordance with project and funding source guidelines. + Perform literature reviews (locating, listing &/or abstracting articles). Enter literature references into shared database (such as EndNote) Responsibilities: + Data cleaning, formatting, and maintenance as needed. + Data visualization and analysis of program metrics. + Data Entry for the program(s) assigned. + Program reporting/billing/invoicing support. + Administrative duties as needed (Mailing and other assigned work) + Establish and maintain systems for program accountability - reports track performance. + Attend and ensure follow up after all meetings and presentations - minutes, reports, action plans, assignments, and etc. + Monitors performance, responsibilities of field staff with respect to database management, metrics, and documents. + Reports all errors in systems, workflows, and both internal and external individuals. + Completes reporting (both internal and contractual requirements) with thorough knowledge and understanding of what is being reported. + Develops and maintains a current understanding of the Department's Contractual Agreements. + Must have professional verbal and written skills, computer/software skills. + Assists with both internal and external customer service calls, emails, and requests. + Other Miscellaneous tasks assigned, as needed. * SQL Server database design, implementation, troubleshooting * Develop, optimize, and maintain complex T-SQL queries, stored procedures, indexes, constraints; resolve performance issues, deadlocks, and contentions using traces, execution plans, and profiling. * Design, develop, test, and implement ETL/ELT processes using Talend for data extraction, transformation, and loading from diverse sources, including Salesforce CRM data. * Administer and optimize Talend environment, including job scheduling, dependencies, monitoring, automation, patches, upgrades, and performance tuning. * Integrate Salesforce data (e.g., via APIs, connectors) into SQL Server databases and data warehouses, ensuring data quality, synchronization, and real-time/ batch processing. * Collaborate face-to-face/with business stakeholders to analyze requirements, gather specifications, evaluate data sources/targets, and design solutions that improve business performance. * Lead ETL development activities, ensure code quality, provide feedback on performance. * Support enterprise data warehouse, data marts, and business intelligence initiatives; perform source data analysis and dimensional modeling. * Develop and automate processes using scripting. * Provide tier 2/3 support, evaluate production issues, recommend improvements, and participate in project planning following Agile methodologies. * Perform proactive performance optimization, and data synchronization across environments * Mentor staff, recommend process enhancements, and contribute specialized knowledge across IT and business operations. * Document data integration processes, workflows, ETL designs, data mappings, technical specifications, and system configurations * Manage version control, deployments * Collaborate on testing (unit, integration, UAT * Translated business requirements into actionable data specifications, documentation, and code solutions using Salesforce Object Manager and official documentation * Reviewed Salesforce release notes, verified production deployments, and conducted feature testing across sandbox and production environments with detailed feedback submission * Developed and maintained complex SOQL queries to support data team operations, reporting, and analytics needs * Designed and built custom Salesforce reports to support data operations and Enhanced Care Management (ECM) programs * Developed and deployed end-to-end solutions for processing health plan MIF data, enabling efficient insert, update, and reporting workflows for Lead and Case objects * Performed large-scale data inserts, updates, and migrations using Salesforce Data Loader in both sandbox and production environments * Extracted, analyzed, and transformed backend Salesforce data using Talend and SQL to produce accurate reports for compliance, billing, and operational needs * Identified and resolved reporting discrepancies and data quality issues through root-cause analysis and targeted corrections * Cleaned, standardized, and transformed referral data for mass uploads into Salesforce while enforcing validation rules and workflow requirements * Created Salesforce-based error reports that enabled program teams to quickly identify and correct data entry issues * Conducted data gap analyses against vendor reporting requirements and designed field transformations and new data structures to meet compliance and reporting standards * Integrated offshore datasets with Salesforce records to address missing or incomplete data, improving accuracy for reporting and billing * Reduced manual data entry and correction efforts by automating large-scale updates, inserts, and fixes via Salesforce Data Loader * Maintained vendor zip code records in Salesforce to ensure accurate service area tracking, correct billing rates, and reliable historical reference ## Related Videos - [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock) - [ZEISS & Microsoft - Building the Next Generation Medical Ecosystem in the Cloud](https://www.wearedevelopers.com/videos/424-zeiss-microsoft-building-the-next-generation-medical-ecosystem-in-the-cloud) - [Nest.js - TypeScript in the backend can also be clean](https://www.wearedevelopers.com/videos/1033-nest-js-typescript-in-the-backend-can-also-be-clean) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Anomaly Detection - Using unsupervised Machine Learning for detecting anomalies in customer base](https://www.wearedevelopers.com/videos/6-anomaly-detection-using-unsupervised-machine-learning-for-detecting-anomalies-in-customer-base) - [Meet Your New BFF: Backend to Frontend without the Duct Tape](https://www.wearedevelopers.com/videos/682-meet-your-new-bff-backend-to-frontend-without-the-duct-tape) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)