Data Engineer / Data Architect
Big Data
Bigdata
CI/CD
Cloud
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Operations
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
DevOps
Devops Tools
ETL
Informatica
Information Technology (IT)
Jenkins
Pyspark
Reporting and Analytics
Snowflake
Software Development
Software Engineering
Spark
SQL
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.