Data Architect - 26-01179

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

• Scope of the project:Client has implemented Adobe Experience Manager (AEM), and Power Business Intelligence (PBI) as its tool set for forms, workflow and Dashboard/Report development. client wishes to engage a systems software programmer experienced in AEM, PBI and Data Architecture. The following description details the skills and tasks that are required of the systems software programmer.
• Under limited supervision, the contractor will serve as a systems software programmer reporting directly to a functional manager. 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.

KEY DUTIES AND RESPONSIBILITIES

Works with consultants, application developers and end users to develop the logical data model and data architecture of assigned application. Designs relational databases within the architectural framework to meet application needs. Serves as lead database designer for assigned application systems. Develops and implements standards for database design.

• Writes and maintains stored procedures as needed; develops standards for the use of stored procedures, object relational mappers, and other means of database access. Develops standards for application handling of databases, including error handling. Builds database utilities as needed for application use, such as SQL Server Integration Services (SSIS) packages and database scripts.
• Analyzes anticipated data volumes and patterns of use; gains knowledge of agency data usage to improve efficiency of database access and manipulation.
• Supports application developers. Assists application developers in resolving database related application problems, both in development and in production. Works with Database Administration to resolve database performance problems
• Prepares and obtains approval of system and programming documentation.
• Configure system settings and options; plans and executes unit, integration and acceptance testing and creates 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.
• Pre-employment Checks
• At a minimum, Suppliers will run:
• Nationwide criminal history check, which must include Federal, State, and County records for the states (or countries if applicable) where the Supplier’s employee has resided in the past seven years
• Credit history check
• All hired contractors will have their South Carolina tax history checked. Contractors must be current on filings and payments.

Daily Duties / Responsibilities

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
• - Performs other duties and special projects as assigned.

Required Qualifications

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 (rank in order of Importance):
• 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/Certifications:Bachelor's or Master’s in Information Technology or related field

Preferred Education/Certifications

• PMP or other PMI Issued Certification

About our Company

• DataSoft Technologies is a highly recognized provider of professional IT Consulting services in the US. Founded in 1994, DataSoft Technologies, Inc. provides staff augmentation services for Information Technology and Automotive Services. Our team member benefits include:Paid Holidays/Paid Time Off (PTO)