Senior Data Architect — AEM, SQL & Power BI Lead

InterSources Inc.; Columbia (SC); On-site; USD 120,000 - 160,000; Full time

Job summary

InterSources Inc. seeks an experienced Data/Information Architect – Consultant to lead database modeling, advanced SQL, and AEM 6.5 development.

The role focuses on enterprise data architecture, forms, workflows, dashboards, and reporting using Power BI, with collaboration across developers, DBAs, and business stakeholders. The candidate will design standards, optimize performance, and support deployments across development, QA, and production environments, while maintaining data integrity and

Qualifications

• 10+ years in database modeling, architecture, and development.
• 9+ years with State Government agencies.
• 10+ years of advanced SQL experience.
• 5+ years with Adobe Experience Manager (AEM) version 6.5.
• 4+ years of Java development, design, and coding.
• 5+ years experience with Agile methodologies.
• Bachelor's or Master's degree in IT or related field.

Responsibilities

• Design and maintain logical data models, relational databases, and enterprise data architecture.
• Lead database design and establish database development standards.
• Develop and maintain advanced SQL queries, stored procedures, SSIS packages, and database scripts.
• Optimize database performance, data access, and application efficiency.
• Support Adobe AEM-based forms, workflows, and applications utilizing Power BI dashboards and reporting.
• Collaborate with Java developers, database administrators, vendors, and business users to resolve issues.
• Support deployments, migrations, and configuration across Development, QA, and Production environments.
• Perform unit, integration, and acceptance testing while maintaining technical documentation.
• Implement secure coding standards, automation, CI/CD, and deployment best practices.
• Monitor server infrastructure, system availability, performance, reliability, and data integrity.
• Troubleshoot production issues, backup configurations, and recovery processes.
• Participate in shared 24/7 on-call support and provide timely incident resolution.
• Communicate project status and improvements to stakeholders.

Skills

Database modeling

State government experience

Advanced SQL

Adobe Experience Manager (AEM)

Java development

Agile methodologies

Education

Bachelor's or Master's in IT or related field

Tools

Adobe Experience Manager

Power BI

SSIS

SQL Server

Job description

InterSources Inc. seeks an experienced Data/Information Architect – Consultant to lead database modeling, advanced SQL, and AEM 6.5 development.

The role focuses on enterprise data architecture, forms, workflows, dashboards, and reporting using Power BI, with collaboration across developers, DBAs, and business stakeholders. The candidate will design standards, optimize performance, and support deployments across development, QA, and production environments, while maintaining data integrity and