Previous Job
Previous
Data/Information Architect - Advanced
Ref No.: 17-29585
Location: Columbia, South Carolina
Job Description: SCOPE OF THE PROJECT:
This work is part of the start-up phase of overlapping information system projects.
• Identify and map existing data / information systems
• Create data schema of existing databases in Database Design software; e.g., Datanamic, ER/Studio, MySQL Workbench, etc.
o Legacy: Sybase, Access, Excel, MySQL
o Developing: PostgreSQL, MongoDB, Neo4j, MySQL
• Develop new DB Schema and physical DB for new Information Systems
• Initial focus will be to translate, enhance and migrate existing schema and data to a new DB. This will be followed by additional enhancement to capture aspects of the legacy system that are not present. This phase may entail creating &/or translating conceptual and logical models to the physical model.
• Generate appropriate documentation for the enterprise data architecture, including glossary definitions suitable for business level consumption

DAILY DUTIES / RESPONSIBILITIES:
Work with team to
• Document existing Database(s)
• Document, cull, and generate schema from current database(s) using SQL and DB tool(s)
o Clean and validate data
o Generate anomaly reports for others to act upon
• Analyze, design and document updated DB schema with industry standard features and create a map from current to new DB
• Design, implement and test migration from current DB to the new DB; scheduled migration update
• Assist other DB staff with similar duties
• Document tasks and provide up-to-date status through the project collaboration tools
• Assist and develop SQL views for forms and reports

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• Accounting & Financial knowledge & experience in connection with DB and application development
• Database experience (5 years min.) of at least two (2) databases
o MySQL
o Sybase or MS SQL Server
o Other
• Database tools, at least one of the following (1-year min.)
o ER/Studio
o MySQL Workbench
o TOAD
o or equivalent
• Experience implementing up-to-date industry standard procedures and schemas for the majority of the following:
o Naming conventions
o Revising DB schemas for consistent use of terminology, naming, etc.
o Update history
o Logging
o HIPAA compliance
o Security and access control
o Data exchange protocols
o Cross platform integration
• Strong knowledge and use of SQL; multi table JOINS, functions, procedures, triggers, etc.
• Experience creating SQL views for the foundation of reports and forms; anticipate needs of coders/programmers
• Excellent listening and communication (written & verbal) skills; ability to discuss and present information logically and concisely
• Ability to work individually and as part of a team. Willing to share knowledge & experience with others
• Flexible problem solver; use of previous knowledge & experience, yet open to alternative methods when made available

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• Additional Database tools experience; e.g.
o Datanamic tool Suite
o ER/Studio, ErWin, etc.
• Experience with Data Governance and related documentation requirements
• Database experience
o Sybase
o PostgreSQL
o MS Access
o MongoDB (document DB, nice bonus)
o Neo4j (Graph DB, nice bonus)
• Experience with Platforms as a Service (PaaS) and Software as a Service (SaaS)
o Data transfers, APIs, etc.
o Data integration across systems
• Knowledge of container technology
• Survey application DB schema with update history capacity
• Open Source development experience; e.g., Python, PHP, JavaScript, & other Web coding
• Experience with disconnected (store & forward) database applications

REQUIRED EDUCATION/CERTIFICATIONS:
Bachelor of Science; BA may be considered

PREFERRED EDUCATION/CERTIFICATIONS:
Master of Science or PhD

NOTE: Remote work based upon the candidate's knowledge, skills, and abilities. Resource will be expecting to work onsite. Once onsite the remote piece will be accessed. However, could be 4 days a week remote with one day a week onsite. This is to be determined.
Category
Name
Required
Importance
Level
Last Used
Experience
Database Platforms mysql Yes 1
Database Platforms Relational Database Experience Yes 1 Expert
Database Platforms postgresql No 1
Database Platforms Schema design including the appropriate implementation of database access security protocols into reporting program code. No 1
Database Platforms Sybase No 1
Database Platforms Understanding of database scalability and operations No 1
Development Tools MS Excel Yes 1
Development Tools MS Word Yes 1
Development Tools UML No 2
Documentation/Language Development of Structured Written Materials Yes 1
Financial • Experience in financial systems (AR, AP, payment reductions, general ledger postings and reporting, etc.); Yes 1
Financial Knowledge of relevant financial regulations and policies Yes 1
Miscellaneous ABILITY TO DEVELOP, COMMUNICATE AND PRESENT PROJECT DOCUMENTATION AND REPORTS No 1
Miscellaneous Project Methodology No 2
Miscellaneous Project Planning No 2
Miscellaneous Related Enterprise Level Experience No 1
Programming Languages SQL Databases Yes 1 Expert
Programming Languages Relevant programming languages and scripting tools. No 1
Specialties Data Modeling Yes 1 Expert
Specialties Experienced Data Architect with extensive Experience performing Data Modeling, data mapping, data cleansing, and building data dictionaries. Yes 1 Advanced
Specialties Expertise of data governance/data stewardship principles, polices, processes, implementation, and tools Yes 1 Advanced
Specialties ABILITY TO CONCEPTUALIZE NEEDED CHANGE AND INITIATE APPROPRIATE ACTIVITIES TO MOVE FROM CONCEPTS TO IMPLEMENTATION No 1
Specialties Architecture No 1
Specialties Documentation No 1 Advanced
Specialties Experience gained through numerous Full Life Cycle Data Architecture projects No 2
Specialties Experience in developing and maintaining documentation for policies, procedures, and best practices No 1
Specialties Experience with security and data classification related to CDC, HIPAA, and CJIS No 1
Additional Skills: - Experience with Data modeling, design, & development tools; e.g., ER/Studio


