Lead Healthcare Business Data Analyst

  • EmblemHealth
  • Farmington, CT, United States

Job Description

Summary of Job:   
Leverage a background in Information Technology alongside advanced subject matter knowledge of healthcare data to develop refined datasets, models, and tools to maximize end users’ potential.  Collaborate with business customers in External Sales Reporting, Underwriting, Medical Analytics, Predictive Analytics, Actuarial, Employer Group Reporting, full-life cycle development (requirements gathering, data discovery, analysis, design, programming development, testing, and documentation).  Ensure that the CCI business application transformation to EmblemHealth enterprise systems will continue to meet the needs of CCI business.  Provide governance and oversight on all technical solutions proposed by the vendor, ensuring adherence to industry and enterprise best practice, soundness in approach, and reasonableness in time and cost estimates. Support the strategic partner’s operations of production support (maintenance, upgrades and small enhancements) of the organization’s application portfolio as a subject matter expert.


  • Develop, implement, and enforce policies, procedures, and best practices for: Operational efficiency and effectiveness; Key data, application and technical design; Data Management; department standards for SQL Server’s suite of tools inside HCM; data governance.
  • Develop technical processes when formal IT resources are not available (e.g. developing & maintaining data feeds for critical data needed by business).
  • Lead workgroup to define and standardize department use of data (e.g. Reporting Methodologies and standardized code development).
  • Maintain / Enhance Datasets, Models and Reporting related to: Fixed Funding Solutions; Level Funding; Large and Small Group external reporting; Underwriting and Actuarial Rating Models; Predictive Analysis; Membership; Provider. 
  • Ensure standards are kept for all department data to secure sensitive data.
  • Ensure best datasets and user tools are being used to fit specific need (e.g. SQL Server, SAS, Excel, and Access).
  • Partner with all IT and business areas to identify opportunities to improve operational and service-related processes by improving the existing application portfolio functionality.
  • Collaborate with Business & IT Leadership Team to inform as well as facilitate implementation of migration plan.
  • Identify key areas of change in architecture and ensure flexible and scalable architecture.
  • Ensure development of migration plan to new architectures.
  • Ensure solutions delivered are designed to meet business needs with architecturally significant and nonfunctional requirements.
  • Serve as point of contact for data feed development & testing as needed.
  • Perform analysis to support new ad hoc requests from management as well as legacy reporting (State of CT program, HEP, FFS, CDC etc.).
  • Represent the department in support of IT Enterprise Data Warehouse initiatives (CTS).
  • Represent the department on the Efficiency committee.
  • Remain abreast of information technology trends and their applicability to corporate systems.
  • Perform other related tasks as directed or required.

Job Requirements:


  • Bachelor’s Degree in Computer Science or related field of study.
  • 5 – 8+ years of relevant, professional work experience (R)
  • 3+ years of data analysis experience (R)
  • Industry level knowledge of data sets, standards, tools, practices, and methodologies (R)
  • SQL Server - Ability to program using Transact SQL and general SQL Database knowledge
  • Experience in ETL (Extract - Transform - Load); ability to develop in SQL Server Integration Services (SSIS) (R)
  • Advanced proficiency in MSOffice (Word, Excel, Access, Visio, Outlook, etc.) (R)
  • Ability to use Excel and Access in analysis as well as front-end tool development for other users (R)
  • Technical connectivity knowledge (FTP, Remote PC, ODBC, etc.)
  • Experience in data discovery, validation, and quality assurance (R)
  • Effective communication skills (verbal, written, presentation, interpersonal) with all types/levels of audience (R)
  • Ability to understand department business needs to impact efficiencies, enforce standardization, and control proper business side data use (R)

Apply Now