At a Glance
- Tasks: Provide advanced analytical support and develop reports for management using SQL and Excel.
- Company: Ryan Specialty is committed to building a diverse workforce and values employee contributions.
- Benefits: Offers training and mentoring opportunities for Data Analysts and supports professional development.
- Other info: Position located in Fenchurch, London, with a focus on data governance and compliance.
- Why this job: Join a team that handles complex data projects in a dynamic London location.
- Qualifications: Requires a Bachelor's degree and 1+ years of experience in statistical analysis or IT.
The predicted salary is between 35000 - 45000 £ per year.
The Data Analyst is responsible for analytic data needs of the business unit. Handle complex data projects and acts as a lead for other Data Analysts.
Location: London - UK - Fenchurch.
Job Responsibilities:
- Provide advanced analytical support for business operations in areas such as claims, client data, policy data, and external reporting.
- Extract, load, model, and reconcile large amounts of data across multiple system platforms and sources.
- Review data to determine operational impacts and needed actions; elevate issues, trends, areas for improvement and opportunities to management.
- Develop reports and deliverables for management.
- Model data using MS Excel, Access, SQL, and/or other data warehouse analytical tools.
- Ensure compliance with federal and state deliverable reporting requirements by performing data quality audits and analysis.
- Assist with training and mentoring other Data Analysts.
- Support Data systems as functional administrator evaluating new release functionality to include testing and implementation of new functionality.
- Perform other duties as assigned.
Experience and Education:
- Bachelor's degree in related field or equivalent experience.
- 1+ years of statistical analysis or 1+ years of related IT experience, including data warehouse, coding or ETL experience.
- Experience managing projects or heavy involvement in project implementation.
- Experience in Data Visualization and building dashboards using SQL.
- Experience with coding language such as Python or R.
- Experience in underwriting analysis.
Licenses & Certifications:
- Power BI Data Analyst Associate Certification (PL-300), or Tableau Certified Data Analyst a plus.
Skills:
- Business Analytics
- Data Governance
- SQL
- ETL Pipelines
- Coding
- Data Warehouse
- Dashboards
- Data Visualization
- Ad hoc Reporting
- Tableau
- Power BI
- Analytical Thinking
- Customer Service Management
- Effective Communication
- Organizational Skills
- Problem Solving
- Time Management
EEO Statement: 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.
Data Analyst employer: Ryan LLC
Ryan Specialty, based in London, offers a commitment to diversity and inclusion in the workplace. Employees benefit from training opportunities and a focus on professional growth. The team values varied perspectives, enhancing service quality for clients and communities.
