Description

You will define and build long-term data architecture solutions, translating business needs into dimensional database schemas and repository blueprints.

This role is remote.

Responsibilities

• Reverse engineer existing SQL Server databases and redesign data models for future efficiency.
• Design and build dimensional database schemas, data structures, and metadata repositories.
• Optimize and fine-tune database performance, including stored procedures and functions.
• Manage metadata governance and conduct data shedding to remove obsolete or duplicate data.
• Integrate backend SQL databases with .NET UI layers and approve incoming data changes.

Required Skills

• 7+ years of experience in SQL Server data architecture.
• Strong proficiency in SQL Server Management Studio.
• Expertise in data modeling using Redgate, Erwin, or ER Studio.
• Deep understanding of database object design (Tables, Views, Functions, Procedures).
• Experience with data analysis, data structure design, and metadata management.
• Familiarity with integrating backend databases with .NET UI.

Preferred Skills

• Master's degree in a relevant technical field.
• Experience with operational data integration for real-time APIs and big data analytics.

Key Skills

Education

Any Graduate