Architecture Senior Advisor
At a glance
AI generatedTL;DR
Cigna-Evernorth Services Inc. is hiring an Architecture Senior Advisor in St. Louis, MO to lead the modernization of Reporting & Analytics applications by designing and implementing data architecture and models. This role involves analyzing business requirements, optimizing existing data models, and collaborating with stakeholders to create scalable solutions. The advisor will work closely with development teams to build efficient data flows and conceptual models using AWS services like Redshift and PostgreSQL, while also mentoring junior staff in best practices for query design and performance optimization. Key responsibilities include building logical and physical data models, implementing a data access layer optimized for reporting needs, and supporting visual product development cycles. The ideal candidate has 5 years of experience with data profiling, architecture framework creation, and maintaining ETL pipelines, along with expertise in SQL, Spark, AWS, and relational databases like Oracle and PostgreSQL.
Skills
What you'll do
- Design and implement major components of the data architecture to support Reporting & Analytics applications.
- Review existing data models and recommend changes to optimize data requirements for various initiatives.
- Develop scalable and documented data design solutions by working closely with business stakeholders and analysts.
- Mentor junior developers in best practices for query design and performance optimization using SQL and Spark.
- Build logical and physical data models utilizing industry best practices, focusing on AWS services like Redshift and PostgreSQL.
- Implement a data access layer optimized for reporting and analytical needs based on business requirements.
What we're looking for
- 5+ years of experience in data architecture and database design.
- Expertise in AWS services like Redshift and PostgreSQL for scalable architectures.
- Proficiency in SQL, Spark, and data profiling/analysis.
- Ability to create logical and physical data models based on business requirements.
- Experience with ETL pipelines, mappings, and completeness checks in various databases.
- Knowledge of relational databases, NoSQL, cloud technology, and healthcare regulations.
- Skills in designing distributed data pipelines and integration architecture.
Employer
About Cigna
The Cigna Group is a global health company, rebranded in 2023, that serves over 185 million customer relationships across 30+ countries.
Cigna currently has 38 open roles on FindRole.
Listed pay typically runs $131,997–$217,000 across 13 roles with salary data.
Most-posted roles
- Software Engineering Advisor- Hybrid 4
- Software Engineering Senior Advisors- Hybrid 3
- Application Development Senior Advisor- Hybrid 2
- Architecture Senior Manager 2
- Database Administration Senior Advisor- Hybrid 2