Senior SQL Software Engineer
Our client is a leading insurance solutions provider in the DACH region. While working decentralized, they employ the latest technologies in the Azure stack to provide quality products and solutions for their customers and partners.
Responsibilities:
Database Design & Development -> 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.
Write and Optimize Complex SQL Queries -> Develop, review, and fine-tune SQL queries to efficiently process large volumes of data while maintaining performance and reliability.
Monitor and Improve Data Quality -> Implement validation rules and data checks to ensure the accuracy, consistency, and completeness of critical reporting datasets.
Performance Optimization and Monitoring -> 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.
Ensure Reliable Regulatory Data Flows -> Support the preparation of accurate and traceable data for regulatory reporting, ensuring compliance with financial regulations and internal standards.
Build Scalable Data Pipelines in Azure -> Contribute to the design and maintenance of scalable, cloud-native data pipelines using Azure services to manage and transform data end-to-end.
Collaborate Across Functions and Regions -> Work closely with business analysts, data engineers, and stakeholders from different markets to align on regulatory requirements and reporting logic.
Qualifications
Must have
- 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.
Nice to have:
- 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)
Additional Information
Enjoy our holistic benefits program that covers the four pillars that we believe come together to support our wellbeing, covering social, physical, emotional wellbeing, as well as work-life fusion.
- Physical Wellbeing: 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.
- Work-Life Fusion: 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.
- Emotional Wellbeing: 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.
- Social Wellbeing: 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.