Ryan Specialty
Data Engineer
Ryan Specialty, Chicago, Illinois, United States, 60290
Position Summary
The Data Engineer is responsible for designing, building, and maintaining data pipelines, models, ETL (Extract, Transform, Load) processes and other data infrastructure to support the organization's data needs. The role collaborates with data scientists and analysts to understand data requirements and develops scalable solutions. They build and optimize data pipelines, integrating data from various sources, ensuring data quality and consistency, and implement data governance practices.
What will your job entail?ResponsibilitiesDesigns, builds, and maintains scalable data pipelines to ingest, process, and transform data from various internal and external sources.Develops and maintains data warehouses or data lakes to store structured and unstructured data efficiently, ensuring data accessibility and reliability for analytics and reporting purposes.Integrates data from disparate systems sources, ensuring consistency, accuracy, and reliability of data across different platforms and applications within the organization.Conducts data modeling and database design, using cloud-based technologies and conducts dimensional modeling for data warehouses and data marts.Optimizes data processing and query performance to ensure timely and efficient data retrieval and analysis, utilizing techniques such as indexing, partitioning, and query optimization.Manages and maintains data infrastructure components such as databases, data warehouses, and cloud-based services, ensuring high availability, scalability, and performance.Implements data governance policies and procedures to ensure compliance with regulatory requirements and data security measures to protect sensitive information.Implements data quality checks and processes to identify and rectify data anomalies, inconsistencies, and errors, and ensures data integrity for downstream analytics and reporting.Participates in cross-functional teams to develop innovative data-driven solutions that improve operational efficiency, risk assessment, and customer experience in the insurance industry.Partners with data analysts, data scientists, and data consumers across IT and the business to optimize data availability and builds, refines, and enhances AI/ML models and algorithms.Stays up to date with new technologies and industry trends in data management and big data technologies.EducationBachelor’s degree in Computer Science, Information Technology or Engineering is required. Master’s degree preferred.Licenses & CertificationsPrescribed: Not ApplicablePreferred: Advanced Data Analytics Certifications (ADAC), SAS Statistical Business Analyst Professional Certification (SBAPC), Cloudera Certified Professional (CCP) Data EngineerHow We Support Our TeammatesRyan 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 $89,200.00 - $117,075.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.
#J-18808-Ljbffr
The Data Engineer is responsible for designing, building, and maintaining data pipelines, models, ETL (Extract, Transform, Load) processes and other data infrastructure to support the organization's data needs. The role collaborates with data scientists and analysts to understand data requirements and develops scalable solutions. They build and optimize data pipelines, integrating data from various sources, ensuring data quality and consistency, and implement data governance practices.
What will your job entail?ResponsibilitiesDesigns, builds, and maintains scalable data pipelines to ingest, process, and transform data from various internal and external sources.Develops and maintains data warehouses or data lakes to store structured and unstructured data efficiently, ensuring data accessibility and reliability for analytics and reporting purposes.Integrates data from disparate systems sources, ensuring consistency, accuracy, and reliability of data across different platforms and applications within the organization.Conducts data modeling and database design, using cloud-based technologies and conducts dimensional modeling for data warehouses and data marts.Optimizes data processing and query performance to ensure timely and efficient data retrieval and analysis, utilizing techniques such as indexing, partitioning, and query optimization.Manages and maintains data infrastructure components such as databases, data warehouses, and cloud-based services, ensuring high availability, scalability, and performance.Implements data governance policies and procedures to ensure compliance with regulatory requirements and data security measures to protect sensitive information.Implements data quality checks and processes to identify and rectify data anomalies, inconsistencies, and errors, and ensures data integrity for downstream analytics and reporting.Participates in cross-functional teams to develop innovative data-driven solutions that improve operational efficiency, risk assessment, and customer experience in the insurance industry.Partners with data analysts, data scientists, and data consumers across IT and the business to optimize data availability and builds, refines, and enhances AI/ML models and algorithms.Stays up to date with new technologies and industry trends in data management and big data technologies.EducationBachelor’s degree in Computer Science, Information Technology or Engineering is required. Master’s degree preferred.Licenses & CertificationsPrescribed: Not ApplicablePreferred: Advanced Data Analytics Certifications (ADAC), SAS Statistical Business Analyst Professional Certification (SBAPC), Cloudera Certified Professional (CCP) Data EngineerHow We Support Our TeammatesRyan 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 $89,200.00 - $117,075.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.
#J-18808-Ljbffr