Lead Azure Data Engineer
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
Prefer to apply on the company's career site?
View Original PostingWhat It's Like to Work at Ryan Specialty
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.
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.
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.”
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.
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
Frequently Asked Questions About Working at Ryan Specialty
Common questions candidates ask about this role and Ryan Specialty's workplace
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.


