Data Engineer
Job Description
Kinsale Insurance is hiring a Data Engineer in Richmond, VA (onsite) to build and improve scalable data solutions for the Technology team.
Responsibilities
- Design, develop, test, and maintain scalable database pipelines aligned with business requirements.
- Build ETL and data conversion processes using industry-standard tools.
- Perform ad-hoc data extraction and complex analysis, and provide clear, comprehensive reporting.
- Support database security, backup and recovery, and troubleshoot data and database issues.
- Develop and enhance data governance and data analytics platforms focused on data quality and data-driven decision-making.
- Monitor system performance, identify root causes, and recommend improvements to data reliability, efficiency, and quality.
- Automate manual work and use generative AI tools (e.g., Claude Code, ChatGPT) to speed development, documentation, and learning.
- Use sound judgment when selecting which data is appropriate to share with AI tools.
- Create and maintain documentation for enterprise data support.
Requirements
- Bachelor’s degree in Computer Science, Technology, or a related field (or equivalent experience).
- Strong SQL skills with experience in relational databases and public cloud data practices.
- Proven experience building data transformation, data modeling, and data curation processes at scale.
- Experience implementing database technologies including transaction processing, analytics, security, logging, and monitoring.
- Proficiency in object-oriented programming and software engineering best practices.
- Analytical, solution-focused problem solving with the ability to manage multiple initiatives and work independently and collaboratively.
- Effective collaboration and communication skills.
- Aptitude for leveraging AI tools and staying current with emerging LLM technologies.
Technology Stack
- SQL, ETL
- Java
- Agile, CI/CD
- Liquibase, Flyway
- AWS
- Dimensional modeling
- Data warehouses, data marts
- Data vault methodologies
- Qlik Sense, QlikView
- Talend
- NoSQL technologies (e.g., PostgreSQL JSONB, DynamoDB, MongoDB)
- Claude Code, ChatGPT, LLM technologies
Benefits
- Health, dental, and vision insurance with up to $3,600 (individual) or $7,000 (family) in HSA contributions per year.
- Generous paid time off: 22 days of PTO plus 10 paid company holidays.
- Up to 6% matching 401(k) contributions on base salary and bonus.
- Standard life insurance and disability coverage.
- Annual $3,000 reimbursement for educational training and certifications.
Compensation
- USD 95,000 - 115,000 per year.
Integrity and Responsibility
- Kinsale values strong financial responsibility; a credit check may be conducted as part of the selection process for roles requiring sound judgment, trustworthiness, or access to sensitive information.