Data Analyst SQL Developer

Req No.
Information Technology
Regular Full-Time




Concerto delivers comprehensive care to Medicare, Medicaid, and complex-needs patients. For over a decade, we have provided extraordinary outcomes for thousands of people in these underserved groups.

The Concerto name reflects our unique approach to healthcare. It’s about how we work in concert with patients, providers, and health plans. It’s about the harmony of a patient’s care, health, and dignity.


This role will be responsible for developing a data and reporting quality strategy through agile custom development and data quality projects. This person will be a hands-on engineer responsible for mainly for data analysis and validation within the custom web applications, data warehouse, data marts and reports. The candidate should have the passion to analyze data patterns and find issues with data. S/he will perform data reconciliation to identify data anomalies, and prioritize data issues needing process re-engineering. The data analyst will partner with data solutions (DS) team and Business Intelligence (BI) team to deliver high quality solutions across Concerto Healthcare.

The data analyst supports the business goals and objectives for the data warehouse team, the BI team, the IT organization, and the enterprise as a whole.


This is a full-time position, based in the Concerto Healthcare offices in Irvine. The QA Lead will report to the VP of Applications.



  • Write SQL scripts to validate and compare data, as well as test the data quality.
  • Use SSIS to automate data validation tasks.
  • Develop and execute SQL scripts and procedures (manual and automated).
  • Act as key point of contact for all data validation aspects.
  • Apply industry best practices, and developing new tools and processes to ensure data quality goals are met.
  • Successfully engage in multiple large initiatives simultaneously.
  • Perform all types of data testing such as regression, performance, system, integration and smoke testing. Also, help users with UAT.
  • Drive and challenge the BI, DS and development teams on their assumptions of how ready the software is for production.
  • Own quality of the developed applications and their data through development sprints, to smoke testing after deployment.
  • Collaborate with business analysts and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.



·         Bachelor’s degree in computer science or equivalent.


·         Enterprise systems delivery experience

·         4+ years of SQL programming

·         3+ years of SSIS experience

·         2+ years of agile methodologies

·         1+ years of QA experience

·         Strong written and verbal communication

·         Demonstrated ability to communicate ideas clearly and concisely

·         Excellent time management, organizational/prioritization skills and ability to balance multiple priorities

·         Advanced level of proficiency with MS Project, Excel and PowerPoint


  • Understanding of Health Plans/Clinic Operations/Medicare/Medicare/HEDIS/HCC
  • Working in Healthcare with providers and clinicians using EMRs (e.g. eCW) and Care Management Platforms (e.g. TruCare).
  • SmartBear, Selenium or other test automation tools



Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed