Are you a skilled data professional who thrives on turning complex data into business-driving insights? Join Kinsale Insurance, a leading excess and surplus (E&S) lines carrier headquartered in Richmond, VA. We're known for our innovative, data-driven approach and high-touch solutions that help clients navigate complex risks. At Kinsale, technology isn't just support — it's a strategic advantage, and our Data Engineers are central to that mission.
About the RoleAs a Data Engineer on Kinsale's Technology team, you'll be at the heart of building, testing, and deploying the data pipelines that fuel our company's decision-making. You'll collaborate closely with Data Architects, Data Analysts, and our Data Ops Manager to design scalable solutions, develop data access APIs, and evolve our analytics platform. This role is ideal for someone who is equally passionate about clean architecture and practical results — and who is excited to incorporate AI tools to work smarter and faster.
What You'll Do- Designing, developing, and maintaining efficient, scalable data pipelines that align with business requirements.
- Implementing ETL processes and data conversions using industry-standard tools and best practices.
- Conducting complex data analysis and generating comprehensive reports to support strategic initiatives.
- Developing and managing data access APIs interfaced by various internal and external services.
- Monitoring system performance and proposing improvements to enhance data reliability, efficiency, and quality.
- Diagnosing and resolving root-cause issues related to database platforms and their integrations.
- Leveraging Generative AI tools (e.g., Claude Code, ChatGPT) to accelerate code generation, documentation, and development workflows — while applying sound judgment around data sensitivity and AI usage boundaries.
- Creating and maintaining documentation for databases and data processes to ensure team continuity and knowledge sharing.
- Bachelor's degree in Computer Science, Technology, or a related field — or equivalent hands-on experience.
- Advanced SQL knowledge and experience with relational databases, query authoring, and database object creation.
- Strong proficiency in Python for data engineering and automation tasks.
- Proven experience building data transformation processes, managing data structures, and handling workload dependencies.
- Experience with public cloud database architecture and implementing database technologies at scale.
- Analytical problem-solving mindset with the ability to identify and resolve issues efficiently while keeping solutions simple.
- Ability to manage multiple initiatives independently and collaborate effectively across cross-functional teams.
- AWS Associate-level certification, CI/CD pipeline experience (Liquibase, Redgate), or familiarity with BI tools such as Qlik Sense/Qlik View are a plus.
- Knowledge of dimensional modeling, data warehouses, data vaults, or machine learning tools is a welcome bonus.
- Competitive Pay & Bonus Opportunities – Rewarding performance and initiative with a strong base salary and performance-based bonuses.
- Comprehensive Benefits – Health, dental, and vision insurance with up to $3,600 (individual) or $6,800 (family) in HSA contributions per year.
- Work-Life Balance – Generous paid time off including 22 days of PTO and 10 paid company holidays.
- Career Growth – Clear promotion paths, mentorship, and ongoing professional development in a high-performing environment.
- Retirement & Security – Up to 6% matching 401(k) contributions on base salary and bonus, plus standard life insurance and disability coverage.
- Continuous Learning – Annual $3,000 reimbursement for educational training and certifications to keep your skills cutting-edge.
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.
Ready to Apply?If you're passionate about data, eager to build solutions that matter, and ready to grow with a company that rewards excellence and collaboration, we want to hear from you. Join Kinsale Insurance and help shape the data infrastructure behind one of the industry's top performers.
Apply today and start building your future with us!
Equal Opportunity EmployerThis employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
Skills Required
- Bachelor's degree in Computer Science, Technology, or related field, or equivalent hands-on experience.
- Advanced SQL knowledge and experience with relational databases, query authoring, and database object creation.
- Strong proficiency in Python for data engineering and automation tasks.
- Proven experience building data transformation processes, managing data structures, and handling workload dependencies.
- Experience with public cloud database architecture and implementing database technologies at scale (cloud databases).
- Analytical problem-solving mindset and ability to identify and resolve issues efficiently.
- Ability to manage multiple initiatives independently and collaborate across cross-functional teams.
- Experience with AWS Associate-level certification, CI/CD pipeline tools (Liquibase, Redgate), or BI tools such as Qlik Sense/QlikView.
- Knowledge of dimensional modeling, data warehouses, data vaults, or machine learning tools.
- Familiarity with Generative AI tools (e.g., Claude Code, ChatGPT) and sound judgment around data sensitivity when using them.
What We Do
Kinsale Insurance is an excess and surplus (E&S) lines insurance company located in Richmond, VA specializing in hard-to-place property, casualty, and specialty risks. Our products are distributed nationwide through appointed surplus lines brokers. We target small-to-midsized accounts and have the flexibility to offer terms for businesses with poor loss histories, high-risk venues, and new or high-hazard operations. Every customer receives high-quality, high-touch customer service and innovative, personalized solutions from us for every account. In each corner of our operation, from underwriting to technology and everything in between, we take ownership of every step of the process by doing as much as possible in-house. Kinsale is focused on creating a team-centered, results-driven work environment that is constantly growing, making progress toward our goals, and reaching new milestones at every checkpoint. Our culture rewards the doers: people who seek new opportunities, take initiative, and challenge the status quo. Our newly constructed building helps improve face-to-face collaboration and allows our employees to work as a team, and we prioritize opportunities to develop those team members and their skillsets. Learn more about Kinsale’s offerings by visiting our website: kinsaleins.com
