Data Architect

About the Role

This role supports Our Client in designing and maintaining robust data solutions that power critical business applications. You will work on‑site in a collaborative environment alongside consultants, developers, and business stakeholders, ensuring data integrity, performance, and scalability. The position demands a blend of architectural vision and hands‑on implementation to keep the data ecosystem reliable and future‑ready. As a key member of the team, your work directly impacts the organization’s ability to deliver accurate reporting and analytics.

Key Responsibilities

• Collaborate with consultants, application developers, and end users to define logical data models and overall data architecture for assigned applications.
• Design and implement relational database schemas that align with architectural standards and business requirements.
• Serve as the lead database designer, establishing and enforcing best‑practice standards for database design, stored procedures, and data access patterns.
• Write, maintain, and optimize stored procedures, and develop standards for using ORMs and other data access technologies.
• Create and manage database utilities such as SQL Server Integration Services (SSIS) packages to support data movement and transformation.
• Monitor, maintain, and optimize server infrastructure to ensure high availability and performance of data services.
• Participate in a shared 24/7 on‑call rotation to address critical incidents and support system stability.
• Provide technical guidance and mentorship to development teams on database best practices and performance tuning.

Required Skills & Experience

• 5+ years of experience designing and implementing data architectures and relational databases, preferably with SQL Server.
• Strong proficiency in data modeling, schema design, and writing complex stored procedures.
• Hands‑on experience with Adobe Experience Manager (AEM) and Power BI for forms, workflow, and reporting solutions.
• Proven ability to develop and maintain SSIS packages and other ETL processes.
• Experience establishing database design standards, error‑handling conventions, and data access guidelines.
• Solid understanding of server monitoring, performance tuning, and on‑call support responsibilities.
• Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent professional experience).
• Current residency in South Carolina with no relocation required.

Tools & Technologies

• Adobe Experience Manager (AEM) – for content management and workflow integration.
• Power BI – for dashboard creation and data visualization.
• Microsoft SQL Server – core relational database platform.
• SQL Server Integration Services (SSIS) – for ETL and data movement.
• Object‑Relational Mappers (e.g., Entity Framework) – for application data access.
• Version control systems (e.g., Git) – for source code management.
• Monitoring tools (e.g., SQL Server Profiler, Performance Monitor) – for performance analysis.

Work Schedule & Duration

• 12‑month contract with the possibility of extension.
• Fully onsite at the Columbia, SC location.
• Shared 24/7 on‑call rotation for critical incident response.
• Start date: November 17, 2026.

Interview Process

The interview process consists of a single onsite interview round with the hiring manager and technical team.

Position Details

• Employment Type: Contract
• Duration: Approximately 12 months (with potential for extension)
• Work Authorization: Must be authorized to work in the United States