Senior Data Solutions Architect

Kinsale Insurance is seeking a Senior Data Solutions Architect to lead the design and implementation of our next-generation data platforms. This hybrid role blends strategic architecture with hands-on engineering and cloud development. The ideal candidate is versatile with technology and passionate about building scalable data solutions driving data quality and enabling advanced analytics and AI/ML across the enterprise.

This role works closely with Data Architects Enterprise Architects Engineers Analysts and cross-functional teams to define and execute a modern data strategy that supports core business and AI-driven innovation.

Responsibilities

• Understand business data and technology requirements with the existing environment and translate these and new requirements into technical specifications. This includes but is not limited to data modeling data streaming implementations and integrations of data sources transformations (ETL/ELT) performance tuning and data security.
• Define and evolve enterprise data architecture standards data models and integration patterns across transactional operational and analytical systems.
• Design performant and scalable data solutions that support both traditional BI and modern AI/ML use cases.
• Champion best practices in data security availability lineage and governance.
• Evaluate select and recommend cloud-native database technologies (Databricks Snowflake etc.).
• Partner with architects and domain leads to align enterprise data vision with application and infrastructure roadmaps.
• Engineering & Implementation
• Develop and maintain data pipelines (ETL/ELT) using modern tools (e.g. Python SQL Talend).
• Build and optimize data APIs to support enterprise reference and master data strategies.
• Implement CI/CD pipelines for data platform releases schema changes and migrations.
• Automate data transformation ingestion and orchestration processes.
• Conduct data profiling quality analysis and root cause resolution.
• Lead efforts to migrate legacy databases to cloud data warehouses.
• AI & Advanced Analytics Enablement
• Collaborate with data scientists and business teams to deliver data foundations for AI/ML initiatives.
• Support AI use cases with data wrangling feature engineering and real-time scoring infrastructure.

Required Qualifications

• Bachelors degree in Computer Science Information Systems or related field.
• 8 years in enterprise data architecture data engineering or similar roles.
• Proven experience in:
• Cloud data platforms (AWS Azure or GCP)
• Building or managing large-scale cloud data warehouses (Snowflake Databricks Redshift or BigQuery)
• Data modeling (Conceptual Logical Physical/ERD)
• Experience in Python and building Python APIs is a requirement; Java is a nice to have
• Building scalable pipelines for structured and unstructured data
• Deep knowledge of relational and NoSQL databases (PostgreSQL Oracle MongoDB).
• Experience implementing security auditing backup and DR strategies for cloud-based data systems.
• Understanding of software development lifecycle (SDLC) and CI/CD (Liquibase Flyway or similar).

Preferred Qualifications

• AWS Associate or Professional certification.
• Experience with:
  • DataOps tools and orchestration frameworks (Airflow dbt)
  • BI and analytics platforms (Qlik Tableau Power BI)
  • Data science frameworks and ML operations tools (scikit-learn TensorFlow SageMaker)
  • AI/ML data pipeline support or ML feature store implementation
  • Familiarity with dimensional modeling data vaults and modern data stack tools.
  • Agile development experience and cross-functional collaboration skills.

At Kinsale we offer the following great benefits:

• Competitive salary with performance-based bonus opportunities
• Single and Family Health Dental and Vision Insurance plans with company contributed HSA funds
• Short-Term and Long-Term disability
• Life Insurance
• Matching 401(k)
• Generous Paid Time Off and Holidays
• Education dollars for training and certifications

Required Experience:

Senior IC