Data Analyst-Hybrid position in Los Angeles, California

Partners in Care Foundation In•San Fernando, CA

3d•Hybrid

About The Position

This is a hybrid Data Analyst position located in Los Angeles, California. The role involves gathering and analyzing data from various sources, performing data cleaning, creating reports, and supporting program operations. The analyst will also be responsible for data visualization, data entry, program reporting, and administrative duties. A key aspect of the role is to establish and maintain systems for program accountability, monitor performance, and report errors. The position requires a strong understanding of contractual agreements and excellent communication and computer skills. The analyst will also assist with customer service calls and emails, and perform other miscellaneous tasks as assigned. The role also includes responsibilities related to SQL Server database design, implementation, and troubleshooting, developing and optimizing T-SQL queries, and designing/developing ETL/ELT processes using Talend. Integration of Salesforce data into SQL Server databases, collaboration with business stakeholders, and support for enterprise data warehouse initiatives are also part of the role. The analyst will mentor staff, document data integration processes, and manage version control and deployments.

Requirements

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.
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.

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.
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).
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.