Lead Data Architect

Luxoft; United States; Remote; USD 80,000 - 100,000; Full time

Job summary

An innovative international firm is seeking a seasoned database developer to build risk applications for a top-tier hedge fund. This role involves developing robust data models and managing migrations from SQL Server to Azure Fabric. With a focus on data quality and architecture, you will utilize your extensive experience in MS SQL Server and ETL tools to enhance risk management systems. Join a dynamic team where your contributions will directly impact trading activities and risk analysis. If you thrive in a fast-paced environment and are passionate about data solutions, this is the perfect opportunity for you.

Qualifications

• 10+ years of experience in database design and PL/SQL development.
• Strong understanding of data modeling and data architecture.

Responsibilities

• Develop business-friendly data models and migrate from SQL Server to Fabric/Azure.
• Design and develop reports and performance metrics from complex platforms.

Skills

Data Modeling

Data Quality Principles

Data Architecture

Data Warehousing Techniques

MS SQL Server Development

Azure Fabric Service

ETL Tools (SSIS, ADF)

Power Query (M query language)

DAX

Power BI Management

Tools

GitHub

Azure DevOps

Jenkins

Bamboo

Power BI

Databricks

Job description

Project description

Building risk applications and tools for an innovative international top-tier hedge fund from the ground up, comprising systems for traders, pre-trade checks and analysis, risks and limits management, and reports of trading activities, including FIX connectivity and market data providers connectivity (e.g., Bloomberg B-pipe). 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, and a good understanding of SDLC and agile development methodologies.

Responsibilities

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

SKILLS

Must have

• Strong understanding of data modeling 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 service 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 the trading domain / capital.