Business Analytics Senior Advisor (SQL Development) - Remote
Summary 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. Responsibilities • 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 Qualifications • IBM Mainframe: 5+ years • JCL: 5+ years • CA7: 5+ years • Teradata SQL experience: 5+ years • Agile: 3+ years • Linux/Unix: 2+ years • Python & Java: 2+ years • Previous experience in Health care or PBM industry is highly desired • Jira experience is highly desired If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload. For this position, we anticipate offering an annual salary of 109,500 - 182,500 USD / yearly, depending on relevant factors, including experience and geographic location. This role is also anticipated to be eligible to participate in an annual bonus plan. We want you to be healthy, balanced, and feel secure. That's why you'll enjoy a comprehensive range of benefits, with a focus on supporting your whole health. Starting on day one of your employment, you'll be offered several health-related benefits including medical, vision, dental, and well-being and behavioral health programs. We also offer 401(k) with company match, company paid life insurance, tuition reimbursement, a minimum of 18 days of paid time off per year and paid holidays. For more details on our employee benefits programs, visit Life at Cigna Group. About The Cigna Group Doing something meaningful starts with a simple decision, a commitment to changing lives. At The Cigna Group, we're dedicated to improving the health and vitality of those we serve. Through our divisions Cigna Healthcare and Evernorth Health Services, we are committed to enhancing the lives of our clients, customers and patients. Join us in driving growth and improving lives. 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. If you require reasonable accommodation in completing the online application process, please email: [email protected] for support. Do not email [email protected] for an update on your application or to provide your resume as you will not receive a response. The Cigna Group has a tobacco-free policy and reserves the right not to hire tobacco/nicotine users in states where that is legally permissible. Candidates in such states who use tobacco/nicotine will not be considered for employment unless they enter a qualifying smoking cessation program prior to the start of their employment. These states include: Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Ohio, Pennsylvania, Texas, Utah, Vermont, and Washington State. Qualified applicants with criminal histories will be considered for employment in a manner consistent with all federal, state and local ordinances. Apply tot his job