2,378,882open jobs
148,527companies
282,832added this week
Browse all
Salary
$140k – $175k per year
Location
In office (Chicago, United States)
Seniority
Staff · 12+ years exp
Visa
No sponsorship (stated in the posting)
Employment
Full-Time

Confirmed on the employer's own hiring board on Nov 19, 2026. First seen by Alion on Nov 18, 2026. Ryan Specialty scores B on the Alion truth index.

Overview
Company
Impact
Profile match
Ryan Specialty is a specialty insurance services firm headquartered in Chicago that serves retail insurance brokers, agents and carriers. Founded in 2010 by Patrick G. Ryan, the founder of Aon, it operates through wholesale brokerage arm RT Specialty, binding authority and underwriting management businesses, with offices across the US as well as London and other international sites. It hires underwriters, brokers, claims managers, binding and billing specialists, catastrophe modeling and finance staff, and DevOps and site reliability engineers.
Backed by Abry Partners

Position Summary

The Lead Azure Data Engineer will be reporting to VP of Data Engineering and will be responsible for implementing data solutions and collaborating with Business Analyst, Data Analyst, IT Teams and key stake holders. This role will lead projects and coach junior staff on build and optimize data pipelines, integrating data from various sources, ETL (Extract, Transform, Load) processes and ensuring data quality and consistency. The Lead will ensure that our data engineering practices are aligned with the latest technologies and industry best practices, focusing on performance, reliability, and efficiency.

What will your job entail?

Job Responsibilities:

  • Provide technical leadership in data architecture and engineering, collaborating with solution stakeholders to align data solutions with business objectives.
  • Mentor less experienced data engineers and team members, fostering a collaborative and innovative work environment.
  • Explore and implement new technologies and practices in data engineering to continually improve our data processes and infrastructure.
  • Manage and enhance complex SSIS packages for data integration and ETL processes, along with SSRS reports for business intelligence.
  • Design, build, and maintain scalable and efficient data pipelines using Azure Data Factory, implementing both batch and real-time data integration processes.
  • Develop and optimize Databricks notebooks for big data processing and analytics in Azure Databricks environments.
  • Implement and manage data storage solutions using Delta Parquet files in Azure Data Lake Storage, optimizing for query performance and cost-efficiency.
  • Integrate and configure Profisee Master Data Management tools within Azure, focusing on data governance and quality.
  • Set up and manage Change Data Capture processes for real-time data synchronization in Azure data platforms.
  • Implement data cataloging, classification, and lineage using Azure Purview, developing data governance policies, and ensuring compliance.
  • Enhance and support Tableau reporting solutions, developing complex dashboards, and integrating with Azure data services.
  • Drive automation and process optimization using Azure services and scripting and implement CI/CD pipelines using Azure DevOps.
  • Lead SQL Server database optimization and performance tuning efforts.
  • Lead, Coach and Mentor junior staff on projects. Work Experience and Education:
  • Bachelor’s degree required, Master’s degree preferred; Computer science, Information Technology or Engineering is preferred. Any other related discipline or commensurate work experience considered.
  • 12+ years of experience in Data Engineering with a Bachelor’s degree, or 8 years of experience with a Master’s degree is preferred.
  • Subject Matter Expert in SQL Server Management, Azure Data Factory Development, Databricks Engineering, Delta Parquet File Management, and SQL Server Integration Services.
  • Proficiency in Profisee MDM Integration, Change Data Capture implementation, and data quality and governance with Azure Purview.
  • Proven experience in Tableau and BI Reporting, and strong skills in Automation and Process Licenses & Certifications:
  • Advanced Data Analytics Certifications (ADAC), SAS Statistical Business Analyst Professional Certification (SBAPC), or Cloudera Certified Professional (CCP) Data Engineer a plus. Skills: Technical/Functional Skills:
  • Big Data Analytics
  • Leadership
  • Data Governance
  • Data Modeling
  • Data Processing
  • Data Warehousing
  • Database Management
  • Knowledge of ETL processes
  • Machine Learning
  • Predictive Analysis
  • Programming Languages Behavioral Skills:
  • Critical Thinker
  • Communication
  • Relationship Building
  • Effective Communication
  • Time Management
  • Problem Solving
  • Attention to Detail

