Certified Woman & Minority Owned

Data/Information Architect


Reference Number: LSSCDA257

Data/Information Architect
experience  Not Disclosed
location  COLUMBIA, SC
duration  12.0 Months
salary  Not Disclosed
jobtype  Not Disclosed
Industry  Government - State
Job Description

Job Description:
SCOPE OF THE PROJECT:

DEVELOP AND DELIVER DASHBOARDS, MAINTAIN AND UPDATE DATABASE, ASSIST WITH ADDITIONAL RESEARCH PROJECTS REQUIRING AUTOMATION AND/OR CODING FOR REPLICATION

Daily Duties / Responsibilities:

• Design Dashboards, Reports, Graphs, Maps and Scorecards using tableau, bip, obiee and ssrs tools
• design databases and design ETL process to update the databases
• create report requirement documents/templates
• test and validate the reports
• Work in UI to run daily/weekly/monthly/quarterly reports for Benefits, as well as adhoc data requests. Develops dashboards, maintains and updates databases, assist with additional research projects requiring automation and/or coding for replication.
• Work with Collections to run daily/weekly/monthly/quarterly reports for Collections of Benefit and Tax programs, as well as adhoc data requests.
• Work with indirect service in other departments, units or client special project with staff from Communications, Legal, Workforce Development, or LMI divisions on adhoc data requests for SUITS, SCUBI and client PATH Databases. Work on ASRs that are more complex with the transition of reporting functionality development with client IT.
• Experience with all the client databases – SUITS, UI, SC Path, VOS, WID, Employment and report development using reporting tools Tableau, SSRS and Power BI. Work will include service to integrity efforts for reports, analysis and development.
• Expectation is for the vendor to complete weekly timesheets and submit an invoice through the beeline application with detail work associated to grants work performed daily. There are will be daily in person or TEAMS check-in and activity updates with UI Technical Service team members on reports and projects while reporting directly to the Director of Technical Services.
• Timesheet and invoices sent to the UI Technical Service Director will provide details for time approval through On Base. Work schedule for 8 hours every day with standard 8:30am to 5:00pm. Daily work will include weekends/holidays/ early or after hours as needed. The schedule is flexible to allow for these out of hours times of service for timely completion of need report data.

Required Skills (rank in order of Importance):

• Experience working with SQL Server, Oracle databases
• Expertise in dashboards/Reports design using Tableau, OBIEE and SSRS/SSAS reporting tools
• Experience in data migration skills using SSIS
• Working Experience with UI Claims

Preferred Skills (rank in order of Importance):
• Nice to have experience with AWS and Azure cloud network
• Nice to have develop code using T-SQl,PL/SQL and c#

REQUIRED EDUCATION: BACHELOR’S DEGREE


Skills: Category - Name - Required - Importance - Level - Last Used - Experience
Database Platforms - Demonstrate practical understanding of ORACLE database physical structure, overall architecture, and database performance analysis - Yes - 1 - - -
Database Platforms - SQL Server - Yes - 1 - - -
Database Platforms - SQL Server Integration Services (SSIS) - Yes - 1 - - -
Database Platforms - SQL Server Reporting Services (SSRS) - Yes - 1 - - -
Education - Bachelor’s degree in a technical or business field - Yes - 1 - - -
Miscellaneous - Dashboards and Reports - Yes - 1 - - -
Programming Languages - RDLC (SSRS) Reporting - Yes - 1 - - -
Specialties - Unemployment insurance systems/business experience - Yes - 1 - - -


Remote Work Availability: 25%
VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status

Apply for this Job





(Please ensure email matches your resume email)



(document types allowed: doc/docx/rtf/pdf/txt) (max 2MB)

Join VIVA and grow

VIVA is faster, easier and you still have complete control