Architecture Senior Advisor

Cigna-Evernorth Services Inc. seeks an Architecture Senior Advisor for the St. Louis, MO location to design and implement major components and domains of the data architecture and data models to modernize and transform our company’s Reporting & Analytics applications. Responsibilities: • Focus on source system knowledge, data analysis, business requirements and providing conceptual, logical and physical data model designs to support various initiatives in an agile environment. • Review existing data models to understand the current environment and recommend changes to optimize data requirements. • Work closely with the upstream data owners, business stakeholders, and analysts to understand reporting and analytics end state in order to drive the creation of scalable and documented data design solutions. • Work with the development team to implement data strategies, build data flows, and develop conceptual data models. • Act as a Subject Matter Expert in Data Architecture and Database design using AWS services including Redshift and PostgreSQL, specializing in designing high-efficiency, scalable, and reusable architectures. • Conduct programming and querying using SQL and Spark. • Mentor junior developers and analysts to adopt best practices in query design and performance optimization. • Build logical and physical data models utilizing industry best practices. • Work closely with the business intelligence team to implement/publish a data access layer in the data lake that is optimized for reporting and analytical needs based on business requirements. • Support and evolving standards for all cycles of visual product development including requirements, prototyping, code development, versioning, documentation, and maintenance. • Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks. • Collaborate with product owners, scrum masters, program manager and team members in a Scaled Agile framework. • Work from home benefit available. Qualifications: • Bachelor’s degree in Computer Science, Electrical Engineering, Mechanical Engineering or related field and 5 years of experience. • Requires experience with: Data Profiling/Data Analysis; • Creating data architecture framework and governance model based on enterprise data strategy; • Creating logical and physical data models based on business requirements; • Creating and implementing new designs for better performance and eliminating redundant data for large scale Enterprise Data Warehouses; • Creating technical specs such as Mapping documents and Function Data Requirements; • Creating Data Models for both Operational and Transactional Systems; • Forward engineering data models in databases including Oracle, MySQL, and PostgresSQL; • Maintaining ETL pipelines in Informatica; • Creating mappings to move data from SQL Server to a Salesforce environment; • Creating completeness check, length check, and pattern check mapplets for data governance rules in Redshift and MySQL; • Designing and implementing distributed data pipelines and integration architecture in cloud and on-premises environments including Salesforce, Oracle, and SQL Server; • Working on generating dashboards in Tableau; • Managing data in regulated healthcare environments; • Relational databases, NoSQL, data stores, cloud technology, Spark, Amazon Web Services (AWS); and • Using: SQL and Erwin. 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. 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 need a reasonable accommodation to complete the online application process, please email seeyourself@thecignagroup.com for assistance. Please note that this email inbox is dedicated to accommodation requests only and cannot provide application updates or accept resumes. 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.