Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via email$ 116000 - 145000
1 Vacancy
Position Summary
Ryan Specialty is a leading international specialty insurance firm which offers wholesale brokerage services; delegated underwriting expertise in the form of binding authorities programs and highly specialized managing general underwriting companies; and other services designed specifically for brokers agents and insurers. Ryan Specialtys mission is to be the most trusted trading partner of insurance brokers agents and insurance carriers. We are seeking a highly skilled and experienced Lead Data Engineer to join our dynamic team. This individual will be instrumental in administering optimizing and innovating our data engineering practices and infrastructure particularly in an Azure environment (YAML). This person 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
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 realtime 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 costefficiency.
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 realtime data synchronization in Azure data platforms.
Enhance and support Power BI 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 (YAML).
Lead SQL Server database optimization and performance tuning efforts.
Education/Experience/Skills
BA/BS degree in a technical field.
Demonstrated technical leadership and experience in collaborating with business analysts data analysts IT teams and other stakeholders.
Experience in implementing innovative data solutions and staying abreast of the latest trends in data engineering.
Expertise in SQL Server Management Azure Data Factory Development Databricks Engineering Delta Parquet File Management and SQL Server Integration Services.
YAML
Proficiency in Profisee MDM Integration Change Data Capture implementation and data quality and governance.
Proven experience in with BI Reporting and strong skills in Automation and Process Optimization.
Intellectual curiosity with a strong drive to learn
Critical thinker with an open mind to innovative solutions
High emotional intelligence
Exceptional communication skills
Strong collaboration and relationship building skills
Ability to navigate ambiguity
Highly structured in
Skilled at simplifying complex environments
*Ryan Specialty does not offer work visa sponsorship
Ryan Specialty is an Equal Opportunity Employer. We are committed to building and sustaining a diverse workforce throughout the vision 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 expressionsexual orientation and many other characteristics bring together varied perspectives and add value to the service we provide our clients trading partnersand policy 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.
Ryan Specialty seeks to offer our employees a comprehensive and bestinclass benefits package that helps them and their family members achieve their physical financial and emotional wellbeing 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 $116000.00 $145000.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. Fulltime roles are eligible for bonuses and benefits. For additional information on Ryan Specialty Total Rewards visit our website 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
The above is intended to describe this jobs general requirements. It is not to be construed as an exhaustive statement of duties responsibilities or physical requirements. Nothing in this job description restricts managements 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.
Full-Time