Data Architect (onsite)

Vitaver & Associates, Inc; Tallahassee (FL); On-site; USD 120,000 - 180,000; Full time

Job summary

Vitaver & Associates, Inc. seeks a Data Architect for a 12+ month project in Tallahassee, FL. This onsite-only role requires relocation and full-time on-site work at the client site. You will design and govern data architectures, models, and migrations to support enterprise analytics and operations.

Candidate will lead data management efforts, ensure compliance, and collaborate with cross-functional teams to implement robust data pipelines using Azure, Snowflake, and related tech.

Qualifications

• 7+ years of experience with large and complex database systems.
• Data architecting, data mining, and large-scale data modeling.
• Experience implementing enterprise data management processes.
• Relational data structures and metadata management expertise.
• Experience with enterprise repositories, data mapping, and profiling tools.
• Experience with Azure SQL, Snowflake, MySQL, PostgreSQL, Oracle.
• Experience with Web Services and OO programming.
• Experience with data lifecycle methodologies and documentation.

Responsibilities

• Establish data architecture standards, policies and procedures.
• Ensure compliance and security across data-related activities.
• Support application rollouts and select data management tools.
• Manage data quality and lead data management practices.
• Collaborate with cross-functional teams for data solutions.
• Conduct business analysis, data acquisition, and access design.
• Optimize DBMS with recovery and load strategies.

Skills

Large-scale DBMS

Data modeling

Data governance

ETL / Data pipelines

Azure Data Factory

Snowflake

T-SQL / Azure SQL / Synapse

Data migration

Metadata management

Documentation

UML / ER modeling

BI data modeling (Power BI)

Git / CI-CD pipelines

J2EE / .NET / WebSphere

Tools

Azure Data Factory

Snowflake

T-SQL / Azure SQL / Synapse

ER/Studio / Erwin / SQLDBM

Terraform / Azure DevOps

Azure Key Vault & Entra ID

Purview

Job description

14949 - Data Architect (onsite) - Tallahassee, FL

Start Date: ASAP

Type: Temporary Project

Estimated Duration: 12+ months with possible extensions

Work Setting: 100% of the time at the Client's site. No telecommuting or remote work. This is a non-negotiable requirement from the client.

Only candidates able to relocate as required should apply to avoid removal from future consideration.

Required

• Availability to work 100% of the time at the Client's site in Tallahassee, FL (required).
• Experience with Large and complex database management systems (7+ years).
• Experience in Data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis.
• Experience Implementing enterprise data management processes, procedures, and decision support.
• Experience with Relational data structures, theories, principles, and practices.
• Experience with Metadata management and associated processes.
• Experience with Enterprise repository tools, data modeling tools, data mapping tools, and data profiling tools.
• Experience with Repository creation and data information system life cycle methodologies.
• Experience with Business requirements analysis, entity relationship planning, database design, and reporting structures.
• Experience with Data and metadata migration management.
• Experience with Database platforms, including Microsoft Azure SQL Database, Snowflake, MySQL, PostgreSQL, Microsoft SQL Server, and Oracle Database.
• Experience with Web Services (SOAP, XML, UDDI, WSDL).
• Experience with Object-oriented programming (e.g., Java, J2EE, EJB, .NET, WebSphere).
• Experience with Data processing flowcharting techniques.
• Experience with Technical writing and documentation.
• Experience with Document version control and collaborative document management.
• Experience with Azure Data Factory (ADF) - Pipelines, Mapping Data Flows, Integration Runtimes (Self-Hosted/Azure), CI/CD parameterization, REST API triggers.
• Experience with Snowflake - Multi-cluster virtual warehouses, zero-copy cloning, Snowpipe, Time Travel, RBAC, cost optimization, and micro-partitioning.
• Experience with T-SQL / Azure SQL / Synapse - Complex indexing, execution plan tuning, partitioning, stored procedures, CTEs, dynamic SQL, and window functions.
• Experience with Snowflake (Snowpark & Streams) - Snowpark (Python/Scala) for scalable data engineering and ML; Streams for CDC; Tasks for orchestration; Time Travel & RBAC for governance; credit-aware cost optimization with multi-cluster virtual warehouses.
• Experience with ER/Studio, Erwin, or SQLDBM - Conceptual, Logical, and Physical data modeling; Kimball Dimensional Modeling; Data Vault 2.0 methodology.
• Experience with Terraform / Azure DevOps - Infrastructure as Code (IaC) for Azure resources, YAML build/release pipelines, Git workflow management.
• Experience with Azure Key Vault & Entra ID - Private Endpoints, Managed Identities, Role-Based Access Control (RBAC), column/row-level encryption.
• Experience with Managed Identity, Key Vault, and RBAC - Securing data at rest and in transit while maintaining automated lineage via Purview.

Preferred

• Experience with Florida State Agency IT Projects.
• Experience with FLAIR (Florida Accounting Information Resource) data transfers and transformation for internal accounting systems.
• Experience with PALM (Planning, Accounting, and Ledger Management) data transfers and transformation for internal accounting systems.
• Experience with Snowflake pipeline creation.
• Experience with TeamDynamix iPaaS.
• Experience with Power BI platform services - DAX, Star Schema modeling, Composite Models, DirectQuery over Snowflake/Synapse, Row-Level Security (RLS), Service Admin.
• Experience with Azure Data Lake Storage (ADLS Gen2) - Delta Lake format, POSIX access control lists, Lifecycle Management policies, hierarchical namespaces, and zone partitioning.
• Experience with Microsoft Purview - Automated lineage tracking, data classification rules, business glossary mapping, and access governance policies.
• Experience with Semantic Layering (Star/Snowflake schemas) - Designing enterprise dimensional models optimized for high-performance Power BI DirectQuery and Import models.
• Experience with Storage & Warehouse Optimization - Structuring ADLS Gen2 landing, bronze, silver, and gold zones; configuring Snowflake warehouses for optimal performance and credit control.
• Experience with End-to-End Pipeline Design - Architecting resilient ingestion patterns using ADF for batch loads and Event Hubs for real-time; landing to Snowflake via Snowpipe and Streams, orchestration with Snowflake Tasks and monitoring via query history.

Responsibilities

• Establish data architecture standards, policies and procedures for the organization, including the structure, attributes, and nomenclature of data elements.
• Ensure compliance and security across all data-related activities.
• Support application rollouts and select appropriate tools for data management.
• Manage data quality and lead data management practices.
• Collaborate with cross-functional teams to drive effective data solutions.
• Conduct business analysis, data acquisition, and access analysis and design.
• Optimize Database Management Systems, designing and implementing recovery and load strategies.