Business Analytics Advisor

The Cigna Group; Morris Plains (NJ); On-site; USD 96,000 - 101,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401K

Job summary

The Cigna Group seeks a contractor to join our data analytics team as a Teradata SQL developer/lead and data analyst. You will work on an IBM Mainframe environment to build custom output files for clients, writing SQL to meet requirements and ensuring quality through Agile collaboration.

Candidates should have Teradata SQL experience, Unix/Linux shell scripting, and strong communication skills. This temporary assignment is hosted by Magnit with no visa sponsorship.

Qualifications

• Teradata SQL experience and IBM Mainframe background preferred.
• Experience in Agile environments and strong communication skills required.
• Proficiency in Unix/Linux Shell scripting.

Responsibilities

• Collaborate in an Agile team to deliver solutions on client requirements.
• Create technical designs and solutions that meet business needs.
• Write efficient Teradata SQL to extract data for outputs.
• Develop Unix/Linux shell scripts for data processing.
• Participate in all technical phases of each project and ensure timely delivery.
• Coordinate with QA teams to resolve design issues and ensure quality.
• Troubleshoot and maintain application and system solutions.

Skills

Teradata SQL

Agile

Communication

Team collaboration

Unix/Linux Shell scripting

Education

Bachelor’s degree in CS/Software Systems/Computer Applications

High School Diploma or GED

Tools

Jira

IBM Mainframe

JCL

CA7

Job description

This position is a temporary assignment. As a contractor, you’ll be employed by Magnit, not The Cigna Group or any subsidiaries of The Cigna Group.

• Must be eligible to work on a W2 basis without sponsorship.***

Job Description

Seeking Teradata SQL developer/lead and data analyst with experience working on an IBM Mainframe to build custom output files for our clients/vendors. Candidates will need to quickly get familiar with the Enterprise Data Warehouse that sources our output data and be able to write SQL queries to extract the data needed to deliver on client requirements.

Job Specifics

• Candidate must have experience working in an Agile environment and with being a collaborative member of an Agile team. Candidate must be good communicator and have strong people skills.
• Must be able to create Technical designs and solutions that deliver quality solutions for client and business needs.
• Must have a thorough understanding of Teradata- how it processes and stores data and how to write efficient SQL to retrieve data needed
• Must have Unix/Linux Shell scripting experience.
• Participate in all technical phases of each project assigned.
• Accountable for quality and timeliness of product development, technical design and solution implementation as a development team member.
• Partners with QA teams to resolve solution design deficiencies and related deliverables.
• Troubleshoots, maintains, and develops application and system solutions for business mandated products and regular operational processes.

Job Qualifications Considered a Plus

• Previous experience in Health care or PBM industry
• Jira
• PBM or Health Care business experience
• IBM Mainframe: 5+ years
• JCL: 5+ years
• CA7: 5+ years
• Teradata SQL experience: 5+ years
• Agile: 3+ years
• Unix/Linux Shell Script : 2+ Years

Bachelor’s degree or equivalent in Computer Science, Software Systems, Computer Applications PREFERRED

High School Diploma Or GED REQUIRED

Hourly Pay Rate Range (dependent on location, experience, expectation)

The pay range that Magnit reasonably expects to pay for this position is: $70.00/hour-$73.00/hour

Benefits

• Medical
• Dental
• Vision
• 401K(provided minimum eligibility hours are met)

We are unable to provide visa sponsorship or STEM OPT training.

We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations. Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.