sql developer Norwich, England
Job description
We help the world see new possibilities and inspire change for better tomorrows. Our analytic solutions bridge content, data, and analytics to help business, people, and society become stronger, more resilient, and sustainable.
An exciting opportunity has come up for a Junior SQL Developer to join Verisk Claims Solutions in Norwich.
You will primarily focus on the AntiFraud product, however, will also work with other teams within the business on integration of the database and general maintenance and performance management of the company’s databases.
You will understand and have some experience in performing ETL (Extract, Transform & Load) tasks on large volumes of data using SSIS (SQL Server Integration Services) from various data sources such as but not limited to CSV, XML and JSON.
Responsibilities
- Monitoring and maintaining existing ETL processes for internal and external data feeds
- Developing ETL processes, working as part of an agile development team
- Developing SQL scripts and Stored Procedures
- Working closely with Data Science teams; preparing and analysing data
- Supporting development team on database design best practices
- Improve system performance by conducting tests troubleshooting and integrating new elements
- Optimize new and current database systems
- Define security and backup procedures
- All work will be fully documented and stored within appropriate version control solutions
- Working with other teams to ensure they have the data required to perform their roles
Essential Requirements:
- Experience creating, performing, and maintaining ETL tasks using technologies such as SSIS
- Experience with relational database technologies such as SQL Server
- Experience in database administration tasks using Microsoft SQL Server 2019 (Schema maintenance, tuning, performance analysis, backups etc.)
- Writing complex T-SQL queries and SQL Stored Procedures
Highly Desirable:
- Experience of the Insurance industry (especially Motor Claims) would be beneficial
- Understand Information security (E.g. GDPR)
- Scrum/Agile Methodology
- Working with PowerShell
- Working with JIRA
- Source Control such as Git
- Working with .NET
- Experience of producing test data for QA environments
- Experience with large (>100,000 rows) datasets or datasets of mixed quality.
- Working with API integrations (JSON, Restful etc). Using Postman or similar tools
- Working with databases in the Cloud (ideally AWS)
#LI-IU1
Additional Information
In 2022, Verisk received Great Place to Work® Certification for our outstanding workplace culture for the sixth year in a row and second-time certification in the UK, Spain, and India. We’re also one of the 38 companies on the UK’s Best Workplaces™ list and one of 18 companies on Spain’s Best Workplaces™ list.
For over fifty years and through innovation, interpretation, and professional insight, Verisk has replaced uncertainty with precision to unlock opportunities that deliver significant and demonstrable impact. From our historic roots in risk assessment, we’ve grown to provide analytic insights that help transform industries focused on some of the world’s most critical areas. Today, the insurance industry relies on Verisk to be, and to make the world, more productive, resilient, and sustainable.
Everyone at Verisk—from our chief executive officer to our newest employee—is guided by The Verisk Way, to Be Remarkable, Add Value, and Innovate.
- Be Remarkable by doing something better each day in service to our customers and each other
- Add Value by delivering immediate and sustained results that drive positive outcomes
- Innovate by redefining what’s possible, embracing challenges, and pushing boundaries
Verisk Businesses
Underwriting Solutions — provides underwriting and rating solutions for auto and property, general liability, and excess and surplus to assess and price risk with speed and precision
Claims Solutions — supports end-to-end claims handling with analytic and automation tools that streamline workflow, improve claims management, and support better customer experiences
Property Estimating Solutions — offers property estimation software and tools for professionals in estimating all phases of building and repair to make day-to-day workflows the most efficient
Extreme Event Solutions — provides risk modeling solutions to help individuals, businesses, and society become more resilient to extreme events.
Specialty Business Solutions — provides an integrated suite of software for full end-to-end management of insurance and reinsurance business, helping companies manage their businesses through efficiency, flexibility, and data governance
Marketing Solutions — delivers data and insights to improve the reach, timing, relevance, and compliance of every consumer engagement
Life Insurance Solutions – offers end-to-end, data insight-driven core capabilities for carriers, distribution, and direct customers across the entire policy lifecycle of life and annuities for both individual and group.
Verisk Maplecroft — provides intelligence on sustainability, resilience, and ESG, helping people, business, and societies become stronger
Verisk Analytics is an equal opportunity employer.
All members of the Verisk Analytics family of companies are equal opportunity employers. We consider all qualified applicants for employment without regard to race, religion, color, national origin, citizenship, sex, gender identity and/or expression, sexual orientation, veteran's status, age or disability.
http://www.verisk.com/careers.html
Unsolicited resumes sent to Verisk, including unsolicited resumes sent to a Verisk business mailing address, fax machine or email address, or directly to Verisk employees, will be considered Verisk property. Verisk will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.
