Application Development Lead Analyst

About Evernorth: Evernorth Health Services, a division of The Cigna Group (NYSE: CI), creates pharmacy, care, and benefits solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention, and treatment of illness and disease more accessible to millions of people. Innovation and Automation Application Development Lead Analyst Position Overview: The Innovation and Automation team partners with business and IT stakeholders throughout the enterprise to design, build, and deploy custom Automation and Analytic solutions. This role will partner with business operations stakeholders, and requires a candidate with a learning mindset, a strong background in data analytics, and an aptitude for translating business needs into technical requirements. In this role you will be responsible to learn and understand the business, become a SME on the data, and build cutting-edge, innovative analytics that provide actionable insights on known value streams while discovering opportunities for further analysis. Key Responsibilities: Engage with business partners to understand analytic and data gaps and facilitate working sessions to design and prototype data integration solutions and automation Translate business needs into technical requirements, and translate technical results into meaningful, actionable information for non-technical stakeholders Design, develop and optimize complex SQL queries to extract, filter, and aggregate data from different relational databases. Collaborate with cross functional teams including data architect, business analysts to understand integration requirements and ensure data integrity Participate in the design and implementation of database structures, schemas and data models to facilitate efficient data storage and retrieval. Develop and maintain ETL processes to extract, transform, and load data from various sources into target database implement data quality checks and validation procedures to identify and address data inconsistencies. Pioneer new technologies and methodologies for automation and data analysis Take ownership of relationships, projects, and goals Required Experience / Qualifications: Bachelors degree in computer science or related field Minimum 5 years of experience as SQL developer or similar roles Strong proficiency in SQL and experience with relational database systems Solid understanding of database design principles, indexing strategies and query optimization techniques API Programming experience to retrieve data from various sources. Communicating with and influencing various teams and distilling relevant technical information for the audience Data visualization using any visualization tool ortechnology Connecting the dots between long- and short-term business objectives, and driving business value via automation and analytics Desired Experience / Qualifications: Experience in Healthcare domain Data analysis experience using Python is good to have Experience with Selenium web scrapping is plus Knowledge about Service Now is good to have Statement of Commitment: 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.