Senior Data Engineer

Hylant; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

Hylant is seeking a Data Engineer to build and operationalize the company’s enterprise data architecture on Databricks and Azure. You will translate designs into reliable pipelines and datasets, working with the Lead Data Architect to align with governance standards.

You will design ETL/ELT pipelines, create analytics-ready data layers, implement Unity Catalog security, and own CI/CD for data platforms while collaborating with source system owners and downstream consumers across the organization.

Qualifications

• Bachelor’s degree or equivalent practical experience in CS/engineering/data science or related field
• 5–7+ years of experience as a Data Engineer designing, implementing, and validating production-grade data pipelines
• Hands-on experience with Azure Databricks, Azure Data Factory, Delta Lake, Unity Catalog and core Azure cloud services
• Strong proficiency in SQL and PySpark for data transformation and pipeline development
• Experience implementing data quality checks, reconciliations, and validation processes in complex data environments
• Experience owning or contributing to CI/CD pipelines for data platforms (Azure DevOps Pipelines preferred)
• Ability to troubleshoot and resolve complex data, pipeline, and performance issues
• Insurance industry experience is a plus but not required; exposure to Power BI is a plus
• Must be legally authorized to work in the United States

Responsibilities

• Design, build, and maintain data transformation logic, business rules, and analytics-ready datasets using Databricks notebooks, PySpark, and SQL
• Develop, orchestrate, and monitor ETL/ELT pipelines using Azure Databricks and Azure Data Factory
• Create target schemas, curated tables, and analytics-ready data layers aligned to architectural designs
• Enforce data governance, security, and access controls within Unity Catalog
• Conduct data profiling, validation, reconciliation, and testing to ensure data quality
• Serve curated datasets through Databricks SQL and Power BI datasets for reporting
• Own the CI/CD process for Databricks and Azure Data Factory using Azure DevOps Pipelines
• Monitor and optimize the data platform for performance and cost
• Participate in agile delivery as part of the Data & Digital Solutions team

Skills

Communication

Collaboration

Problem-solving

Attention to detail

Education

Bachelor’s degree in CS/Engineering/Data Science

Tools

Azure Databricks

Azure Data Factory

Delta Lake

Unity Catalog

SQL

PySpark

Power BI

Azure DevOps Pipelines

Job description

The Opportunity:The Data Engineer will build, integrate, and operationalize the company’s enterprise data architecture on our Databricks and Azure platform. This role translates architectural designs and analytical requirements into reliable, scalable data pipelines and business-ready datasets. Working closely with the Lead Data Architect, the position ensures data solutions align to defined standards, patterns, and governance requirements.

In This Role You Will Execute On:

• Design, build, and maintain data transformation logic, business rules, and analytics-ready datasets using Databricks notebooks, PySpark, and SQL.
• Develop, orchestrate, and monitor ETL/ELT pipelines using Azure Databricks and Azure Data Factory, including scheduling, dependency management, and job performance tuning.
• Create target schemas, curated tables, and analytics-ready data layers aligned to architectural designs and business requirements, including source-to-target mapping, historical data loads, and backfills for new data domains.
• Implement and enforce data governance, security, and access controls within Unity Catalog — including group-based grants, attribute-based access policies, and row- and column-level security — in accordance with standards defined by the Data Architecture team.
• Conduct data profiling, validation, reconciliation, and system integration testing to ensure end-to-end data quality, accuracy, and reliability; partner with source system owners and downstream consumers to investigate and resolve discrepancies.
• Serve curated, trusted datasets through Databricks SQL and Power BI datasets to support operational, financial, and analytical reporting.
• Own the CI/CD process for Databricks and Azure Data Factory using Azure DevOps Pipelines.
• Monitor, tune, and optimize the data platform for performance and cost, including cluster sizing, autoscaling, and job execution efficiency.
• Participate in agile delivery as part of the Data & Digital Solutions team, including sprint planning, backlog refinement, and delivery commitments.

In This Role You Will Need:

• Bachelor’s degree in computer science, engineering, data science, or a related field, or equivalent practical experience (desired).
• 5–7+ years of experience as a Data Engineer, including designing, implementing, and validating production-grade data pipelines.
• Hands-on experience with Azure Databricks, Azure Data Factory, Delta Lake, Unity Catalog, and core Azure cloud services.
• Strong proficiency in SQL and PySpark for data transformation and pipeline development.
• Experience implementing data quality checks, reconciliations, and validation processes in complex data environments.
• Experience owning or contributing to CI/CD pipelines for data platforms (Azure DevOps Pipelines preferred).
• Ability to troubleshoot and resolve complex data, pipeline, and performance issues.
• Strong collaboration and communication skills, with the ability to bridge technical and non-technical stakeholders.
• Insurance industry experience (brokerage, policy administration, claims, billing, underwriting, or risk data) preferred but not required.
• Exposure to applying AI or automation within data engineering workflows a plus.
• Exposure to PowerBI is a plus.
• Must be legally authorized to work in the United States.

The Environment:

• This is a fully remote position, open to candidates located within the United States.
• Periodic in-person attendance may be required for team meetings, onsite collaboration, or other business-related functions; reasonable advance notice will be provided.
• Work is generally performed in a home office or standard office environment with limited exposure to physical risk or physical effort required.
• Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

Why the company?Since 1935, the company has been a family‑owned insurance brokerage built on relationships, trust, and a people‑first mindset. We believe great work is rooted in understanding people — our clients, our communities, and each other — and delivering thoughtful solutions that rise above the expected.

Anything But Typical. Everything for You. isn’t just a message; it’s how we show up. It reflects a culture where people come first, careers are supported with purpose, and going above and beyond is the standard, not the exception. At the company, you’re more than an employee, you’re part of a team that treats one another like family and works together to make a meaningful impact.