Description
Cigna-Evernorth Services Inc. seeks an Application Development Senior Advisor for the Morris Plains, NJ location to develop real-time and batch processing data pipelines to enhance Cigna's digital experiences and analytics.
Responsibilities:
- Develop solutions using tools in AWS, Databricks, Airflow, Redshift, DynamoDB, Elasticsearch, RDS, Snowflake, and Machine Learning tools.
- Develop production data pipelines using Spark with Scala, Python, SQL, and implementing machine learning algorithms on Databricks and AWS.
- Participate in architectural decision-making processes for data pipelines and implement advanced analytics solutions, ensuring alignment with organisational goals.
- Assemble large and complex data sets, ensuring that all functional and analytics business requirements are met with high quality and performance standards.
- Utilise Generative AI tools to automatically generate comprehensive descriptions for data tables and columns and ingest the generated metadata into the Collibra Data Catalog via APIs.
- Demonstrate experience in implementing data governance and access control within the Healthcare domain.
- Configure Immuta to enable column-level masking for PII and PHI, as well as row-level security.
- Lead the adoption of Gen AI-enhanced development pipelines with Cursor AI, focusing on advanced debugging, code generation, and context-aware engineering across multi-file projects.
- Apply expert prompt engineering techniques to improve the reliability and performance of AI-driven data workflows.
- Continuously test and refine prompts to achieve optimal outcomes.
- Manage GitHub repositories and GitHub Actions CI/CD pipelines to automate deployment of Databricks jobs and notebooks.
- Collaborate with stakeholders, including executive leadership, product, and engineering teams, to resolve data-related technical issues and support their data infrastructure needs.
- Mentor, collaborate and upskill junior engineers with translating complex business requirements into scalable data solutions to ensure team-wide technical excellence.
Qualifications:
- Master's degree Computer Science, Business Analytics or related field and 3 years of experience. Will accept a Bachelor's degree and 5 years of experience.
- Must have experience with: developing and managing scalable ETL pipelines, collaborative analytics workflows, and production-grade data solutions using PySpark;
- Leveraging AWS S3 for storage and integration;
- Writing advanced SQL queries for data extraction, transformation, and analysis within large-scale data environments;
- Designing and implementing logical and physical data models;
- Applying best practices for schema design;
- Maintaining enterprise-level data warehouses with reliable ETL processes;
- Orchestrating, monitoring, and optimising big data pipelines for the ingestion, transformation, and quality assurance of high-volume data across distributed computing frameworks; and
- Troubleshooting, optimising query performance and execution plans, and resource allocation for large-scale datasets.
Benefits:
- Comprehensive range of benefits, including medical, vision, dental, and well-being and behavioural health programs
- 401(k)
- Company-paid life insurance
- Tuition reimbursement
- Minimum of 18 days of paid time off per year
- Paid holidays and leaves of absence