SQL Server Analyst / Architect
| Client | Metropolitan Sewer District (MSD) |
| Work location | St. Louis, MO Onsite 5 days a week St. Louis, MO Local candidates |
| Term | 3 Months - with option to renew |
Summary
Local and 100 % onsite
SQL Server Admin/Analyst/DBA/Architect/Data Modeler
Database schema design and ER diagram
logical and physical database models
SSRS - Desired
Database Analyst
Anticipated Start Date: October 13, 2025
Responsibilities:
- Design and maintain the logical and physical database models to support MSDCARS.
- Develop and manage the project's database schema design and ER diagram, ensuring clarity of definitions and relationships.
- Develop and implement Database schemas, tables, stored procedure and functions
- Ensure data integrity, consistency, and scalability within the application.
- Collaborate with the SQL Server Database Administrator to optimize query performance and identifying bottlenecks, troubleshooting database issues.
- Partner with business and technical stakeholders to align the data model with reporting and compliance requirements.
Required Skills:
- 5 years of experience as a Data Architect, Data Modeler, or equivalent.
- Strong expertise in SQL Server database modeling and database design.
- Hands-on experience in DDL, DML, DQL in SQL Server database.
- Knowledge of SSRS tool will be add-on.
- Knowledge of normalization, data integrity, and relational database best practices.
Preferred Skills/Certifications:
- Experience in compliance or government reporting environments a plus
- Data management certifications (e.g., DAMA, CDMP) will be add-on