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. Our 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 expression, sexual orientation, and many other characteristics bring together varied perspectives and add value to the service we provide our clients, trading partners, and communities. This 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.
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 HR@Ryansg.com
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.