Data Platform & Cloud Engineer, AI- Enabled Developer

The Liberty Company is a forward-thinking, rapidly growing insurance brokerage focused on culture, collaboration, and employee development. The Data Platform & Cloud Engineer, AI-Enabled Developer will manage the company’s SQL Server data warehouse and Azure cloud infrastructure while building internal applications and automations using AI-assisted development practices. The role also oversees data pipelines, integrations, governance, cloud platforms, and legacy-system decommissioning.

Responsibilities:

• Own the health, performance, and security of Liberty’s SQL Server / Azure SQL data warehouse infrastructure, including production and reporting databases
• Administer, monitor, and tune database environments: indexing, query performance, backup and recovery, capacity planning, and patching
• Build, maintain, and monitor the ETL/ELT pipelines that pull data from source systems — agency management systems, carrier and finance platforms, HR/payroll, and other line-of-business tools — into the warehouse
• Design and maintain data normalization, transformation, and modeling logic so downstream reporting and BI tools work from a single, consistent source of truth
• Manage schema changes, data quality checks, and job orchestration/scheduling for recurring data loads; troubleshoot and resolve pipeline failures and data discrepancies
• Define and enforce data access controls, retention practices, and documentation standards for the warehouse, in coordination with IT and compliance
• Collaborate with IT Department team members and conform to Liberty's governing technology policies — including security, change management, access provisioning, and architecture standards — across all warehouse, cloud, and application work. This role carries a dotted-line reporting relationship to Technology Operations
• Partner with the BI/Analytics team to expose clean, well-modeled data sets to existing and future consumption layers, including dashboards, internal applications, and APIs
• Administer responsible portions of Liberty's Microsoft Azure subscription: resource and subscription organization, role-based access control through Entra ID, cost management and budget monitoring, tagging and naming standards, and platform-level security configuration
• Own the Azure infrastructure supporting Liberty OS and Liberty Aura — provisioning, configuration, monitoring, patching, and capacity planning for the app services, databases, key vaults, and supporting resources those platforms depend on
• Lead the decommissioning of legacy systems and databases: plan and execute data migration and archival, confirm records-retention obligations are satisfied before shutdown, retire orphaned Azure resources, and document what was retired and where the data now lives
• Design, build, and maintain internal software applications and automations using AI-assisted development tools and coding agents as a primary part of the development workflow
• Translate business and operational needs from BI, Operations, and other Liberty teams into working internal tools, integrations, and automations
• Apply sound software engineering practice — code review, version control, testing, and documentation — to everything shipped, regardless of how much of it was AI-assisted
• Evaluate and responsibly adopt new AI coding tools and workflows, and share practices that raise the team’s overall development speed and quality
• Build and maintain integrations between the data warehouse and internal business applications
• Work within Liberty’s data handling, security, and compliance guardrails when building anything that touches production, sensitive, or regulated data

Requirements:

• 6+ years of experience administering SQL Server or a comparable relational database platform in a production environment
• Hands-on experience building and maintaining ETL/ELT pipelines and data warehouse or data mart architectures
• Hands-on experience administering a Microsoft Azure subscription: resource and subscription organization, role-based access control (Entra ID), cost management, and platform security configuration
• Strong SQL skills, including query optimization, indexing strategy, and performance troubleshooting
• Practical experience building software using modern AI coding assistants or agents (for example, Claude Code, GitHub Copilot, or Cursor) as part of a real development workflow, not just casual use
• Working proficiency in at least one modern programming language (for example, Python, C#, or JavaScript/TypeScript) for building internal tools and automations
• Familiarity with version control (Git) and standard software development lifecycle practices
• Strong troubleshooting skills and comfort owning a system end to end, from data ingestion through the reports and applications built on top of it
• Experience migrating off and decommissioning legacy systems or databases, including data migration, archival, and retention-compliant shutdown
• Clear written and verbal communication skills, with the ability to explain technical tradeoffs to non-technical stakeholders
• Experience with Azure SQL Managed Instance or another cloud data platform
• Experience with infrastructure-as-code (Bicep, ARM, or Terraform) and Azure cost management or FinOps practices
• Experience with Tableau or another modern BI/reporting tool, as a data publisher or consumer
• Experience in insurance, brokerage, or financial services, or with agency management systems such as Applied Epic or AMS360
• Experience building or integrating with MCP (Model Context Protocol) servers or similar agentic/AI tool-calling architectures
• Exposure to data governance or regulatory compliance requirements relevant to insurance and financial data
• Experience mentoring other developers on AI-assisted development practices