Data Architect

Role : Data Architect
Location : Bloomfield, CT
Position Type : Contract

Job Description:

Primary Skills
1. Data Engineering Data Architecture
2. Advanced SQL Data Modelling
3. Python
4. Amazon Redshift Redshift Serverless
5. Apache Airflow
6. AWS Data Engineering
7. ETL ELT Data Integration
8. Data Warehousing
9. Event Driven Data Pipelines
10. Data Quality Performance Monitoring Task

1. The Senior Data Engineer Architect leads the architecture engineering and delivery of enterprise data solutions supporting healthcare insurance underwriting and actuarial pricing capabilities
2. The role combines Handson data engineering with architecture business collaboration and technical leadership to build scalable reliable and secure cloud native data platforms
3. The candidate should have strong experience with SQL Python AWS Redshift Airflow data modelling and enterprise data integration

Key Responsibilities
1. Define and evolve enterprise data architecture data warehouses and integration solutions
2. Design and build scalable data pipelines integrating applications databases APIs and files
3. Develop Redshift data models transformations and curated datasets for downstream analytics
4. Build scheduled workflows using Airflow and event driven pipelines using AWS services
5. Work with AWS services including S3 Lambda DynamoDB SQS Glue and Event Bridge
6. Partner with actuarial pricing underwriting business product and technology teams
7. Improve data quality reliability security performance and production monitoring
8. Optimize Redshift Serverless RPU utilization and AWS costs through performance and capacity management
9. Troubleshoot production issues and manage pipeline retries backfills and recovery
10. Lead technical designs and architecture reviews while mentoring engineering teams
11. Apply AI assisted engineering practices across development testing analysis and documentation
12. Communicate architecture decisions dependencies risks and technical tradeoffs to stakeholders

Technical Skills Nice to Have
1. Boomi API Services
2. Qlik Data Integration
3. Redshift Serverless
4. Terraform
5. Liquibase
6. AWS Event Driven Architecture
7. APIs Enterprise Data Integration
8. Production Monitoring Observability
9. Data Privacy Security
10. Healthcare Insurance Domain Knowledge
11. Actuarial Pricing Rating
12. Underwriting Applications
13. Education
14. Bachelor's degree

Soft Skills
1. Excellent Communication
2. Stakeholder Management
3. Technical Leadership
4. Analytical Thinking
5. Problem Solving
6. Collaboration
7. Business Acumen
8. Mentoring Team Leadership