Data Engineer

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 Role

As 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.

What You Bring

• 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.

Why You'll Love Working at Kinsale

• 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.

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.

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!