Data Engineer

Kinsale Management • Richmond, VA

8d • Onsite

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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

Benefits

• Competitive Pay & Bonus Opportunities
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level