Senior SQL Software Engineer

Summary

Join Accesa, a leading technology company, and work for a top insurance solutions provider in the DACH region. This role focuses on database design and development using MS SQL within an Azure environment. You will develop complex SQL queries, optimize database performance, ensure data quality, and build scalable data pipelines. Collaboration with various teams is crucial. The position requires 8+ years of experience with MS SQL, including stored procedures and performance optimization. Accesa offers a holistic benefits program encompassing physical, emotional, social wellbeing, and work-life fusion.

Requirements

• 8+ years of professional experience
• Experience in working with MS SQL
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
• Experience with stored procedures and performance optimization processes
• Proactive approach to design solution proposals
• Knowledge of manipulating, processing and extracting value from large disconnected datasets
• Advanced knowledge of Microsoft SQL Server Management studio

Responsibilities

• Develop complex SQL queries and scripts for data extraction, manipulation, and reporting
• Create and maintain database schemas, tables, indexes, views, functions, triggers, and stored procedures
• Design and implement SQL Database architectures, ensuring scalability and high availability
• Develop, review, and fine-tune SQL queries to efficiently process large volumes of data while maintaining performance and reliability
• Implement validation rules and data checks to ensure the accuracy, consistency, and completeness of critical reporting datasets
• Analyze cloud-based SQL queries and database performance metrics to recommend and implement optimization strategies
• Use Azure Monitor and other tools to oversee database performance and automate tuning processes
• Support the preparation of accurate and traceable data for regulatory reporting, ensuring compliance with financial regulations and internal standards
• Contribute to the design and maintenance of scalable, cloud-native data pipelines using Azure services to manage and transform data end-to-end
• Work closely with business analysts, data engineers, and stakeholders from different markets to align on regulatory requirements and reporting logic

Preferred Qualifications

• Knowledge of one or more reporting tools such as PowerBI, Tableau, QlikView etc
• Backend Development: .NET
• Experience working with Azure DevOps (CI/CD Pipelines)
• Document storage / NoSQL databases (e.g.: MongoDB)

Benefits

• Medical benefits
• Gym support
• Personalized fitness options
• Team events
• Healthy Habits Club
• Flexible work arrangements to define work-life dynamic