Data Architecture Lead — AEM & BI (Contract)

SUNSHINE ENTERPRISE USA LLC; New York (NY); On-site; USD 120,000 - 180,000; Part time

Job summary

SUNSHINE ENTERPRISE USA LLC seeks an experienced Data Information Architect for a 12-month contract in Columbia, SC. The role focuses on data architecture, database modeling, and SQL development with AEM and Power BI integration.

The ideal candidate has 10+ years in data modeling, 5+ years Agile experience, and strong collaboration skills across developers, vendors, and business users. Onsite work in Columbia, SC, with 24/7 support responsibilities as needed.

Qualifications

• 10+ years of experience in database modeling, architecture, and development.
• 9+ years of state government experience.
• 10+ years of advanced SQL experience.
• 5+ years of experience with Adobe Experience Manager (AEM) 6.5.
• 4+ years of Java development, design, and coding experience.
• 5+ years of experience working with Agile methodologies.

Responsibilities

• Design and maintain logical data models and data architecture for assigned applications in collaboration with consultants, application developers, and end users.
• Design relational databases within established architectural frameworks to meet application requirements.
• Serve as the lead database designer for assigned application systems.
• Develop, implement, and maintain database design standards and best practices.
• Write and maintain stored procedures, database scripts, and other database access components.
• Establish standards for stored procedures, ORM, database access, and application-level database error handling.
• Develop SSIS packages as required.
• Analyze data volumes and usage to improve performance and efficiency.
• Collaborate with DBAs to troubleshoot and resolve performance issues.
• Support developers in resolving database-related issues in development and production.

Skills

Database modeling

Data architecture

Advanced SQL

Java development

Agile methodologies

Education

Bachelor’s or Master’s Degree in Information Technology/Computer Science

Tools

Adobe Experience Manager (AEM) 6.5

Power BI

SSIS

SQL Server

Java

Job description

SUNSHINE ENTERPRISE USA LLC seeks an experienced Data Information Architect for a 12-month contract in Columbia, SC. The role focuses on data architecture, database modeling, and SQL development with AEM and Power BI integration.

The ideal candidate has 10+ years in data modeling, 5+ years Agile experience, and strong collaboration skills across developers, vendors, and business users. Onsite work in Columbia, SC, with 24/7 support responsibilities as needed.