Data Analyst-Hybrid position in Los Angeles, California

• Qualifications:
• 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.

Quality/Metrics:

• 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