Senior SQL Software Engineer

accesa.eu
Summary
Join Accesa, a leading technology company, as a Database Developer working with a top insurance solutions provider in the DACH region. You will leverage your expertise in MS SQL to design, develop, and optimize complex databases and data pipelines within the Azure cloud environment. Responsibilities include developing SQL queries, maintaining database schemas, ensuring data quality, and optimizing performance. You will collaborate with various teams to meet regulatory reporting requirements and build scalable data solutions. This role requires 8+ years of experience with MS SQL, advanced knowledge of SQL Server Management Studio, and strong analytical skills. Accesa offers a holistic benefits program focused on 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
- Advanced English language skills
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 (nice to have)
- Experience working with Azure DevOps (CI/CD Pipelines)
- Document storage / NoSQL databases (e.g.: MongoDB)
Benefits
- Our wellbeing program includes medical benefits, gym support, and personalized fitness options for an active lifestyle, complemented by team events and the Healthy Habits Club
- In very dynamic industries such as IT, the line between our professional and personal lives can quickly become blurred. Having a one-size-fits-one approach gives us the flexibility to define the work-life dynamic that works for us
- We believe that to maintain our overall health, we need to invest in our mental wellbeing just as much as we do in our physical health, social connections or in achieving work-life balance
- As a growing community in a hybrid environment, we want to ensure we remain connected not just by the great work we do every day but through our passions and interests