Data Information Architect

Accord Technologies Inc; Columbia (SC); On-site; USD 120,000 - 170,000; Full time

Job summary

Accord Technologies Inc. seeks a Data Information Architect to lead data architecture, database design, and integration efforts in Columbia, SC. The role focuses on AEM 6.5, PBI, and robust SQL development, with ownership of data models and performance optimization.

The candidate will design relational databases, develop stored procedures, and ensure secure, scalable data access across Dev/QA/Prod environments, while aligning with agency requirements and team standards.

Qualifications

• Bachelor's or Master's in Information Technology or related field is required.
• PMP or PMI certification preferred.
• Experience with AEM, PBI, and data architecture is expected.

Responsibilities

• Develop logical data model and data architecture for assigned applications.
• Design relational databases within the architecture to meet needs.
• Lead database design for assigned systems and develop standards for design and access.
• Develop and maintain stored procedures and standards for ORM access.
• Analyze data volumes and optimize database performance; support dev/prod environments.
• Collaborate with consultants, developers, and end users to ensure data integrity and reliability.

Skills

Database modeling

State government experience

Advanced SQL

Adobe AEM 6.5

Java development

Agile methodology

Education

Bachelor's or Master's in Information Technology

Tools

SSIS

Power BI

SQL Server

Job description

Job Title: Data Information Architect
Job Location: Columbia, SC
Position Type: W2 Contract
Duration: 12 months

Job Title: Data Information Architect
Job Location: Columbia, SC
Position Type: W2 Contract
Duration: 12 months

Primary Skills

Database modeling, architecture, and development, advanced SQL, Adobe Experience Manager (AEM) 6.5, Java development, design and coding, Power Business Intelligence (PBI), data architecture, relational database design, stored procedures, SQL Server Integration Services (SSIS), database utilities, database performance optimization, Agile methodology, secure web programming, unit testing, continuous integration, system and programming documentation

Preferred Skills

Experience with cloud-based solutions, PMP or other PMI issued certification

Position Overview

A state agency has implemented Adobe Experience Manager (AEM) and Power Business Intelligence (PBI) as its tool set for forms, workflow, and dashboard/report development. The agency wishes to engage a Systems Software Programmer experienced in AEM, PBI, and Data Architecture. Under limited supervision, the contractor will serve as a Systems Software Programmer reporting directly to a functional manager. The contractor will be a team member that ensures the stability and integrity of data and server services through monitoring, maintenance, support, and optimization of all server infrastructure. This individual has 24/7 on-call responsibilities shared with the group.

Daily Duties / Responsibilities

• Work with consultants, application developers, and end users to develop the logical data model and data architecture of assigned application.
• Design relational databases within the architectural framework to meet application needs.
• Serve as lead database designer for assigned application systems.
• Develop and implement standards for database design.
• Write and maintain stored procedures as needed; develop standards for the use of stored procedures, object relational mappers, and other means of database access.
• Develop standards for application handling of databases, including error handling.
• Build database utilities as needed for application use, such as SQL Server Integration Services (SSIS) packages and database scripts.
• Analyze anticipated data volumes and patterns of use; gain knowledge of agency data usage to improve efficiency of database access and manipulation.
• Support application developers and assist in resolving database-related application problems, both in development and in production.
• Work with Database Administration to resolve database performance problems.
• Prepare and obtain approval of system and programming documentation.
• Configure system settings and options; plan and execute unit, integration, and acceptance testing and create specifications for systems to meet business requirements.
• Assist in deploying applications to Dev, QA, Production environments and migrations.
• Follow best practices for secure web programming and deployment.
• Adhere to internal best practices with respect to coding standards, unit test coverage, automation, and continuous integration.
• Work closely with Team or vendor to ensure sound practices regarding site architecture, performance and reliability, and content delivery are in place.
• Perform duties and responsibilities in a manner consistent with our mission, values, and client service standards. Non-Technical
• Effectively interact and communicate with peer to Director-level IT professionals.
• Provide feedback to team regarding product issues, enhancements and new features.
• Must have initiative, drive and be a self-starter.
• Ability to ask pertinent questions of others.
• Proactively seek to identify, communicate and implement process-related improvements.
• Effectively manage multiple tasks and activities concurrently and able to provide periodic status updates to key stakeholders.
• Collaborate extensively with peers and management to resolve client issues while actively contributing to a growing knowledge network that improves the effectiveness of our team and the information available to our clients.
• Prioritize numerous issues of varying severity, and effectively manage the resolution of all issues within accepted service levels. This includes ownership of the data entered into the Helpdesk system and appropriately updating both client and appropriate employees of status of all issues on a timely basis.
• Good customer skills, be attentive to detail, and responsive to customer tickets. Technical
• Troubleshoot and recommend technical solutions for customer issues related to backup configuration and recovery.
• Develop workaround solutions as appropriate.
• Perform equipment and software upgrades.
• Maintain familiarity with current computer and network products.
• Adhere to corporate information security guidelines and promote information security among coworkers.
• Perform other duties and special projects as assigned.

Required Skills

• 10+ Years of database modeling, architecture, and development experience
• 9+ Years of State Government Experience
• 10+ Years of Advanced SQL Experience
• 5+ years Adobe AEM 6.5 version
• 4+ years of Java development, design and coding experience
• 5+ Years of Experience with Agile methodology

Preferred Skills

• Experience with cloud-based solutions

Additional Skills

• Ability to establish and maintain good working relationships with business users, management, vendors, and peers.
• Strong organizational, multi-tasking, and time-management skills.
• Hands-on business knowledge of business processes.
• Ability to communicate clearly and concisely, both orally and in writing.

Required Education

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

Required / Preferred Certifications

• Preferred: PMP or other PMI Issued Certification