Data Architect (Life & Annuity Insurance Experience Mandatory) - Remote

Role: Data Architect (Life & Annuity Insurance Experience Mandatory)
Location: REMOTE
Duration: FTE

Must-Have Skills

• Insurance Domain Experience: 5+ years
• ETL Development
• Python
• PySpark
• AWS Cloud

Job Summary
The Data Architect will lead the design and maintenance of the data infrastructure that enables secure data storage, access, and analytics across business and client needs. This role defines how data is collected, structured, integrated, and governed to ensure scalability, security, and performance.

The position plays a critical role in supporting business intelligence, regulatory, and compliance initiatives within the Life & Annuity Insurance domain.

Years of Experience Required

• 15+ years in Data Engineering
• Minimum 5+ years exclusively in the Insurance domain

Key Responsibilities:

• Define data architecture strategies, frameworks, and models
• Design and optimize databases, data warehouses, and data lakes
• Ensure data structures align with business requirements and compliance standards
• Collaborate with data engineers, analysts, and client teams on pipeline architecture
• Oversee metadata management, data catalogs, and lineage tracking
• Ensure data integrity, scalability, and performance
• Select appropriate storage and cloud platforms (Snowflake, AWS, Azure, BigQuery, Redshift)
• Support data governance and access control policies
• Review existing systems for enhancements, optimization, or migration
• Document technical standards, architectural designs, and decisions
• Lead system design with strong strategic alignment and governance

Technical Skills:

• Experience designing, implementing, and managing data analytics solutions using Databricks in the Insurance domain
• Proven experience building ETL pipelines from multiple data sources using Databricks on AWS
• Design and implement scalable ETL pipelines to process and transform large datasets
• Collaborate with data scientists, analysts, and stakeholders to deliver high-quality data solutions
• Optimize data workflows while ensuring data quality and integrity
• Monitor and troubleshoot data pipeline performance, implementing improvements as needed
• Leverage AWS cloud services for efficient data storage and processing
• Document data engineering processes, architecture, and best practices
• Stay up to date with emerging data engineering and cloud technologies
• Strong proficiency in Python, PySpark, and SQL with hands-on data pipeline development
• Experience in Data Modeling, Data Lineage, and Canonical Data Model implementation
• Experience implementing Medallion Architecture
• Strong experience in the Insurance domain
• Experience working with JIRA

Mandatory Skills:

• Strong expertise in Databricks, including ETL pipeline development and optimization
• Proven experience with AWS cloud services
• Solid understanding of data modeling, data warehousing, and data integration
• Proficiency in Python or Scala for data transformation
• Strong hands-on experience with Python, PySpark, and SQL
• Familiarity with data governance and data quality frameworks
• Experience with Power BI
• Experience using GitLab
• Experience working in Agile methodologies

Education & Certifications:

• MCA or bachelor s degree in engineering from a reputed institution
• Databricks Certification Preferred
• LOMA Certification (Insurance) Preferred