Operational Reporting & Data Analyst

About the role

The Operational Reporting & Data Analyst will contribute to the organization by gathering data, preparing reports, and introducing process improvements through the reporting process. This position is responsible for the utilization of department databases, analysis of data, and development of reports to deliver business intelligence to the department. This role is responsible for conducting routine audits on the department databases to ensure information is reliable and accurate.

This role does not manage people; it reports to Departmental Leadership. Necessary contacts include departmental leadership and other divisions within BCBSLA.

We take great strides to ensure our employees have the resources to live well, be healthy, continue learning, develop skills, grow professionally, and serve our local communities.

Responsibilities

• Utilizes departmental databases, conducts analysis, prepares reports and delivers business intelligence information.
• Works with business area on custom data reporting and file requests to define requirements, create queries to meet requirements, conduct testing, and handle any import/export processes.
• Works with business area to establish eligibility data exchange and write data mapping specifications for custom file layouts, including testing data files with vendor, defining profiles, and documenting procedures.
• Interprets data and analyzes results using statistical techniques and provides ongoing reports.
• Identifies, analyzes, and interprets trends or patterns in moderate data sets.
• Identifies, analyzes, documents, and improves existing business processes, including database management and process development activities.
• Works with other reporting analysts to assist in the development of data validation tools and techniques and executes all quality control processes (e.g., queries, test scenarios) to ensure accuracy of data, reports, and file extracts.
• Initially validates results to ensure data integrity of the reports and/or files produced.
• Performs other job-related duties as assigned, within the scope of responsibilities.
• Job duties are performed in a normal and clean office environment with normal noise levels. Work is predominately done while standing or sitting. The ability to comprehend, document, calculate, visualize, and analyze are required.
• Physical demands: The physical demands described are representative of those that must be met by an employee to successfully perform the accountabilities and essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Qualifications

Education: Bachelor's Degree in Information Management Systems, Computer Science, and Business Administration or related degree required. Four years of related experience can be used in lieu of a Bachelor’s degree.

Work Experience: 2 years of experience providing queries and operational reporting, including modifying queries and reports, performing data manipulation, analysis, and executing ad hoc reporting required. Must have experience in one or more of the following software applications: Microsoft Access, SQL Server, SQL Server Management Studio (SSMS), Microsoft Visual Studio, and Microsoft SQL Server Reporting Services (SSRS). Adobe Creative Suite, Microsoft Power BI, Microsoft Project and SharePoint experience preferred. Experience conducting research to obtain departmental data, utilizing databases, validating information, analyzing and interpreting data, and delivering accurate reports and report summaries required.

Licenses and Certifications: None Required.