DataInformation Architect

Job Title: Data/Information Architect Consultant (14063)
Location: Columbia SC% Onsite
Candidate Location: Current South Carolina residents only No relocation allowed
Contract Duration: 12 Months (Possible Extension)
Interview Process: 1 Round Onsite Interview

Job Summary
The client is seeking an experienced Data/Information Architect Consultant with strong expertise in database architecture advanced SQL Adobe Experience Manager (AEM 6.5) and Java development.
The consultant will support enterprise applications utilizing Adobe Experience Manager (AEM) and Power BI for forms workflows dashboards and reporting.
This role requires extensive experience in database modeling relational database design application development and performance optimization.
The selected candidate will collaborate with developers database administrators and business stakeholders to maintain data integrity system reliability and application performance.
Responsibilities include developing database standards stored procedures SSIS packages and supporting application deployments across development QA and production environments.
The position also involves server infrastructure support troubleshooting secure development practices and shared 24/7 on-call responsibilities.

Required Skills

1. 10 years of experience in database modeling architecture and development.
2. 9 years of experience working with State Government agencies.
3. 10 years of advanced SQL experience.
4. 5 years of hands-on experience with Adobe Experience Manager (AEM) version 6.5.
5. 4 years of Java development design and coding experience.
6. 5 years of experience working with Agile methodologies.
7. Bachelors or Masters degree in Information Technology or a related field.

Preferred Skills

• Experience with cloud-based solutions.
• PMP certification or another PMI-issued certification.
• Experience with Power BI dashboards reporting and enterprise application integration.
• Knowledge of SQL Server Integration Services (SSIS) stored procedures and database performance optimization.

Key Responsibilities

• Design develop and maintain logical data models relational databases and enterprise data architecture.
• Serve as lead database designer 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 application and database issues.
• Support application 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 continuous integration and deployment best practices.
• Monitor and maintain server infrastructure system availability performance reliability and data integrity.
• Troubleshoot production issues backup configurations recovery processes and system upgrades.
• Participate in shared 24/7 on-call support and provide timely incident resolution.
• Communicate project status technical concerns and process improvements to stakeholders and management.

About Us: InterSources Inc is a Small Woman and Minority-Owned Business Enterprise ISO/IEC 27001 SOC 2 Type 2 certified company with massive 18 years of diversified experience in providing IT Consulting Services Artificial Intelligence Data Analysis Application Development Cloud Services Cybersecurity Digital Marketing ERP Management Custom Software Development Web Development UI/ UX Design System Integration QA Support etc. We make reasonable accommodations for clients and employees and we do not discriminate based on any protected attribute including race religion color national origin gender sexual orientation gender identity age or marital status. We also are a Google Cloud and Oracle partner company.

Required Experience:

Staff IC