Description
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 their 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 upstream data owners, business stakeholders, and analysts to understand reporting and analytics end-state and drive the creation of scalable and documented data design solutions.
- Implement data strategies, build data flows, and develop conceptual data models with the development team.
- 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.
- Implement and publish a data access layer in the data lake optimized for reporting and analytical needs based on business requirements.
- Support and evolve 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 managers, and team members in a Scaled Agile framework.
Qualifications:
- Bachelor's degree in Computer Science, Electrical Engineering, Mechanical Engineering, or a related field and 5 years of experience.
- Experience with data profiling, data analysis, creating data architecture frameworks, and governance models based on enterprise data strategy.
- Experience with creating logical and physical data models based on business requirements, forward engineering data models in databases, maintaining ETL pipelines, and creating technical specs.
- Experience with relational databases, NoSQL data stores, cloud technology, Spark, Amazon Web Services (AWS), SQL, and Erwin.
Benefits:
- Work-from-home benefit available.
- Internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload.