Who We Are
Chesapeake Employers’ Insurance Company is a purpose-driven organization dedicated to improving the lives and livelihoods of our policyholders, injured workers, team members, and the community. As a leading workers' compensation specialty insurer in the mid-Atlantic region, we take pride in being a force for good. Our 350 team members are committed to making a positive impact every day in the lives of all our stakeholders. Join our motivated, professional team as we foster a culture of values, teamwork, innovation, and collaboration. Established in 1914, Chesapeake Employers Insurance, headquartered in Towson, Maryland, has over a century of experience, a strong financial foundation, and an "A" rating from AM Best.
POSITION SUMMARY:
The Senior Data Engineer at Chesapeake is responsible for leading the design, development, and operationalization of enterprise data pipelines, Lakehouse architectures, and curated data warehouse assets. This role delivers secure, scalable, and high-quality data products using Azure and Databricks to enable analytics, reporting, and data-driven decision-making, including support of Chesapeake’s multi-state growth and expansion initiatives.
Serving as a senior individual contributor and technical leader, the Senior Data Engineer defines and enforces data engineering standards, ensures security and governance best practices, and mentor’s members of the data team on modern Lakehouse patterns and the Medallion Architecture (Bronze, Silver, Gold).
DUTIES AND RESPONSIBILITIES:
- Owns the technical design and long-term evolution of enterprise data pipelines, lakehouse architecture, and curated data warehouse structures supporting analytics and reporting across the organization.
- Leads architectural decision-making for Azure Data Factory, Azure Databricks, Delta Lake, and Azure Data Lake Storage, ensuring solutions are scalable, secure, and aligned with business growth and multi-state operational requirements.
- Defines, governs, and continuously improves Medallion data pattern, including standards for data ingestion, transformation, modeling, and data quality enforcement.
- Serves as the final technical authority for SQL-based transformations, dimensional data models, and data pipeline design, conducting design reviews and approving production changes.
- Owns production data reliability, including monitoring strategy, alerting standards, and incident response; leads root cause analysis and remediation for recurring or high-impact data issues.
- Establishes and enforces engineering standards for version control, CI/CD pipelines, testing, documentation, and release management across the data engineering function.
- Implements and oversees data security controls, including role-based access control (RBAC), encryption, and secure data handling practices, in partnership with security, infrastructure, and compliance teams.
- Designs and governs secure data access patterns for Power BI semantic models and downstream data consumers, ensuring consistent, role-appropriate access to trusted datasets.
- Provides technical mentorship and coaching to data engineers and analytics team members, raising overall team capability through design guidance, code reviews, and knowledge sharing.
- Partners with business leaders, product owners, and analytics stakeholders to translate strategic objectives into scalable data solutions and prioritized engineering initiatives.
- Balances strategic platform initiatives with operational responsibilities, ensuring day-to-day pipeline stability while advancing the organization’s long-term data architecture.
- Documents and communicate architectural decisions, reusable patterns, and best practices, ensuring clarity, consistency, and continuity across the data ecosystem.
- Implements data security best practices in pipelines, including encryption, secure credentials management, and adherence to company data standards.
- Contributes to the achievement of established department goals and objectives; adheres to departmental policies, procedures, quality, and safety standards, and consistently exhibits Chesapeake’s Values and Behaviors.
- Performs other duties as assigned.
SKILLS, EDUCATION AND EXPERIENCE:
- Bachelor’s degree in a related technical field or equivalent experience.
- 5+ years of experience in data engineering or data warehousing roles.
- Expert SQL skills and dimensional data modeling experience.
- Advanced experience with Azure Databricks, Delta Lake, and Azure Data Lake Storage.
- Awareness of data security principles and compliance requirements (e.g., encryption, RBAC, secure data handling).
- 1-2 years experience using Python for data transformations.
- Strong background in cloud security, data access controls, and encryption.
- Experience supporting Power BI and enterprise analytics platforms.
- Proficiency with Git, CI/CD, and automated deployment pipelines.
- Strong analytical, troubleshooting, and communication skills.
POSITIONAL COMPETENCIES:
- Bias for Action
- Knowledge Sharing
- Deliver Results
- Service and Sales Excellence
- Personal Leadership
- Teamwork and Communication
PHYSICAL DEMANDS:
While performing the duties of this job, the teammate is regularly required to sit, use hands to finger, handle or feel objects, tools or controls; reach with hands and arms. The teammate is occasionally required to stand, walk, stoop, kneel, crouch or crawl. The teammate may occasionally lift up to 30 pounds. Specific vision abilities are required, which includes close vision, peripheral vision and the ability to adjust focus.
WORK ENVIRONMENT:
Office Environment. The noise level is usually moderate.
What We Offer
We offer a competitive benefits package that includes health, vision, and dental coverage, a robust PTO plan, an 8% employer contribution to retirement regardless of team member contribution, educational assistance, and opportunities to participate in team member appreciation events. Additionally, we provide STD, LTD and group life insurance 1X a team members salary. You'll also enjoy free tickets to community attractions, all part of our commitment to providing a high quality of work life. You will have the flexibility to thrive in a hybrid work environment and an opportunity to participate in development and volunteer programs.
