Business Analytics Advisor (36420866)

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. Alternate Title Teradata SQL Developer Schedule/Location: Remote, USA - CST or EST working hours. Responsibilities 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. This role also includes leading and giving guidance to less experienced team members. 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 • 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. • Hands on experience with Linux/Unix scripting • Exposure to XML related technologies especially JavaScript programming, python and JSON Job Qualifications Required • IBM Mainframe: 5+ years • JCL: 5+ years • CA7: 5+ years • Teradata SQL experience: 5+ years (must be able to modify and create scripts - not just read SQL) • Agile: 3+ years • Linux/Unix: 2+ years • Python & Java: 2+ years Job Qualifications Considered a Plus • Previous experience in Health care or PBM industry • Jira Hourly Pay Rate Range (dependent on location, experience, expectation) The pay range that Magnit reasonably expects to pay for this position is: $50.00/hour-$66.00/hour Benefits: Medical, Dental, Vision, 401K (provided minimum eligibility hours are met) Tundra Technical Solutions (the operator of this Talent Community) is a global leader of contingent talent services. Our success and our clients’ success are built on a foundation of service excellence. 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.