Lead Database Analyst

Work Arrangement: Preference is for the successful candidate to report to one of the three offices listed below; however, a fully remote arrangement is also an option.

Ohio (Ontario), Florida (Palm Beach Gardens), or New Jersey (Bridgeton)

Cumberland Mutual is seeking a hands-on Lead Database Analyst to architect, optimize, and support enterprise database and cloud data platforms. This senior-level role provides technical leadership across SQL Server and Snowflake environments, driving scalable design, performance engineering, and modern data governance practices. This is a hands-on, individual-contributor role - not a people-management position - for someone who wants to drive technical direction through hands-on work rather than managing a team.

With a lean data team, this role combines architecture, engineering, operational support, and governance. This position is ideal for a technically strong database professional who thrives in production-critical environments and wants to influence enterprise data strategy in a growing, cloud-forward organization.

What You'll Do

• Snowflake & Cloud Data Platform (Required)
• Design and administer Snowflake data warehouse architecture
• Build and optimize ELT pipelines within Snowflake
• Configure virtual warehouses and implement compute/cost optimization strategies
• Manage advanced Snowflake features (time travel, cloning, zero-copy cloning, micro-partitioning, clustering)
• Implement Snowflake governance controls including RBAC, data masking, and secure data sharing
• Monitor usage, storage, and performance metrics to ensure efficiency and reliability
• Enterprise Database Engineering
• Architect, develop, and maintain SQL Server databases across production, UAT, and test environments
• Design and optimize relational and dimensional data models
• Lead advanced performance tuning (index strategy, execution plans, partitioning)
• Implement high availability, backup/recovery, and disaster recovery solutions
• Establish and enforce database standards, governance controls, and security best practices
• Production & Operational Support
• Provide on-call support for critical data processes
• Troubleshoot production issues and perform root cause analysis
• Maintain data integrity, reliability, and operational controls
• Partner with infrastructure teams on upgrades, patches, and cloud enhancements
• Leadership & Collaboration
• Serve as SME for database architecture and Snowflake best practices
• Guide developers on SQL optimization and database design
• Review code and recommend performance and security improvements
• Translate business requirements into scalable technical data solutions
• Partner with stakeholders to define KPI data structures and reporting frameworks

• 7+ years of hands-on database development and administration experience
• 3+ years of production Snowflake experience
• Advanced SQL development and query optimization expertise
• Strong background in data warehousing and ETL/ELT architecture
• Experience with Azure and/or AWS cloud environments

Preferred:

• Property & Casualty insurance industry experience
• Duck Creek platform knowledge
• Experience supporting BI/reporting platforms (e.g., Tableau, SSRS)
• DevOps/CI-CD experience for database deployments

What Sets You Apart

• Deep understanding of database internals and performance engineering
• Strong architectural mindset with hands-on execution ability
• Comfortable using AI-assisted development tools, with the judgement to critically evaluate and verify their output
• Ability to communicate complex technical concepts to non-technical stakeholders
• Proactive, detail-oriented, and solutions-driven

Pulled from the full job description 401(k) 4% Match 401(k) 401(k) matching, * 35-hour workweek

• Competitive compensation package
• Immediate enrollment in Cumberland Mutual's 401(k) plan with a 4% company match
• High autonomy and ownership in a lean data team
• Opportunity to shape and modernize Cumberland's data strategy
• Collaborative environment with direct business engagement
• Stable organization with long-term growth vision