Job Information
Blue Cross and Blue Shield of Louisiana Senior Operational Reporting & Data Analyst in Baton Rouge, Louisiana
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. We invite you to apply for a career with Blue Cross.
Residency in or relocation to Louisiana is preferred for all positions.
POSITION PURPOSE
The Senior Operational Reporting & Data Analyst will contribute to the organization by the analysis of data, configuration of departmental and organizational databases, development of reports and related processes required to efficiently and effectively deliver business intelligence reports. Responsible for working cross business lines, conferring with leadership to gather requirements and specifications while developing enhanced data and reporting tools. May mentor lower-level reporting analyst.
NATURE AND SCOPE
This role does not manage people
This job reports to: Departmental Leadership
Necessary Contacts: In order to effectively fulfill this position, the incumbent must be in contact with: The departmental leadership, and other divisions within BCBSLA.
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
4 years of experience providing operational reporting required
2 years of creating/building queries and reports, performing data manipulation, analysis, and executing ad hoc reporting required
Experience can run concurrently
Must have experience in two or more of the following software applications Microsoft Access, Microsoft Excel, Tableau, SQL Server, SQL Server Management Studio (SSMS), Microsoft Visual Studio, and Microsoft SQL Server Reporting Services (SSRS). Experience must include building complex queries, execute ad hoc reports, and statistical reports (e.g., dashboards, scorecards, etc.) and performing advanced functions within these applications (e.g., macros, triggers, stored procedures, and the efficient and effective configuration of departmental databases reports, etc.)
Adobe Creative Suite, Microsoft Power BI, Microsoft Project and SharePoint experience preferred
Skills and Abilities
Analytical and problem-solving skills with demonstrated experience conducting research, locating and extracting appropriate enterprise-wide data from databases, developing business intelligence reports, analyzing and interpreting data, and providing summary report recommendations required
Must demonstrate PC skills including Microsoft Office (e.g., Word, Excel, Outlook, etc.) and related software as other corporate software programs and applications
Must demonstrate verbal and communication skills with the ability to interpret and communicate information with tact, diplomacy, patience and professionalism
Able to cohesively work in a team environment to ensure efficient and effective completion of all tasks assigned groups
Licenses and Certifications
- None Required
ACCOUNTABILITIES AND ESSENTIAL FUNCTIONS
Develop departmental databases, conducts analysis, prepares reports and delivers business intelligence information.
Develop and execute standard reports, custom reports, and data files using MS SQL Server data query tools and provide to users
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.
Interpret data and analyze results using statistical techniques and provide ongoing reports.
Identify, analyze, and interpret trends or patterns in moderate to large data sets
Identifies, analyzes, documents, and improves existing business processes. This includes automation, database creation/management and process development activities
Independently and comprehensively develops data validation tools and techniques and executes all quality control processes (e.g., queries, test scenarios, etc.) to ensure accuracy of data, reports and file extracts.
Validate results to ensure data integrity of the reports and/or files produced. When there are inaccuracies, research issues to determine the source of discrepancies and identify solutions for preventing future discrepancies.
Create SQL queries for business area
May guide lower-level Reporting Analyst
Additional Accountabilities and Essential Functions
The Physical Demands described here 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 an individual with disabilities to perform the essential functions
Perform other job-related duties as assigned, within your 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.
#LI_MS1
An Equal Opportunity Employer
All BCBSLA EMPLOYEES please apply through Workday Careers.
PLEASE USE A WEB BROWSER OTHER THAN INTERNET EXPLORER IF YOU ENCOUNTER ISSUES (CHROME, FIREFOX, SAFARI)
Additional Information
Please be sure to monitor your email frequently for communications you may receive during the recruiting process. Due to the high volume of applications we receive, only those most qualified will be contacted. To monitor the status of your application, please visit the "My Applications" section in the Candidate Home section of your Workday account.
If you are an individual with a disability and require a reasonable accommodation to complete an application, please contact recruiting@bcbsla.com for assistance.
In support of our mission to improve the health and lives of Louisianians, Blue Cross encourages the good health of its employees and visitors. We want to ensure that our employees have a work environment that will optimize personal health and well-being. Due to the acknowledged hazards from exposure to environmental tobacco smoke, and in order to promote good health, our company properties are smoke and tobacco free.
Blue Cross and Blue Shield of Louisiana performs background and pre-employment drug screening after an offer has been extended and prior to hire for all positions. As part of this process records may be verified and information checked with agencies including but not limited to the Social Security Administration, criminal courts, federal, state, and county repositories of criminal records, Department of Motor Vehicles and credit bureaus. Pursuant with sec 1033 of the Violent Crime Control and Law Enforcement Act of 1994, individuals who have been convicted of a felony crime involving dishonesty or breach of trust are prohibited from working in the insurance industry unless they obtain written consent from their state insurance commissioner.
Additionally, Blue Cross and Blue Shield of Louisiana is a Drug Free Workplace. A pre-employment drug screen will be required and any offer is contingent upon satisfactory drug testing results.
JOB CATEGORY: IT, Telecom & Internet