SQL Developer - Insurance - SSIS / T-SQL / ETL / .NET / SSAS / SSRS
Are you a data-driven problem solver with a passion for analytics and ready to make a significant impact? We're partnering with a dynamic organization to find a talented Data Analytics Specialist to join their growing team! If you thrive in a fast-paced, innovative environment, this could be the perfect opportunity for you.
As a Data Analytics Specialist, you'll be instrumental in developing and implementing data-driven solutions to complex business challenges. You'll collaborate closely with key stakeholders to understand their needs and craft solutions that deliver real results.
Key Responsibilities:
- Craft, refine, and rigorously test SQL queries, stored procedures, and views to extract data from diverse source systems and platforms.
- Contribute to the seamless roll-out of new SQL-based applications, addressing problem fixes and software enhancements.
- Champion database best practices to enhance the operational reporting environment, proactively resolving issues raised by team members and stakeholders.
- Implement ETL processes and other data movement requirements using SQL and SSIS.
- Develop original and/or complex code in T-SQL/SQL, creating and optimizing SSIS packages.
- Design and develop new SQL code as an integral part of the ETL process.
- Enhance SQL procedures and Window services / .NET programs for data transformation and loading.
- Develop stored procedures and functions using T-SQL/SQL.
- Take ownership of data profiling, source-target mappings, ETL development, SQL tuning and optimization, testing, and implementation.
What We're Looking For:
- Bachelor's/Master's degree in economics, mathematics, computer science/engineering, operations research, or related analytics areas. Exceptional candidates with BA/BS degrees from top-tier academic institutions are also encouraged to apply.
- 5+ years of experience in insurance analytics within the Lloyds Business, London/Bermuda Market (Commercial & Specialty Lines).
- Expertise in advanced SQL and SSIS.
- Experience with reporting tools such as PBI/Tableau/SSAS/SSRS is a plus.
- Exceptional critical thinking and problem-solving abilities.
- A proven track record of achievement, strong analytical skills, and an entrepreneurial, hands-on approach.
- Outstanding written and verbal communication skills, including presentation skills.
- Ability to thrive in a fast-paced, constantly evolving environment and a willingness to tackle challenging projects.
- Cultural sensitivity and the ability to work effectively with clients from diverse backgrounds.
What's In It For You:
- Competitive salary and comprehensive benefits package.
- The chance to work on impactful projects that drive business results.
- A collaborative and supportive work environment.
- Exceptional opportunities for professional growth and development.
Sector:
- General Insurance
- Technology & Change
