Job Description
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. 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. Experie
