Lead Azure Data Engineer

In-Office, 2 Locations
In-Office

About the Role

At Ryan Specialty in the Advertising/Marketing/Public Relations space, Industry-leading specialty insurance solutions through innovation and collaboration..

Leads Azure data engineering initiatives, designing scalable data pipelines, ETL processes, data architectures, and governance solutions. Manages Azure Data Factory, Databricks, Delta Parquet, Azure Data Lake Storage, Profisee MDM, Azure Purview, SSIS, SSRS, Tableau, and SQL Server optimization. Implements real-time data integration, change data capture, CI/CD, automation, and reporting solutions while ensuring data quality, performance, reliability, and compliance. Provides technical leadership and mentors junior data engineering staff. 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.

Want to learn more about what it's like to work at Ryan Specialty? View our full profile.

Requirements

  • 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
  • Advanced Data Analytics Certifications (ADAC), SAS Statistical Business Analyst Professional Certification (SBAPC), or Cloudera Certified Professional (CCP) Data Engineer a plus.
  • 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

Benefits

  • Comprehensive and best-in-class benefits package
  • Paid time off for company holidays, vacation, sick and personal days
  • Paid parental leave
  • Mental health services
  • Bonuses and benefits
  • Reasonable accommodations for individuals with disabilities

What It's Like to Work at Ryan Specialty

92% love working here
93% trust their manager
93% would recommend
S

Systemic Collaboration

the future is bright! Ryan Specialty is a rapidly growing firm that is a leader in the specialty insurance market. We establish and maintain our position by hiring the best and the brightest and embrace a culture of empowerment, allowing people the freedom to innovate and create.

P

Positive Vision for the Future

our culture is based on our eight foundational values: integrity, client-centricity, teamwork, meritocracy, inclusion, innovation, empowerment and courage. As our employees are our greatest asset, we work hard to maintain a culture that offers each person the ability to self-optimize and to grow.

A

Alignment of Values

leading by example. Our CEO, Pat Ryan, founded Ryan Specialty based on his core principals of treating people fairly, empowering people to enable them to be their very best, and most importantly, to engage with the highest integrity. “Do the right thing because it is the right thing to do.”

R

Respect

making our leadership team available and accessible to all employees. This hands-on leadership style and flat organizational structure ensures that everyone’s voice is heard. We couple the leadership access with a rigorous ethics policy backed by a dedicated DEI team and an ethics hotline.

K

Killer Outcomes

being a part of the team and working towards the same goal. The culture and environment within Ryan Specialty is one of collaboration, teamwork and empowerment. Even remote, we communicate with each other constantly, sharing ideas and best practices and encouraging each other each day.

What It's Like to Work Here

users Collaborative Problem-Solving
lightbulb Freedom to Innovate
trending-up Continuous Learning
handshake Respectful Partnership
target Excellence in Execution

Frequently Asked Questions About Working at Ryan Specialty

Common questions candidates ask about this role and Ryan Specialty's workplace

Ryan Specialty is a rapidly growing service provider of specialty products and solutions for insurance brokers and carriers. Ryan Specialty provides distribution, underwriting, product development, administration, and risk management services by acting as a wholesale broker and a managing underwriter. Our mission is to provide industry-leading innovative specialty insurance solutions for insurance brokers and carriers. (NYSE: RYAN)

Please review the specific job listing or contact Ryan Specialty's recruiting team for details on remote or hybrid work options for this role.

Salary information may vary by role and location. Please check the specific job listing or discuss compensation during the interview process.

Ryan Specialty is an established organization in its industry. The company focuses on maintaining a supportive workplace culture for all employees.

Key benefit categories include: Health & Wellness, Time Off & Family, Retirement & Financial, Professional Development. For this role specifically, benefits include: Comprehensive and best-in-class benefits package, Paid time off for company holidays, vacation, sick and personal days, Paid parental leave, Mental health services, Bonuses and benefits, Reasonable accommodations for individuals with disabilities. You can view more details on their CertCheck profile.

The day-to-day environment is guided by core values such as Collaborative Problem-Solving and Freedom to Innovate and Continuous Learning.

The company has committed to inclusive practices including: Empowerment Through Meritocracy and Investment in Employee Growth.

Ryan Specialty has an employee workplace love score of 92%. They score particularly well in the area of Systemic Collaboration.

Ryan Specialty currently has 9 open positions. You can view all current openings at certcheck.mostlovedworkplace.com/companies/ryan-specialty/jobs.

The interview process typically involves an initial recruiter screen followed by team interviews. Please contact Ryan Specialty's recruiting team for specific details on this role's process.

Apply for Lead Azure Data Engineer

Submit your application directly to the Ryan Specialty team. Let them know why you'd be a strong addition to their team.

Most Loved Workplace® Logo
Powered by Most Loved Workplace®

The global standard for company culture certification and employer of choice visibility.

Learn more about Most Loved Workplace®