Job Description

Posted on:

October 28, 2024

Ryan Specialty is a leading international specialty insurance firm that offers wholesale brokerage services, delegated underwriting expertise, and other services tailored specifically for brokers, agents, and insurers. Our mission is to be the most trusted trading partner for insurance brokers, agents, and carriers. We are seeking a highly skilled and experienced Data Engineering Manager to join our dynamic team. This individual will play a crucial role in administering, optimizing, and innovating our data engineering practices and infrastructure, particularly in an Azure environment, ensuring alignment with the latest technologies and industry best practices focused on performance, reliability, and efficiency.

What will your job entail?

  • Provide technical leadership in data architecture and engineering, collaborating with stakeholders to align data solutions with business objectives.
  • Mentor less experienced data engineers, fostering a collaborative and innovative work environment.
  • Explore and implement new technologies and practices to improve 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 data pipelines using Azure Data Factory, implementing both batch and real-time data integration.
  • Develop and optimize Databricks notebooks for big data processing in Azure Databricks environments.
  • Implement and manage data storage solutions using Delta Parquet files in Azure Data Lake Storage, optimizing for performance and cost.
  • 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.
  • Implement data cataloging, classification, and lineage using Azure Purview, developing governance policies to ensure compliance.
  • Enhance and support Tableau reporting solutions, developing complex dashboards integrated with Azure data services.
  • Drive automation and process optimization using Azure services and scripting, implementing CI/CD pipelines with Azure DevOps.
  • Lead SQL Server database optimization and performance tuning efforts.

Education/Experience/Skills:

  • BA/BS degree in a technical field.
  • Demonstrated technical leadership with experience collaborating with business analysts, data analysts, IT teams, and stakeholders.
  • Experience in implementing innovative data solutions and staying current with data engineering trends.
  • Expertise 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, and data quality governance with Azure Purview.
  • Proven experience in Tableau and BI Reporting, along with strong skills in Automation and Process Optimization.
  • Strong intellectual curiosity and a desire to learn.
  • Critical thinker with an open mind to innovative solutions and high emotional intelligence.
  • Exceptional communication and collaboration skills, with the ability to navigate ambiguity.
  • Highly structured in execution and skilled at simplifying complex environments.

Ryan Specialty is an Equal Opportunity Employer committed to building a diverse workforce. Our vision is an inclusive workplace where all employees are valued for their contributions. We encourage individuals of all backgrounds to apply.

How We Support Our Teammates:

Ryan Specialty offers a comprehensive benefits package that supports employees’ physical, financial, and emotional well-being goals. Benefits include paid time off for holidays, vacations, sick days, parental leave, mental health services, and more. The target salary range for this position is $129,200.00 - $169,575.00 annually, considering various factors such as experience, skills, and market demand. Full-time roles are eligible for bonuses and additional benefits.

We provide reasonable accommodations for individuals with disabilities in accordance with applicable law. Please contact us at HR@Ryansg.com for accommodation requests.

The above describes the general requirements for the position and is not an exhaustive statement of duties or responsibilities. Management reserves the right to assign or reassign duties and responsibilities at any time.

Secret insights

Ryan Specialty is booming with a 20% headcount growth and engineering up 15%—they’re serious about tech talent! HR at 25% shows they value their people. Perfect for AI job seekers.