SQL Architect/Developer

Project overview

SQL Architect/Developer

Reference: 39e1595b-4e18-45db-b778-95c94082de5e

Responsibilities

• Develop and optimize SQL queries: Develop, test, and implement complex SQL queries for large datasets with performance optimization.
• Design and evolve SQL-based BI solutions: Understand, extend existing concepts and architectures, and develop new technical solutions.
• Optimize BI data models and data structures: Structure, model, and optimize stable and scalable data models for performance.
• Evolve SQL Server environment: Safely use and technically advance existing SQL Server functionalities and object types.
• Design interfaces and data flows: Technically design data provision for internal analyses as well as Dataform and other third-party systems.
• Evolve reporting solutions: Technically support existing reports and dashboards and implement new requirements.
• Support Enterprise Data Platform: Integrate new data sources and further develop the existing data platform from a SQL/BI perspective.

Requirements

• In-depth SQL knowledge at expert level, especially development and optimization of complex SQL queries.
• Sound experience with Microsoft SQL Server, ideally SQL Server 2019.
• Comprehensive architectural understanding in the SQL and relational database environment.
• Experience in the design and evolution of SQL-based BI solutions.
• Confident handling of complex data models, large datasets, and SQL Server structures.
• Very good knowledge in performance optimization, indexes, and execution plans.
• Ability to understand existing technical concepts and develop them independently.
• Practical experience in the BI and reporting environment.
• Experience with data extractions, interfaces, and data provision for third-party systems.
• Knowledge of Microsoft Fabric, Power BI, and Azure is an advantage.

Project details

asap

3 MM++

• Start: ab sofort
• Duration: 3 Monate
• Remote: onsite
• Location: Köln, Deutschland, DE
• Languages: German

Source notes

The IT division is our core competence, on which Hays has developed. We are the largest privately organized IT personnel service provider in Germany and have the right offer for every career level – whether you are interested in vacancies in agile SMEs or strong DAX corporations. We master the entire IT spectrum from support to software architecture or digitalization – thanks to our extensive portfolio, there is something for everyone. In recent decades, we have been able to support countless IT specialists and managers in setting the course for a successful career within a lifelong partnership.

Our consulting team is specialized and thus able to respond to your wishes and ideas and to prepare you optimally for job interviews and contract negotiations. Try it out and find out what the market has to offer you – completely free of charge, discreetly and without obligation! We look forward to hearing from you.

My contact at Hays:

My contact person:

Sugunappriya Jeyaraj

Reference number:

*

Contact:

• Remote possibility
• Exciting environment