Onsite/Local Govt Data Architect (15+)

InnoSoul•Tallahassee, FL

16h•Onsite

About The Position

The Department of State (DOS) is seeking an experienced Data Architect to be responsible for enterprise-wide data design, balancing the optimization of data access with batch loading and resource utilization factors. This role requires expertise in designing and constructing data architectures, operational data stores, and data marts, with a focus on enterprise-wide data modeling and database design. The Data Architect will define data architecture standards, policies, and procedures, and apply accepted data content standards to technology projects. Responsibilities also include business analysis, data acquisition and access analysis/design, Database Management Systems optimization, and recovery/load strategy design and implementation. This position involves working on multiple complex projects, potentially as a project leader or subject matter expert, and coaching junior technical staff. The Consultant will follow Department IT processes, coordinate with IT staff, and work closely with other IT groups and customers to define needs and objectives. Tasks include analyzing and assessing network infrastructure, recommending policies, maintaining SQL database tables, creating queries, writing shell scripts for automation, analyzing business procedures, developing data models, identifying data migration opportunities, analyzing and developing queries for case work reconciliation, identifying trends in data sets, serving as the data processing administrator, providing data resources, designing ad-hoc reporting, and creating technical documentation. This project is located in Tallahassee, FL, and does not require travel outside of the city.

Requirements

A minimum of 7 years of experience with large and complex database management systems.
Bachelors or Masters Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
SQL
Database Management Systems
Data Modeling/Architecture/Design
Shell Scripting
Operational data stores/marts experience

Responsibilities

Responsible for enterprise-wide data design, balancing optimization of data access with batch loading and resource utilization factors.
Knowledgeable in most aspects of designing and constructing data architectures, operational data stores, and data marts.
Focuses on enterprise-wide data modeling and database design.
Defines data architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements, and applies accepted data content standards to technology projects.
Responsible for business analysis, data acquisition and access analysis and design, Database Management Systems optimization, recovery strategy and load strategy design and implementation.
Works on multiple projects as a project leader or as the subject matter expert.
Works on projects/issues of high complexity that require in-depth knowledge across multiple technical areas and business segments.
Coaches and mentors more junior technical staff.
Follow Department IT processes and coordinate with other Department IT staff to ensure compliance with Department standards.
Works closely with other IT groups and customers to define customer needs and objectives.
Analyze and assess the Departments network infrastructure and operations.
Recommend and implement policies and procedures for the day-to-day operations.
Maintain SQL database tables to track electronic records, case files and outgoing document requests.
Create queries and accurately interpret multiple data sets.
Write shell scripts to automate repetitive tasks in order to streamline workflow; transform specialized data into formatted reports.
Analyze business procedures and recommend specific types of data to improve processes.
Develop conceptual and logical data models, data collection systems, data analytics and other strategies to optimize statistical efficiency.
Identify and implement data migrations and case management system tuning; evaluates for new or upgraded operating systems; assists in the development of a comprehensive long-range plan to meet departmental bureau system requirements.
Analyze and develop queries in various technical systems to complete reconciliation of OECS case work.
Identify and analyze trends or patterns in complex data sets.
Serve as the data processing administrator for all OECS intake data from various entities and complainants.
Provide OECS staff with data resources from election related databases needed for case intake, investigation and management.
Design and deliver ad-hoc reporting for the OECS.
Create Technical Design Documentation, Process flow Diagrams, Data Flow Diagrams.
Cultivate end-user interaction, requirement gathering, and development as per functional specifications.