onsite
Senior Software Engineering Advisor - The Cigna Group
Software Engineer
Senior software engineer leading the design and maintenance of enterprise‑scale data warehouses, building high‑performance SQL and software solutions to enable analytics, reporting, and strategic insights.
About the role
Key Responsibilities
- Architect, design, and evolve a conformed enterprise data warehouse that supports analytics, business intelligence, and reporting across the organization.
- Develop and maintain high‑quality, scalable SQL code and data pipelines that meet technical design specifications and business requirements.
- Implement ETL/ELT processes, data modeling, and data integration strategies to ensure data reliability, accessibility, and performance.
- Collaborate with data analysts, product owners, and infrastructure teams to translate business needs into robust data solutions.
- Monitor, troubleshoot, and optimize data platform performance, ensuring operational stability and adherence to SLAs.
- Champion best practices for data governance, security, and documentation within the data ecosystem.
Requirements
- 7+ years of experience designing, building, and maintaining large‑scale data warehouses or data platforms.
- Expertise in SQL development, data modeling, and ETL/ELT processes.
- Strong programming skills in Python (or comparable language) for data engineering tasks.
- Hands‑on experience with cloud data services (e.g., AWS Redshift, Snowflake, Azure Synapse) and modern data stack tools.
- Proven ability to solve complex data problems, optimize performance, and ensure data quality and security.