*****Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time*****

Ryan Specialty is an Equal Opportunity Employer. We are committed to building and sustaining a diverse workforce throughout the organization. Ourvision is an inclusive and equitable workplace where all employees are valued for and evaluated on their performance and contributions. Differences in race, creed, color, religious beliefs, physical or mental capabilities, gender identity or expression, sexualorientation, and many other characteristics bring together varied perspectives and add value to the service we provide our clients, trading partners, and communities. Thispolicy extends to all aspects of our employment practices, including but not limited to, recruiting, hiring, discipline, firing, promoting, transferring, compensation, benefits, training, leaves of absence, and other terms, conditions, and benefits of employment.

How We Support Our Teammates

Ryan Specialty seeks to offer our employees a comprehensive and best-in-class benefits package that helps them - and their family members - achieve their physical, financial, and emotional well-being goals. In addition to paid time off for company holidays, vacation, sick and personal days, Ryan offers paid parental leave, mental health services and more.

The target salary range for this position is $140,000.00 - $175,000.00 annually.

The wage range for this role considers many factors, such as training, transferable skills, work experience, licensure and certification, business needs, and market demands. The pay range is subject to change and may be modified in the future. Full-time roles are eligible for bonuses and benefits. For additional information on Ryan Specialty Total Rewards, visit our website https://benefits.ryansg.com/.

We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation at [email protected]

The above is intended to describe this job's general requirements. It is not to be construed as an exhaustive statement of duties, responsibilities, or physical requirements. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,378,882 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Data Science
Remote, many countries
Similar stack
Same company
Chicago
Hybrid · Full-Time · 10+ years exp · PhD · United States
Python
SQL
PowerShell
Databases
Microsoft Fabric
AI/ML
Machine Learning
DevOps
GitHub Actions
CI/CD
AWS
GitHub
Cybersecurity
LDAP
Analytics
Power BI
Apply
$323k – $374k per year · Equity · Hybrid · Bachelor's Degree · San Mateo
Python
SQL
AI/ML
LLM Guardrails
Machine Learning
Analytics
A/B Testing
Apply
$120k per year · In office · Full-Time · United States
SQL
Scala
Databases
PostgreSQL
DevOps
AWS
Docker
Kubernetes
Amazon EKS
AWS Lambda
Amazon EC2
Amazon S3
IAM
Analytics
ETL/ELT
Apply
In office · 10+ years exp · Whitehouse Station
Python
SQL
PowerShell
Databases
Snowflake
Analytics
Power BI
Management
Power Automate
Apply
In office · 12+ years exp · Bachelor's Degree · Nashville
Python
Java
SQL
Scala
Databases
Snowflake
Databricks
Delta Lake
Apache Kafka
Microsoft Fabric
AI/ML
Spark
AI Agents
RAG
Machine Learning
DevOps
Azure
CI/CD
Platform Engineering
Apply
Data Scientist 1 day ago
Remote (EAEU) · 5+ years exp · Saint Petersburg
Python
SQL
Python
pySpark
AI/ML
Hadoop
CatBoost
Spark
XGBoost
Scikit-learn
LightGBM
Pandas
NumPy
Apply
Remote (EMEA) · Contractor · Cape Town
SQL
DevOps
Rest API
Apply
$90k – $110k per year · In office · Full-Time · Bachelor's Degree · New York · Chicago
DevOps
Wi-Fi
Apply
$46k per year · In office · Chicago
Apply
$56k – $89k per year · Equity · In office · Full-Time · Chicago
Apply
Maintenance Manager 9 hours ago
In office · 5+ years exp · Chicago
Chips/EDA
Statistical Process Control
Apply
In office · 2+ years exp · High School Diploma · Chicago
Apply
See all jobs
This is one of many
2,378,882 more open roles from verified company boards, updated every day.