Attached Document 1:



Statement of Work (SOW) for Contingent Labor Request

Team Size:
Small Teams (2 – 8)
Dress Code:
Business Attire / Casual on site
Primary Work Location:
Remote
Secondary Work Location:
LGOA – Columbia, SC for meetings
# of Openings

1
How Many resumes do you want to review at one time?
Based on State contract
Company / Department culture (why do you enjoy working for the company – selling points for potential candidates):
  • Project work seeks to use best of breed tools, technology, and methodology
  • Problem solving that leads to tangible results at multiple levels; e.g. business processes & organizational productivity, cost savings throughout the state, better services (lives enhanced) for clients throughout the state
Why is this position open (new role, increased work load, new dept, resignation, promotion)?
If backfill Position – What separated the candidate you initially selected from all the other resumes presented?
  • The position(s) are for an Information Systems project initiative that is ramping up for full-time status.
  • New position(s)
What types of staffing challenges or headaches have you experienced in the past?
  • Resume's embellished
  • Candidates not vetted well at the first stage of the hiring process
  • Excessive number of resume pages with detail not pertinent to the work at hand; which slows down the hiring process
Scope of the project:
This work is part of the start-up phase of overlapping information system projects.
  • Identify and map existing data / information systems
  • Create data schema of existing databases in Database Design software; e.g., Datanamic, ER/Studio, MySQL Workbench, etc.
    • Legacy: Sybase, Access, Excel, MySQL
    • Developing: PostgreSQL, MongoDB, Neo4j, MySQL
  • Develop new DB Schema and physical DB for new Information Systems
  • Initial focus will be to translate, enhance and migrate existing schema and data to a new DB. This will be followed by additional enhancement to capture aspects of the legacy system that are not present. This phase may entail creating &/or translating conceptual and logical models to the physical model.
  • Generate appropriate documentation for the enterprise data architecture, including glossary definitions suitable for business level consumption

Position Title: Database Analyst / Architect
EST. Start Date:
Dec 19, 2017
EST. Duration:
3 Months or more
Possibility of Extension?
Yes or NO
MAX Bill Rate:
not to exceed contract
Public Sector/Gov't Experience Required?
Yes or NO
REMOTE WORK POSSIBILITY YES OR NO?

Est. 75 % remote
estimated budget:
NA
Pre-employment Checks (drug, credit, criminal, motor vehicle)?
Based on State contract: credit, criminal, and e-Verify


Daily Duties / Responsibilities:

Work with team to
  • Document existing Database(s)
  • Document, cull, and generate schema from current database(s) using SQL and DB tool(s)
    • Clean and validate data
    • Generate anomaly reports for others to act upon
  • Analyze, design and document updated DB schema with industry standard features and create a map from current to new DB
  • Design, implement and test migration from current DB to the new DB; scheduled migration update
  • Assist other DB staff with similar duties
  • Document tasks and provide up-to-date status through the project collaboration tools
  • Assist and develop SQL views for forms and reports

NOTE: Remote work based upon the candidate's knowledge, skills, and abilities. Resource will be expecting to work onsite. Once onsite the remote piece will be accessed. However, could be 4 days a week remote with one day a week onsite. This is to be determined.
Required Skills (rank in order of Importance):
  • Accounting & Financial knowledge & experience in connection with DB and application development
  • Database experience (5 years min.) of at least two (2) databases
    • MySQL
    • Sybase or MS SQL Server
    • Other
  • Database tools, at least one of the following (1-year min.)
    • ER/Studio
    • MySQL Workbench
    • or equivalent
  • Experience implementing up-to-date industry standard procedures and schemas for the majority of the following:
    • Naming conventions
    • Revising DB schemas for consistent use of terminology, naming, etc.
    • Update history
    • Logging
    • HIPAA compliance
    • Security and access control
    • Data exchange protocols
    • Cross platform integration
  • Strong knowledge and use of SQL; multi table JOINS, functions, procedures, triggers, etc.
  • Experience creating SQL views for the foundation of reports and forms; anticipate needs of coders/programmers
  • Excellent listening and communication (written & verbal) skills; ability to discuss and present information logically and concisely
  • Ability to work individually and as part of a team. Willing to share knowledge & experience with others
  • Flexible problem solver; use of previous knowledge & experience, yet open to alternative methods when made available
Preferred Skills (rank in order of Importance):
  • Additional Database tools experience; e.g.
    • Datanamic tool Suite
    • ER/Studio, ErWin, etc.
  • Experience with Data Governance and related documentation requirements
  • Database experience
    • Sybase
    • PostgreSQL
    • MS Access
    • MongoDB (document DB, nice bonus)
    • Neo4j (Graph DB, nice bonus)
  • Experience with Platforms as a Service (PaaS) and Software as a Service (SaaS)
    • Data transfers, APIs, etc.
    • Data integration across systems
  • Knowledge of container technology
  • Survey application DB schema with update history capacity
  • Open Source development experience; e.g., Python, PHP, JavaScript, & other Web coding
  • Experience with disconnected (store & forward) database applications




Required Education/Certifications:
Bachelor of Science; BA may be considered
Preferred Education/Certifications:
Master of Science or PhD
Interview Process (phone, video or in-person, how many rounds of i/v's, etc)?
  • Phone
  • In-person

Interview Availability: How soon can you schedule an interview (date / times)?
once qualified resumes have been received.