Data Engineer
Job Description
Kinsale Insurance is hiring a Data Engineer for its Technology team, focused on building reliable, scalable data solutions. In this Richmond, VA onsite role, you will support end-to-end data pipeline development, ETL processes, governance, reporting, and data security-adjacent troubleshooting while improving performance and quality across the platform.
What you’ll do
- Design, develop, test, and maintain scalable database pipelines that align with business requirements.
- Implement ETL and data conversion processes using industry-standard tools.
- Perform ad-hoc data extraction and complex analysis, producing clear and comprehensive reports.
- Provide technical support and guidance related to 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 tasks and use generative AI tools (such as Claude Code and ChatGPT) to speed development, documentation, and learning, using sound judgment to determine appropriate data for AI use.
- 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 and experience with relational databases and public cloud data practices.
- Proven experience building data transformation and data modeling processes, data curation, and implementing database technologies at scale, including transaction processing, analytics, security, logging, and monitoring.
- Proficiency in object-oriented programming languages and software engineering best practices.
- Analytical, solution-focused problem solving with the ability to manage multiple initiatives, both independently and as part of a team.
- Effective collaboration and communication skills, with an aptitude for leveraging AI tools and staying current with emerging LLM technologies.
Technologies you’ll work with
- 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)
- Claude Code, ChatGPT, LLM technologies
Compensation and location
Location: Richmond, VA (onsite)
Salary: USD 95,000 to 115,000 per year
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 and 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.
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.