Senior Database Report Writer/Analyst

ourhrconnect; Columbia (SC); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health plans

401K with company match

Life Insurance

Paid Time Off

Holidays

On-site cafeterias & fitness centers

Wellness program & discounts

Tuition assistance

Service recognition

Employee assistance

Discounts: movies/theatres/zoos

Job summary

BlueCross BlueShield of South Carolina seeks a position responsible for creating and maintaining database reports. You will retrieve and manipulate data, analyze reporting methodologies, and generate routine reports, engaging with customers to refine criteria and logic. This role operates within a federal contractor context and requires U.S.

citizenship. Strong skills in DB2/SQL, Easytrieve, and Microsoft Office are preferred, along with attention to detail and solid analytical abilities.

Qualifications

• Associate's degree required; Degree Equivalency: 2 years of job-related work experience for a total of 5 years of required work experience.
• 3 years experience with database, mainframe, or spreadsheet applications; 3 years with Easytrieve, DB2, SQL, or similar programs.
• Strong computer experience with spreadsheet and database applications.
• Attention to detail.
• Good organizational, analytical, customer service, and communication skills.
• Knowledge of mathematical or statistical concepts.
• Ability to comprehend the differences among dataset types.
• Microsoft Office proficiency.

Responsibilities

• Create database reports based on end-user needs and specifications.
• Retrieve and manipulate data using data manipulation and extraction techniques.
• Analyze current reporting methodologies.
• Generate routine internal and external reports daily, monthly, quarterly, and annually.
• Interview customers to obtain criteria for data; update programming logic accordingly.
• Assist with system testing and provide technical support.
• Participate on project teams to develop, maintain, and implement new processes, policies, and forms.

Skills

Attention to detail

Organizational skills

Analytical skills

Communication skills

Customer service

Math or statistics concepts

Dataset types understanding

Education

Associate's degree

Degree Equivalency: 2 years of job-related work experience for a total of 5 years of required work experience

Tools

DB2

SQL

Easytrieve

Microsoft Office

Job description

Summary

Why should you join the BlueCross BlueShield of South Carolina family of companies? Other companies come and go, but for more than seven decades we’ve been part of the national landscape, with our roots firmly embedded in the South Carolina community. We are the largest insurance company in South Carolina … and much more. We are one of the nation’s leading administrators of government contracts. We operate one of the most sophisticated data processing centers in the Southeast. We also have a diverse family of subsidiary companies that allows us to build on a variety of business strengths. We deliver outstanding service to our customers. If you are dedicated to the same philosophy, consider joining our team!

The team consists of two functional groups: three Senior Database Report Writers and a Testing Team. The team partners extensively with the PGBA Finance Team, providing reporting, testing, and operational support to ensure business needs are met.

Description

This position requires a clearance which requires U.S. citizenship to obtain.

Sponsorship: This position is not eligible for sponsorship now or in the future.

SCA Benefit Requirements: BlueCross BlueShield of South Carolina and its subsidiary companies have contracts with the federal government subject to the Service Contract Act (SCA). Under the McNamara-O'Hara Service Contract Act (SCA), employees cannot opt out of health benefits. Employees will receive supplemental pay until they are enrolled in health benefits 28 days after the hire date.

Position Purpose:

Responsible for creating database reports based on the needs of end users. Retrieves and manipulates data using various data manipulation and extraction techniques. Analyzes current reporting methodologies.

What You'll Do:

• Creates reports in accordance with user information and specifications. Maintains/revises programming logic for existing routine reports as necessary to report timely and accurate data.
• Analyzes current reporting methodologies. Creates and maintains computer and web-based systems for data retrieval.
• Generates routine internal and external reports on a daily, monthly, quarterly, and annual basis.
• Interviews customers to obtain criteria for requested data. Adds and updates programming logic in accordance to customer specifications and requirements.
• Assists with system testing and provides technical support.
• Assists with departmental training issues. Participates on project teams to develop, maintain, and implement new processes, applications, policies, and forms.

Required Education:

• Associate's degree

Degree Equivalency:

• 2 years of job-related work experience for a total of 5 years of required work experience (see "required work experience")

Required Work Experience:

• 3 years experience working with database, mainframe, or spreadsheet applications. 3 years experience with Easytrieve, DB2, SQL, or similar programs. (may be concurrent)

Required Skills and Abilities:

• Strong computer experience with solid background using spreadsheet and database applications.
• Attention to detail.
• Good organizational, analytical, customer service, and communication skills.
• Knowledge of mathematical or statistical concepts.
• Ability to comprehend the differences among dataset types.

Required Software and Tools:

• Microsoft Office

We Prefer That You Have:

• Visual Basic Experience
• MS Access Experience

What We Can Do for You:

We understand the value of a diverse and inclusive workplace and strive to be an employer where employees across all spectrums have access and opportunity to develop their skills, advance their careers and contribute their unique abilities to the growth of our company.

Our comprehensive benefits package includes:

• Subsidized health plans, dental and vision coverage
• 401K retirement savings plan with company match
• Life Insurance
• Paid Time Off (PTO)
• Nine paid holidays
• On-site cafeterias and fitness centers in major locations
• Wellness program and healthy lifestyle premium discount
• Tuition assistance
• Service recognition
• Employee Assistance
• Discounts to movies, theaters, zoos, theme parks and more

Equal Employment Opportunity Statement

BlueCross BlueShield of South Carolina and our subsidiary companies maintain a continuing policy of nondiscrimination in employment to promote employment opportunities for persons regardless of age, race, color, national origin, sex, religion, veteran status, disability, weight, sexual orientation, gender identity, genetic information or any other legally protected status. Additionally, as a federal contractor, the company maintains affirmative action programs to promote employment opportunities for individuals with disabilitiesand protected veterans. It is our policy to provide equal opportunities in all phases of the employment process and to comply with applicable federal, state and local laws and regulations.

We are committed to working with and providing reasonable accommodations to individuals with disabilities, pregnant individuals, individuals with pregnancy-related conditions, and individuals needing accommodations for sincerely held religious beliefs, provided that those accommodations do not impose an undue hardship on the Company.

If you need special assistance or an accommodation while seeking employment, please email [e-mail] or call 800-288-2227, ext. 47480 with the nature of your request. We will make a determination regarding your request for reasonable accommodation on a case-by-case basis.

We participate in E-Verify and comply with the Pay Transparency Nondiscrimination Provision. We are an Equal Opportunity Employer. Here's moreinformation.

Some states have required notifications. Here's more information.