Data / Datawarehousing / AI Engineer - Azure, Remote - Azure

We are looking for a hybrid data and development engineer to own our data warehouse and Azure cloud infrastructure while building the next generation of internal tools using AI-assisted development practices. This role sits at the center of how we turn raw operational data from our agency management systems, carrier feeds, and finance platforms into trusted, well-governed information that powers reporting, dashboards, and emerging internal applications across the brokerage.

The role also administers a portion of our Azure subscription (the cloud foundation for our internal operating and AI platforms) and leads the retirement of the legacy systems those platforms replace. The ideal candidate is equally comfortable administering a SQL Server data warehouse and using modern AI coding assistants to design, build, and ship production-grade internal applications faster than traditional development allows. This is not an AI or machine-learning research role, it is a software engineering and data infrastructure role for someone who has made AI-assisted coding a core part of how they build software.

What you will be doing:

• Own the health, performance, and security of 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 our governing technology policies including security, change management, access provisioning, and architecture standards across all warehouse, cloud, and application work.
• 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 our 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 our 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 overall development speed and quality.
• Build and maintain integrations between the data warehouse and internal business applications.
• Work within our data handling, security, and compliance guardrails when building anything that touches production, sensitive, or regulated data.

• 6+ yrs 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

• Paid Vacation
• Paid Sick Leave
• Bonus
• Remote Opportunity
• Cigna or Kaiser Medical Benefits
• Delta Dental
• VSP, $120000 - $180000 USD per year