Job Description
Job Title: Data/Information Architect – Consultant (14063)
Location: Columbia, SC 29210 100% 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
Location: Columbia, SC 29210 100% 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
- 10+ years of experience in database modeling, architecture, and development.
- 9+ years of experience working with State Government agencies.
- 10+ years of advanced SQL experience.
- 5+ years of hands-on experience with Adobe Experience Manager (AEM) version 6.5.
- 4+ years of Java development, design, and coding experience.
- 5+ years of experience working with Agile methodologies.
- Bachelor's or Master's degree in Information Technology or a related field.
- 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.
- 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.
Numbers & Facts
| Location | Columbia, SC |
| Industry | Computer/IT Services |
| Company Size | 100 to 499 employees |
| Year Founded | 2007 |
| Website | https://www.intersourcesinc.com/ |
About Company
It’s all about harnessing the real power of data. InterSources Inc was founded in 2007 providing intelligent data solutions to clients across industries and geographies.
Over the years, we have built products on Business Intelligence & Big Data platform simplifying and transforming the way business intelligence and real-time data analytics empower Corporations and end-users using Softwares like Tableau, Business Objects, MicroStrategy, etc.
In the process, we have enabled companies to use data analytics to help better understand, predict and influence consumer behavior, identify new market opportunities as they emerge, provide to users the data they need, alert the user when and why key business metrics have changed and enable them to make smart decisions.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder