DeveloperJobs.io
← Back to all jobs

Job Description

As an AWS Data Solutions Architect, you will design and deliver scalable cloud data platforms that support reliable analytics, reporting, and business insights for Property and Casualty Insurance operations. The role focuses on data architecture, pipeline development, Snowflake solutions, and deployment practices that help ensure trusted enterprise data products.

Responsibilities

  • Design and implement scalable data architectures for high-volume ingestion, transformation, and consumption across hybrid cloud environments.
  • Develop, optimize, and maintain data pipelines using Python, PySpark, and AWS to produce curated, trusted datasets for analytics and business use.
  • Build and manage Snowflake data solutions, including schema design, performance tuning, and query optimization for enterprise reporting and analytical workloads.
  • Apply CI/CD best practices using Jenkins and GitHub to support efficient, reliable, and traceable deployment of data engineering solutions.
  • Collaborate with cross-functional teams to translate business requirements into scalable data models while ensuring data quality, governance, security, and operational excellence.

Requirements

  • Strong experience designing and building enterprise data engineering solutions using Python, PySpark, and Unix/Linux environments.
  • Hands-on experience with AWS services, including EMR, with proven ability to develop and optimize cloud-based data processing solutions.
  • Advanced experience with Snowflake, including data modeling, schema design, performance tuning, and query optimization.
  • Experience implementing and supporting CI/CD pipelines using Jenkins and source control best practices using GitHub.
  • Proven expertise building and supporting large-scale ETL and data pipeline solutions with a focus on data quality, reliability, and scalability.
  • Ability to troubleshoot production data issues, perform root cause analysis, and improve operational stability.
  • Strong communication and stakeholder management skills, with effective collaboration across business and technical teams.

Technology Stack

AWS, EMR, Snowflake, Python, PySpark, Unix/Linux, Jenkins, GitHub

Work Model and Location

Hartford, CT (Hybrid). Hybrid role requiring 3 days per week in a Cognizant or client office in the Hartford, CT area.

Additional Skills That Help You Stand Out

  • Experience supporting Property and Casualty (P&C) Insurance data domains, including policy, claims, underwriting, or risk-related datasets.
  • Experience with cloud cost optimization, workload tuning, and performance management across AWS environments.
  • Knowledge of data governance, role-based access controls, data masking, and data security best practices.
  • Experience developing data quality frameworks, validation processes, and reconciliation controls.
  • Ability to document technical solutions, data flows, and operational procedures for enterprise-scale platforms.

Similar Jobs