Software Engineering Associate Advisor

Job description:

Data Engineering

Position Overview

Evernorth, a leading Health Services company, is looking for exceptional data engineers/developers in our Data and Analytics organization. In this role, you will actively participate with your development team on initiatives that support Evernorth's strategic goals as well as subject matter experts to understand business logic you will be engineering. As a software engineer, you will help develop an integrated architectural strategy to support next-generation capabilities on an enterprise-wide scale. You will work in an agile environment, delivering user-oriented products.

The ideal candidate will work in a team environment that demands technical excellence, whose members are expected to hold each other accountable for the overall success of the end product. Focus for this team is on the delivery of innovative solutions to complex problems, but also with a mind to drive simplicity in refining and supporting of the solution by others.

Roles & Responsibilities:

• Configure and manage VDP, Solution Manager for revision control, environment promotions, and deployment lifecycle governance.
• Set up and maintain Denodo cache databases and log monitoring databases.
• Lead JVM tuning, memory optimization, and OS-level configuration for Denodo on AWS EC2.
• Architect and manage Presto/MPP engine configurations including performance tuning, query profiling, and resource allocation for concurrent workloads.
• Configure and optimize data source connectivity: Snowflake, REST APIs, Google Analytics, Oracle, Teradata, Cloudera Impala, SQL Server, IBM DB2, MySQL, S3.
• Develop and review complex view hierarchies (base views, derived views, interface views, flatten views) per business requirements.
• Design and expose Denodo views as REST/OData APIs for downstream system consumption.
• Lead large-scale migration initiatives (Business Objects, Teradata SQL) to Denodo.
• Configure LDAP-based authentication and authorization groups.
• Define release management processes and change control standards.
• Coordinate with Unix/Application/Security teams for change approvals, maintenance windows, and server reboots.
• Deploy and manage Denodo platform components (VDP, Scheduler, Solution Manager) as containerized workloads using Docker and Kubernetes (AWS EKS), including Helm-based provisioning, pod scaling, health probes, and rolling upgrades.
• Manage AWS infrastructure for Denodo environments - EC2, S3 (data source/cache storage), ALB/NLB, VPC/Security Groups, IAM roles, CloudWatch monitoring, and Secrets Manager for secure credential management.
• Implement Infrastructure-as-Code (Terraform/CloudFormation) and CI/CD pipelines for automated, repeatable Denodo deployments across environments with auto-scaling policies based on query concurrency and workload patterns.

Qualifications:

• 10 - 12 years of relevant experience development.
• 4+ years of experience on Databricks.
• 4+ years of experience on Python.
• Hands-on experience with building data integration solutions.
• Experience with both NoSQL and relational database development - e.g. Mongo, Postgres, Teradata, SQL Server required.
• Experience with Data Warehouse, Data Lake, and Lakehouse technologies.
• Strong understanding of database concepts and experience with query optimization and performance tuning.
• Hands-on experience with scripting languages like Python.
• Hands-on experience with Databricks and Airflow monitoring.
• Excellent problem-solving skills and the ability to analyze complex issues and implement effective solutions.
• Experience with Denodo Platform administration including VDP server configuration, data source setup, view creation (base views, derived views, interface views), role-based access control (RBAC), and cache management.
• Hands-on experience with Denodo Solution Manager for environment promotion, deployment management, and multi-environment lifecycle (DEV to PROD) governance.
• Experience configuring and tuning Presto/MPP engine within Denodo, including memory settings, concurrent query limits, and query cost optimization.
• Familiarity with Denodo SSO integration using SAML/OAuth providers (e.g., Okta) and managing user/group mappings across environments.
• Experience with Denodo JDBC/ODBC connectivity to BI tools such as Tableau, including driver configuration and connection troubleshooting.
• Hands-on experience in automating code/artifact migration across environments (DEV to UAT to PROD) using CI/CD pipelines, scripting, or platform-native tools such as Denodo Solution Manager, Databricks Repos, or AWS CodePipeline.

Required Skills:

• Python, Databricks, Cloud Experience (AWS/Azure)
• Denodo VDP, Presto/MPP, Data Virtualization

Preferred Skills, Experience & Education:

• Data Virtualization tools, Databricks Certifications, Cloud Certification (AWS Developer Associate or similar)
• Denodo Platform 8.0+ certification or equivalent hands-on admin experience.
• Experience deploying and managing Denodo on AWS EC2, including OS-level configuration, JVM tuning, and log management.

Skills

Databricks, Denodo, Python, VDP