Senior Data Architect - AEM, PBI & SQL

Datasoft Technologies, Inc.; Columbia (SC); On-site; USD 96,000 - 165,000; Full time

Benefits offered by this job

Paid Holidays/PTO

Job summary

DataSoft Technologies, a leading IT consulting provider in the US, seeks a systems software programmer with deep AEM, SQL data architecture, and Power BI integration expertise. You will design relational databases, lead data architecture, and implement procedures and SSIS packages to support enterprise applications.

Responsibilities include deploying applications to Dev/QA/Prod, enforcing security standards, and collaborating with analysts, developers, and stakeholders for optimal data-driven

Qualifications

• 10+ years of database modeling, architecture, and development experience.
• 10+ 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 Agile methodology experience.
• Experience with cloud-based solutions.

Responsibilities

• Design relational databases within the architectural framework to meet application needs.
• Lead database design and set standards for database design and access.
• Write and maintain stored procedures; develop SSIS packages and scripts.
• Analyze data volumes and optimize data access and manipulation.
• Support developers and resolve database issues in development and production.
• Prepare system documentation and deployment specifications.
• Deploy applications across Dev/QA/Prod and ensure CI practices.
• Ensure security practices and collaborate on site architecture and reliability.

Skills

Advanced SQL

Java development

Adobe AEM

Agile methodology

Cloud-based solutions

Data modeling

Data architecture

Database design

Education

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

PMP Certification

Tools

SSIS

SQL Server

Job description

DataSoft Technologies, a leading IT consulting provider in the US, seeks a systems software programmer with deep AEM, SQL data architecture, and Power BI integration expertise. You will design relational databases, lead data architecture, and implement procedures and SSIS packages to support enterprise applications.

Responsibilities include deploying applications to Dev/QA/Prod, enforcing security standards, and collaborating with analysts, developers, and stakeholders for optimal data-driven