• Sr. SQL Developer

    Job Locations US-CA-Aliso Viejo
    Req No.
    Information Technology
    Regular Full-Time
  • Overview

    ConcertoHealth Inc. is the leading provider of specialized primary care and supporting clinical services for complex, frail, elderly, and dual-eligible patients. Operating exclusively in value-based agreements, ConcertoHealth provides high-touch, individualized care for patients, and deploys wraparound clinical resources to extend the reach of primary care practices. This comprehensive medical management solution, elevated by Concerto’s proprietary population health technology, improves overall healthcare quality and patient outcomes, benefitting payers and their provider networks. The company is headquartered in Irvine, Ca. For more information, please visit www.concertohealth.com.
    We are looking for individuals that have a passion for developing databases and providing business insights to various departments across the company. As a Sr. SQL Developer in the Business Intelligence department, developers will be responsible for building out data warehouse facts, dimensions, and data marts and other database functionalities that will drive operational processes and business decisions. The Sr. SQL Developer will work closely with stakeholders and subject matter experts to understand requirements, design data models, and build data marts. This is a full-time position, based in the Concerto Health corporate office in Aliso Viejo, CA


    • Interpret business requirements, design data models, and develop data warehouse facts, dimensions, and data marts
    • Design, develop, and unit test new database code to support requirements, using database triggers, stored procedures, and views
    • Work closely with business and IT stakeholders to define problems and design large-scale, enterprise class solutions
    • Translate highly complex concepts into data marts that can be understood by a variety of technical and non-technical audiences
    • Troubleshoot and resolve data gaps or design deficiencies as they appear
    • Review and analyze ongoing customer requests
    • Performs all other related duties as assigned


    • BS or MS degree in Computer Sciences, Computer Engineering, Computer Information systems, or related field
    • 5+ years of SQL Server development experience
    • 3+ years of database design and development
    • Data warehouse and/or data mart design and development experience
    • Experience writing and tuning SQL queries for optimized performance in a large data volume environment
    • Experience working with Healthcare Payer and/or Managed Care data from a data profiling, analysis, and modeling perspective, with a solid understanding of the relevant Healthcare business processes


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