Senior SQL Server Database Architect - Remote Position

About the Role

We're hiring a Senior SQL Server Database Architect to join our team in a fully remote capacity. In this role, you'll be responsible for building, configuring, and maintaining SQL Server databases, schemas, indexing, and data structures. This is an exciting opportunity to leverage your extensive experience in SQL Server to optimize performance and ensure data integrity.

What You'll Do

• Build, configure, and maintain SQL Server databases, schemas, indexing, and data structures.
• Develop and optimize Stored Procedures, T-SQL logic, and ETL components using Microsoft Visual Studio.
• Ingest data from diverse sources and deliver processed outputs to downstream applications.
• Monitor, troubleshoot, and maintain ETL jobs, scheduled tasks, and automated workflows.
• Investigate discrepancies, system issues, and integration failures to ensure reliable data flows.
• Support operational and financial month-end reporting processes.
• Maintain enterprise dataflows, transformation logic, and data validation controls.
• Design and maintain dimensional models for reporting and analytics.

Requirements

• 8+ years of SQL Server development and administration experience, including installation, configuration, tuning, and maintenance.
• Advanced T-SQL skills (Stored Procedures, functions, triggers, complex queries, performance tuning).
• ETL development experience using Microsoft Visual Studio (SSIS or similar).
• Strong schema design, database architecture, indexing, partitions, and constraints knowledge.
• Experience with SQL Server security frameworks (roles, permissions, least privilege access).
• Proven ability to ingest data from databases, APIs, and file formats (CSV, Excel, JSON, XML, SFTP).
• Experience delivering data to downstream systems via integrations or flat file exports.
• Solid dimensional modeling skills (facts, dimensions, star/snowflake schemas).

Nice to Have

• Knowledge of Cognos or Power BI; IQMS experience is a plus.

What We Offer

• Competitive salary range of $120,000 - $150,000 per year.
• Comprehensive relocation support packages to help you settle into your new role.
• Flexible remote work environment.
• Opportunities for professional development and career advancement.
• Collaborative team culture with a focus on innovation.