Senior Database Engineer

About Auris

Auris is the payroll and HR partner built for small and medium-sized businesses whocantafford to get it wrong. Trusted by over 50000 businesses nationwide Auris pairs easy-to-use technology with real human services to give leaders the confidence that every detail is done right so they can focus on growing their team and their business.Acquiredby Acrisure in 2025 Auris formerly Heartland Payroll is accelerating its vision to deliver seamless human-centered technology to help small businesses thrive.

Summary of This Role

The Lead Data Engineer is a senior individual contributor (IC) on the Auris Data Engineering team serving as the technical anchor for the teams database and pipeline platform. This roleis responsible fordesigning building andoptimizingdata solutions across Oracle Azure SQL and Snowflakewhile also providing backup Oracle DBA coverage. The ideal candidate brings hands-onexpertisein SQL engineering ELT pipeline development anddbt with the ability to lead through technical excellence mentor peers and deliver reliable high-quality data products that power Auriss payroll and HR platform.

WhatYoullDo

SQL Development & Database Engineering

• Design develop and optimize complex SQL queries stored procedures functions triggers and views across Oracle (PL/SQL) Azure SQL (T-SQL) and Snowflake SQL.

• Conduct query performance analysis and tuning using execution plans indexing strategies partitioning and statistics management.

• Establish and enforce SQL coding standards naming conventions and code-review processes across the team.

ELT Pipeline Development &dbt

• Architect and develop ELT pipelines that ingest transform and serve data across Oracle Azure SQL and Snowflake.

• Buildmaintain and governdbtmodels (sources staging intermediate mart layers) following modular tested and documented design principles.

• Implementdbtschema tests and custom data quality tests to embed data quality gates into every pipeline.

• Collaborate with Analytics and Data Engineering teams to translate business logic intoreliable version-controlled transformation code.

• Leverage orchestration tools (Azure Data Factory or equivalent) to schedule andmonitorpipeline execution.

Snowflake & Azure SQL Platform Engineering

• Design and manage Snowflake objects: databases schemas virtual warehouses stages streams tasks and dynamic tables.

• Implement Snowflake performance best practices including clustering keys materialized views result cache and warehouse right-sizing.

• Develop andmaintainAzure SQL databases; tune workloads using Query Store and Intelligent Query Processing.

• Support Snowflake and Azure SQL security configurations including RBAC TDE Row-Level Security and Dynamic Data Masking.

Oracle Database Administration (Backup DBA)

• Serve as backup Oracle DBA for production and lower environments (Oracle 19c/21c).

• Perform DBA tasks: tablespace management RMAN backup & recovery patching coordination and AWR/ASH performance analysis.

• Diagnose Oracle performance issues using SQL Tuning Advisor execution plans and SQL Monitor.

• Support Oracle-to-cloud migration efforts including schema conversion and data validation.

Technical Leadership & Collaboration

• Act astechnicallead and SME for SQL development and database engineering across project teams.

• Mentor junior and mid-level engineers through code reviews pairing sessions and documentation.

• Contribute to CI/CD integration of database changes using tools such asdbtCloud Flyway or GitHub Actions.

• Participate in sprint planning architecture reviews and cross-functional data initiatives.

What Are We Looking for in this Role

Qualifications

• 7 years of hands-on SQL development experience in a professional data engineering or database engineering role.

• 5 years of Oracle database experience including PL/SQL development and DBA-level operational tasks (backups recovery performance tuning).

• 3 years of Snowflake experience including data modeling performance optimization and Snowflake-native features (Streams TasksSnowpipe Dynamic Tables).

• 3 years of Azure SQL Database or SQL Server experience in cloud or on-premises environments.

• 3 years ofdbt(data build tool) experiencedbtCore ordbtCloudbuilding andmaintainingproduction-grade transformation models.

• Experience building and operating ELT/ETL pipelines in a modern cloud data stack.

• Familiarity with version control (Git / Azure DevOps) and CI/CD pipelines for database deployments.

• Working knowledge of Python or shell scripting for pipeline automation and tooling.

What are our Desired Skills and Capabilities

• Advanced SQLproficiencyacross Oracle PL/SQL T-SQL (Azure SQL / SQL Server) and Snowflake SQL.

• Strong understanding of ELT architecture patterns data warehouse design and dimensional modeling (star/snowflake schema).

• Proficiencywithdbt: model design ref/source resolution Jinja macros incremental strategies anddbtdocs.

• Experience with data orchestration platforms such as Azure Data Factory (ADF) or Apache Airflow.

• Understanding ofdata governance data quality frameworks and observability practices (e.g. Great Expectations Monte Carlodbttests).

• Oracle Certified Professional (OCP) or SnowflakeSnowProCore / Advanced: Data Engineer certification is a plus.

• Microsoft Certified: Azure Data Engineer Associate or Azure Database Administrator Associate is a plus.

• Experience in payroll HR technology financial services orInsurTechdomain preferred.

• Prior experience contributing to Oracle-to-cloud migration projects is a plus.

What we offer

• Competitive compensation and performance incentives.

• Comprehensive benefits package.

• Collaborative mission-driven culture with high visibility and impact.