Application Development Senior Advisor- Hybrid

About The Cigna Group

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 an physical data models;
• Applying best practices for schema design;
• Maintaining enterprise-level data warehouses with reliable ETL processes;
• Orchestrating, monitoring, and optimizing big data pipelines for the ingestion, transformation, and quality assurance of high-volume data across distributed computing frameworks; and
• Troubleshooting, optimizing query performance and execution plans, and resource allocation for large-scale datasets.
• Salary Range: $193,461-$203,600
• 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.
• For this position, we anticipate offering an annual salary of 122,200 - 203,600 USD / yearly, depending on relevant factors, including experience and geographic location.
• At The Cigna Group, you’ll enjoy a comprehensive range of benefits, with a focus on supporting your whole health. Starting on day one of your employment, you’ll be offered several health-related benefits including medical, vision, dental, and well-being and behavioral health programs. We also offer 401(k), company paid life insurance, tuition reimbursement, a minimum of 18 days of paid time off per year, paid holidays, and leaves of absence. For more details on our employee benefits programs, click here.

Preferred Qualifications

• This role is also anticipated to be eligible to participate in an annual bonus plan.

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 organizational goals.
• Assemble large and complex data sets, ensuring that all functional and analytics business requirements are met with high quality and performance standards.
• Utilize 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 a 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.
• Hybrid work schedule.