Description

You will serve as a data architect for the Embedded SRE Platform, supporting various engineering teams with data infrastructure and reliability.

Responsibilities

• Design data warehouse schemas and optimize reporting for trading reconciliation and compliance systems.
• Develop data models, views, stored procedures, functions, and DTS packages to support developer workflows.
• Manage database objects and user permissions using dynamic T-SQL, DDL, and DML statements.
• Implement disaster recovery and high availability solutions for the database environment.
• Troubleshoot poor-performing queries using SQL Server profiling tools and performance monitoring utilities.

Required Skills

• 5+ years of experience in data architecture or database administration.
• Expertise in SQL Server and writing clean, maintainable, and performant T-SQL code.
• Strong proficiency with complex queries, index structures, statistics, and query metrics.
• Hands-on experience with SQL Server Management Studio and Azure Data Studio.
• Experience with data modeling, including designing dimensions, hierarchies, and dynamic measures (DAX).
• Proficiency with Git or other versioning tools for maintaining database object source code.
• Experience managing bulk data transfers into OLTP environments using dynamic SQL batches.
• Knowledge of database consistency checks using DBCC utilities.

Preferred Skills

• Any Graduate degree in Computer Science, Engineering, or related field.

Key Skills

Education

Any Graduate