Supervisor - Informatics Business Intelligence

Job Summary

 

Under the direction of the Manager, assist in the completion of tasks related to the Informatics Department. The department’s responsibilities include data research, user assistance, technical development and support, employer reporting, and provider reporting.  Supervise the work of Business Intelligence Analysts.

 

Specific Duties & Responsibilities

 

Supervisor handles all management functions for the analysts under his/her supervision. This includes hiring, training, performance plans, performance appraisals, salary administration, compliance with corporate personnel policies, delegation of responsibilities, coordination of workflow, and establishment of priorities.  Personally conducts or supervises the following duties:

 

Data Integrity:

Track, research and resolve data issues related to the various processing systems and data sources available to the Actuarial Services and Informatics Departments (e.g. MetaVance, Corporate Data Warehouse (CDW), Enrollment Data Mart (EDM), Revenue Data Mart (RDM) and Pharmacy Data Mart (PDM)).  Constantly scrutinize and monitor the quality of data through analysis of existing and ad hoc reports.  Document and communicate the results of this research to management and the division as needed. 

 

Provide support and training to users within the division with respect to accessibility and accuracy of data necessary for analysis and reporting.  Work closely with users to understand their business needs and identify future needs.  Provide training to coworkers regarding the use of the various data sources and software tools available to the division and act as an information consultant.  Assist users in the creation of their own reports.

 

Actively participate in user acceptance testing of new data sources or reporting tools as appropriate. Lead the process of identifying and documenting business metrics.

 

Be the liaison and advocate for the division on system configuration and other ongoing interdepartmental system support or implementation teams to assure accessibility, understanding and accuracy of data necessary for analysis and reporting.  Be the liaison to other departments that have a direct impact on the accessibility and accuracy of our data (e.g. Information Technology, Data Management, Enrollment Services).

 

Reporting:

Design, develop and implement information-based solutions related to reporting and ad hoc analysis.  Interpret results using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining.

 

Produce monthly corporate Informatics Enrollment Report including detail that shows new members, termed members and transfers.  Make enhancements and modifications to the enrollment process and files as needed.  Produce other detailed reporting by group size, deductible and more detailed breaks, as requested.  Respond to special requests for enrollment information.

 

  Assist in production of monthly claim utilization and enrollment reporting for all 100+ employer groups. Assist in development and production of annual Consultative reports for all 250+ employer groups. Assist in production of ad-hoc reporting for employer groups.

 

  Assist in development of reporting for Medical Services that will assist in proactively identifying customers that may benefit from their outreach and create reports to illustrate the value of their services to employers.  Assist in development and production of efficient network / provider quality information for dissemination to providers.



  Research trends in employer and provider reporting and catalog examples of reports distributed in the local market place by carriers and TPAS and “best in class” examples nationally. Assist Informatics in achieving goal for BCBSAZ’s reports to be “best in class.”

 

  Participate in selection and management of external vendors and/or consultants for the development of various reporting done within the department.

 

  Research latest developments by governmental and national entities (e.g. CMS, NCQA, AHRQ, Leapfrog, etc.) on the establishment of metrics to monitor and/or define provider quality information for the general public. Present findings and recommendations in written and verbal formats.

 

Complete various ad hoc reports and special projects as assigned, providing timely response on short notice including high priority requests from various departments and upper management.  Document all reporting requirements, applications and reports as they are released.

 

Technical Support:

Provide programming support and act as consultant for users within the division for the various data access and software tools available (e.g. Microsoft Access, Excel, Business Objects, SQL, FoxPro, HTML and SAS).

 

Oversee and assist with software conversions within the division that are required by changes in corporate standards or availability of superior tools (e.g. new versions of current software, conversion of databases to Microsoft Access or SAS, automation of current processes).

 

Develop and maintain databases for use in departmental reporting.  Assist in identifying, extracting, storing, maintaining and integrating data into reporting. 

 

Identify potential new technologies that will improve overall reporting capability or timeliness.  Assist in requirements gathering and validation along with user acceptance testing of enhancements and new developments.

 

Computer Responsibility:

Comply with BCBSAZ Computer Responsibility Agreement.  Employees with Internet access are required to comply with the Internet Policies Agreement.

 

 

Work Relationships

Internal: All Departments, especially Actuarial Services, Group Underwriting, Information Technology, Data Management, Enrollment, Medical Services, Sales, and Provider Relations.

 

External: BCBS Association, Employer groups, Provider groups, Vendors and EDS.

 

Employment Standards

Education & Experience:

  Four-year degree in Mathematics, Statistics, Economics, Management Information Systems, Computer Science or similar degree, or a combination of education and experience which provides an equivalent.  Minimum of 4 years experience related to at least one, preferably two, of the categories of duties described above (data integrity, reporting or technical support).  Previous experience in leading teams or group projects, directing the work of others, or supervising direct reports required.

 

Knowledge & Abilities:

Required:

§ Effective presentation and communication skills, both orally and in writing

§ Ability to provide effective status reports on assigned tasks or projects

§ Demonstrated ability to develop and maintain effective working relationships across functions and teams

§ Ability to work independently and in a team environment, with minimal supervision

§ Ability to problem solve and prioritize work assignments and issues, demonstrating strong overall organizational and time management skills

§ Ability to set and meet reasonable deadlines and check own work and the work of others for accuracy

§ Ability to handle multiple projects concurrently

§ Willingness to work in an ambiguous and changing environment

§ Ability to maintain confidentiality

§ Demonstrated combination of strong business, analytical, reporting, and technical skills

§ Ability to oversee and lead complex projects to their completion

Preferred:

§ Healthcare or Insurance experience

§ Thorough understanding of BCBSAZ data and related issues and their impact to the Corporation

 

Technical Skills:

Required:

§  Experience manipulating large quantities of data

§  Ability to create reporting using various software including spreadsheet, database, word processing and ad-hoc querying tools

§  Proficiency in Excel and at least one of the following database tools: Access, FoxPro or SAS

  Preferred:

§  Proficiency in HTML, SQL, Business Objects and/or data cubing software

 

Promotion is consistent with progression through the Qualities To Develop (QTDs)

(Available upon request).