Senior SQL Software Engineer

Company Description

Accesa is a leading technology company headquartered in ClujNapoca, with offices in Oradea and 20 years of experience in turning business challenges into opportunities and growth.

A valuedriven organization, it has established itself as a partner of choice for major brands in Retail, Manufacturing, Finance, and Banking. It covers the complete digital evolution journey of its customers, from ideation and requirements setup to software development and managed services solutions.

With more than 1,200 IT professionals, Accesa also has a fastgrowing footprint, establishing itself as an employer of choice for IT professionals who are passionate about problemsolving through technology. Coming together in strong tech teams with a customercentric approach, they enable businesses to grow, delivering value for our clients, partners, industry, and community.

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 finetune 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 cloudbased 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, cloudnative data pipelines using Azure services to manage and transform data endtoend.

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 (CICD 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 worklife 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.
    • WorkLife Fusion: In very dynamic industries such as IT, the line between our professional and personal lives can quickly become blurred. Having a onesizefitsone approach gives us the flexibility to define the worklife 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 worklife 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.