Senior Adobe AEM Developer or SQL Data Architect

Innosoft Corporation; New York (NY); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health insurance

Paid vacation

401K match

STD LTD and AD&D

Job summary

Innosoft Corporation is recruiting a Senior Adobe AEM Developer / SQL Data Architect to support the South Carolina Department of Revenue. The role focuses on AEM, Power BI, data architecture, and enterprise data integration in a secure government environment.

The contractor will design data models, develop and optimize databases, and lead data architecture efforts while collaborating with internal teams and vendors. A 12-month contract includes on-site work in Columbia, SC and on-call rotation.

Qualifications

• Bachelor's or Master’s in Information Technology or related field.
• 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) 6.5.
• 4+ years of experience in Java development, application design, and coding.
• 5+ years of experience working with Agile methodologies.

Responsibilities

• Collaborate with consultants, developers, and end users to design data models and data architecture.
• Design relational databases within established frameworks to meet requirements.
• Lead database design for assigned systems ensuring performance and reliability.
• Develop and maintain database standards, procedures, and best practices.
• Implement SSIS packages and database scripts to support functionality.
• Analyze data volumes and usage to optimize performance and access.

Skills

AEM 6.5

SQL

Data architecture

Java

Agile methodologies

Govt experience

Education

Bachelor's or Master’s in IT

Tools

SSIS

Power BI

Job description

Senior Adobe AEM Developer or SQL Data Architect

Senior Adobe AEM Developer / SQL Data Architect

Project Identifier

SC

Client

South Carolina

Agency

State of South Carolina

Location

Onsite

Location:300 A Outlet Point Blvd, Columbia, South Carolina, USA, 29201.

Candidatelocation: Candidate must be a CURRENT SC resident. No relocationallowed.

Contract Duration

12 Months

Interview Type

Online

The candidate will have to be on an InnosoftW2.

At least 6 months of valid workauthorization

Tentative Start Date

11/17/2026

Deadline

10/19/2026

Project Overview

The South Carolina Department of Revenue (SCDOR) isseeking a skilled and experienced Systems Software Programmer with expertise inAdobe Experience Manager (AEM), Power Business Intelligence (Power BI), andData Architecture to support the agency's enterprise technology environment.SCDOR operates in a complex, multi-layered secure environment and focuses ondelivering high-quality technology solutions through established methodologies,procedures, and industry best practices. The selected contractor will supportthe agency's implementation and ongoing use of AEM and Power BI for formsdevelopment, workflow automation, dashboards, and reporting solutions.

Working under limited supervision and reportingdirectly to a functional manager, the contractor will collaborate with thetechnology team to ensure the stability, integrity, availability, andperformance of data and server services. Responsibilities include monitoring,maintaining, supporting, troubleshooting, and optimizing server infrastructureto ensure reliable and efficient operations. The ideal candidate shoulddemonstrate strong technical expertise, professionalism, problem-solvingabilities, and the ability to deliver quality work within established deadlineswhile contributing innovative solutions and industry best practices. Theposition requires participation in a shared 24/7 on-call rotation to supportcritical systems and infrastructure.

Duties/Responsibilities:

• Collaboratewith consultants, application developers, and end users to develop logicaldata models and data architecture for assigned applications.
• Designand develop relational databases within established architecturalframeworks to meet application and business requirements.
• Serve asthe lead database designer for assigned application systems, ensuringdatabase performance, scalability, and reliability.
• Develop,implement, and maintain database design standards, best practices, andprocedures.
• Write,maintain, and optimize stored procedures, database scripts, and otherdatabase objects.
• Establishstandards for stored procedures, Object-Relational Mappers (ORM), databaseaccess methods, and application-level database error handling.
• Developdatabase utilities, including SQL Server Integration Services (SSIS)packages and database scripts, to support application functionality.
• Analyzeanticipated data volumes, usage patterns, and agency data requirements to improve database access, processing, and performance.
• Providetechnical support to application developers in resolving database-relatedissues in development and production environments.
• Collaboratewith Database Administration teams to identify, troubleshoot, and resolvedatabase performance issues.
• Prepare,maintain, and obtain approval for system design specifications, technicaldocumentation, and programming documentation.
• Configuresystem settings and options to meet application functionality,performance, and business requirements.
• Plan,develop, and execute unit testing, integration testing, and useracceptance testing (UAT) to validate system functionality.
• Assistwith application deployments, releases, and migrations across Development,Quality Assurance (QA), and Production environments.
• Followsecure web programming, application development, and deployment bestpractices.
• Adhereto established coding standards, unit test coverage requirements,automation practices, and continuous integration processes.
• Workclosely with internal teams and external vendors to ensure effective sitearchitecture, system performance, reliability, and content delivery.
• Troubleshoottechnical issues related to backup configuration, data recovery, systemoperations, and application performance.
• Developand implement temporary workarounds and permanent technical solutions toresolve customer and system issues.
• Performhardware, equipment, and software upgrades to maintain systemfunctionality and operational efficiency.
• Maintainknowledge of current computer systems, network products, softwaretechnologies, and industry best practices.
• Followorganizational information security policies and guidelines whilepromoting secure practices among team members.
• Communicateeffectively with IT professionals, technical teams, management, anddirector-level stakeholders.
• Providefeedback and recommendations regarding product issues, systemenhancements, new features, and technology improvements.
• Demonstrateinitiative, independent problem-solving skills, and the ability to askrelevant questions to clarify technical and business requirements.
• Proactivelyidentify, recommend, communicate, and implement process improvements to enhance operational efficiency.
• Managemultiple assignments and priorities simultaneously while providing regularstatus updates to stakeholders.
• Collaboratewith peers, management, and vendors to resolve client issues andcontribute to shared technical knowledge and documentation.
• Prioritizeand resolve technical issues based on severity, business impact, andestablished service-level agreements (SLAs).
• Maintainaccurate Helpdesk records, take ownership of assigned tickets, and providetimely updates to clients and internal teams.
• Deliverresponsive customer support with strong attention to detail,professionalism, and commitment to service quality.
• Performresponsibilities in accordance with the agency's mission, organizationalvalues, and client service standards.
• Performother assigned duties and special projects as required.

Requirements

Education and Certifications:

• Bachelor'sor Master’s in Information Technology or related field

Required Skills:

• 10+years of experience in database modeling, architecture, and development.
• 9+ yearsof experience working with State Government agencies.
• 10+years of advanced SQL experience.
• 5+ yearsof hands-on experience with Adobe Experience Manager (AEM) 6.5.
• 4+ yearsof experience in Java development, application design, and coding.
• 5+ yearsof experience working with Agile methodologies.

Preferred Skills:

• Experiencewith cloud-based solutions
• PMP orother PMI-issued certification

Additional Skills:

• Abilityto establish and maintain strong professional relationships with businessusers, management, vendors, and team members.
• Strongorganizational, multitasking, and time-management skills, with the abilityto prioritize tasks and meet deadlines effectively.
• Hands-onunderstanding of business processes, workflows, and operationalrequirements.
• Excellentverbal and written communication skills, with the ability to conveyinformation clearly, concisely, and professionally.

Standard Employee Benefits.

50% Health Insurance Paid by Innosoft, Paid Vacation, 401K Match, STD LTD and AD&D paid by Innosoft.