Data Engineer
Job Description
Kinsale Insurance is hiring a Data Engineer for its Technology team in Richmond, VA (onsite). You will design, build, test, and deploy scalable data solutions that improve reliability, efficiency, and data quality. The role centers on ETL/data pipelines, governance, reporting, and database security support, with opportunities to automate work and accelerate development using generative AI tools.
What you’ll do
- Design, develop, test, and maintain scalable database pipelines aligned to business requirements.
- Implement ETL and data conversion processes using industry-standard tooling.
- Perform ad-hoc data extraction and complex analysis, then deliver clear, comprehensive reports.
- Provide technical support and guidance for database security, backup and recovery, and troubleshooting.
- Develop and enhance data governance and data analytics platforms to support data quality and data-driven decision-making.
- Monitor system performance, diagnose root causes, and recommend improvements to data reliability, efficiency, and quality.
- Automate manual work and use generative AI tools (for example, Claude Code and ChatGPT) to speed up development, documentation, and learning, with sound judgment about which data is appropriate to use with AI tools.
- Create and maintain documentation for enterprise data support.
What you’ll bring
- Bachelor’s degree in Computer Science, Technology, or a related field (or equivalent experience).
- Strong SQL skills and experience with relational databases plus public cloud data practices.
- Proven experience building processes for data transformation, data modeling, and data curation, including large-scale implementation across 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 balance multiple initiatives and work independently and in a team.
- Effective collaboration and communication skills, along with an aptitude for leveraging AI tools and staying current with emerging LLM technologies.
Tools and technologies
SQL, ETL, Java, Agile, CI/CD, Liquibase, Flyway, AWS, dimensional modeling, data warehouses, data marts, data vault methodologies, Qlik Sense, QlikView, Talend, NoSQL technologies (including PostgreSQL JSONB, DynamoDB, MongoDB), plus 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.
- 22 days of PTO and 10 paid company holidays.
- Up to 6% matching 401(k) contributions on base salary and bonus.
- Standard life insurance and disability coverage.
- $3,000 annual reimbursement for educational training and certifications.
Integrity & responsibility
Kinsale values strong financial responsibility. A credit check will be conducted as part of the selection process for roles that require sound judgment, trustworthiness, or access to sensitive information.
Salary range: $95,000 - $115,000 per year.