Lead Data Architect

Luxoft; Schweiz; Remote; CHF 100’000 - 130’000; Vollzeit

Zusammenfassung

A leading consulting firm in Switzerland is seeking an experienced database developer to build risk applications for a top-tier hedge fund. The role involves designing data models, migrating from SQL Server to Azure Fabric, and implementing best practices in data quality and architecture. Candidates should have over 10 years of experience with MS SQL Server and ETL tools. Familiarity with Power BI and Azure DevOps is a plus. This position offers competitive compensation.

Qualifikationen

• 10+ years of experience as a MS SQL Server developer or architect.
• Proven experience in designing and developing data models.
• Familiarity with Power BI and its premium capabilities.

Aufgaben

• Develop business-friendly data models for risk applications.
• Migrate data from SQL Server to Azure Fabric.
• Design and develop reports and performance metrics.

Kenntnisse

Data modelling

Data quality principles

Data architecture

Data warehousing techniques

MS SQL Server

Azure Fabric

ETL tools (SSIS, ADF)

Power Query

DAX

Power BI

Tools

Github

Azure DevOps

Jenkins

Bamboo

Databricks

Jobbeschreibung

Project description

Building a risk applications and tools for innovative international top-tier hedge fund from the ground up, comprising the systems for traders, pre-trade checks and analysis, risks and limits management, reports of trading activities, FIX connectivity, market data providers connectivity (e.g. Bloomberg B-pipe), etc The Team is focused on the development and maintenance of various database applications supporting Risk Management. The successful candidate will have considerable and proven experience in database design, PL/SQL development, a good working knowledge of end-user and server-side data processing techniques, a good understanding of SDLC and agile development methodologies.

Responsibilities

• Developing business friendly data models. Migration from SQL Server -> Fabric and/or Azure

SKILLS

Must have

• - Strong understanding of data modelling and data quality principles- Experience across data architecture and data warehousing techniques and practices is essential (experience migrating SQL to Fabric).- Proven experience in designing and developing data models using industry best practices- Experience in using code management and CI/CD tools such as Github, Azure Devops, Jenkins, Bamboo etc.- Senior (10+ years) MS SQL Server developer/architect.- Azure fabric serviсe experience- 10+ years of experience working with ETL tools such as SSIS, ADF or similar.- Good understanding and demonstrated experience working with Power Query (M query language) and DAX.- Management of Power BI datasets, workspaces and the associated security requirements. - Familiarity with Power BI Premium capabilities, Power BI Rest APIs, Python and Databricks will be highly regarded.- Extensive experience designing and developing reports and performance metrics from complex and disparate platforms

Nice to have

- Experience with Azure- Risks trading system development experience.- Business knowledge in trading domain / capital