Data Analyst-Hybrid position in Los Angeles, California

• 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

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.