Data Architect

Nexiva•Tallahassee, FL

3d•Onsite

About The Position

The Data Architect develops and delivers long-term data architecture goals aligned with department objectives, creates tactical solutions and a data management roadmap, and establishes governance processes for metadata and data quality. The role includes capacity planning, lifecycle management, feasibility studies, usage analysis, and strategies for data security, backup, disaster recovery, business continuity, archiving, and regulatory compliance. The architect supports enterprise application rollouts and works with vendors and service providers to select suitable products. They establish data governance and stewardship frameworks, promote data management methodologies and standards, select and implement supporting tools and systems, and oversee data-source mapping, movement, interfaces, and analytics. The role also addresses integration and compatibility issues, collaborates with project managers and business leaders, coaches and trains development teams, defines testing criteria, documents the data environment, and identifies opportunities for reuse, migration, or retirement. The contractor performs assigned work in one-hour increments at the fixed hourly rate specified in the RFQ price sheet and provides evidence of performance through required documentation. Deliverables may include architecture documents and diagrams, data models and database scripts, data lake specifications, mappings and pipeline designs, interface and security specifications, compliance and lifecycle policies, data catalog and lineage materials, data dictionaries, quality frameworks, infrastructure-as-code templates, cost plans, operational runbooks, time reports, and other project artifacts. Documentation must be compatible with MS Office 2013 or newer and be completed and accepted within the applicable response time or project plan. The position is based onsite at the Department's location at 4040 Esplanade Way, Tallahassee, Florida. Occasional, ad-hoc remote work may be considered with prior written approval; this is not a permanent or hybrid schedule. Travel costs will not be reimbursed.

Requirements

At least 7 years of experience with large and complex database management systems.
Hands-on experience with data architecture, data mining, large-scale data modeling, and business requirements gathering and analysis.
Direct experience implementing enterprise data management processes, procedures, and decision support.
Strong understanding of relational data structures, theories, principles, and practices.
Strong familiarity with metadata management and associated processes.
Hands-on knowledge of enterprise repository, data modeling, data mapping, and data profiling tools.
Demonstrated experience with repository creation and data information system lifecycle methodologies.
Experience with business requirements analysis, entity relationship planning, database design, and reporting structures.
Ability to manage data and metadata migration.
Experience with Microsoft Azure SQL Database, Snowflake, MySQL, PostgreSQL, Microsoft SQL Server, and Oracle Database.
Understanding of Web Services, including SOAP, XML, UDDI, and WSDL.
Object-oriented programming experience, such as Java, J2EE, EJB, .NET, or WebSphere.
Excellent client and user interaction skills for determining requirements.
Power BI Platform services experience.
Experience with data processing flowcharting techniques.
Bachelor's or master's degree in computer science, information systems, or a related field, or equivalent work experience.
Expertise in technical writing and documentation.
Competency in document version control and collaborative document management.
Must be available to work onsite at 4040 Esplanade Way, Tallahassee, Florida; any occasional remote work requires prior written approval.
Candidate must be a U.S. citizen or Green Card holder and local to the area.

Nice To Haves

Experience with Florida State Agency IT projects.
Experience with FLAIR data transfers and transformation for internal Department accounting systems.
Experience with PALM data transfers and transformation for internal Department accounting systems.
Snowflake pipeline creation experience.
TeamDynamix iPaaS experience.
Power BI platform services experience.

Responsibilities

Develop long-term data architecture goals aligned with department objectives and create tactical solutions and a data management roadmap.
Establish metadata governance processes and methods for measuring and improving data quality, completeness, and redundancy.
Conduct capacity planning, lifecycle management, feasibility studies, and usage analysis.
Design strategies for data security, backup, disaster recovery, business continuity, archiving, and regulatory compliance.
Support enterprise application rollouts, including ERP, CRM, SCM, SAP, and PeopleSoft implementations.
Coordinate with vendors and service providers to select products and services that meet department goals.
Assess and establish data governance and stewardship frameworks and promote data management methodologies and standards.
Select and implement tools, software, applications, and systems that support data technology goals.
Oversee mapping of data sources, data movement, interfaces, and analytics to ensure quality and performance.
Collaborate with project managers and business unit leaders on enterprise data projects.
Resolve data-related problems involving systems integration, compatibility, and multi-platform integration.
Advocate for data management and coach and train the development team.
Develop and implement testing criteria to ensure the fidelity and performance of the data architecture.
Document the data architecture and environment to maintain an accurate view of the data landscape.
Identify opportunities for data reuse, migration, or retirement and contribute to enterprise data management initiatives.
Prepare and submit assigned contract and project deliverables, including required documentation and monthly time reports.