Data Architect (10/21)

Job Title: Data Architect
Job Location: Tallahassee, FL (hybrid)
Job Duration: Contract through June+
Key Responsibilities:

• Establishing data architecture standards, policies and procedures for the organization, including the structure attributes, and nomenclature of data elements.


• Ensuring compliance and security across all data-related activities.


• Supporting application rollouts and selecting appropriate tools for data management.


• Managing data quality and leading data management practices.


• Collaborating with cross-functional teams to drive effective data solutions.


• Conducting business analysis, data acquisition, and access analysis and design.


• Optimizing Database Management Systems, designing and implementing recovery and load strategies

Strategic Planning and Vision.

• Develop and deliver long-term goals for data architecture, aligning with department objectives.


• Create tactical solutions and a data management roadmap to achieve strategic aims.


• Establish governance processes for metadata, ensuring accuracy and validity.


• Set up methods for tracking data quality, completeness, redundancy, and improvement.


• Conduct capacity planning, lifecycle management, feasibility studies, and usage analysis.


• Design strategies for data security, backup, disaster recovery, business continuity, and archiving.


• Ensure compliance with regulatory requirements.

Acquisition and Deployment.

• Support enterprise-level application rollouts (ERP, CRM, SCM, SAP, PeopleSoft, etc).


• Liaise with vendors and service providers to select products/services that meet department goals.

Operational Management.

• Assess and determine frameworks for data governance and stewardship.


• Develop and promote data management methodologies and standards.


• Select and implement tools, software, applications, and systems to support data technology goals.


• Oversee mapping of data sources, movement, interfaces, and analytics to ensure quality and performance.


• Collaborate with project managers and business unit leaders on projects involving enterprise data.


• Address data-related problems in systems integration, compatibility, and multi-platform integration.


• Lead and advocate for data management, including coaching and training with the development team.


• Develop and implement testing criteria to guarantee fidelity and performance of data architecture.


• Document the data architecture and environment for an accurate view of the data landscape.


• Identify and develop opportunities for data reuse, migration, or retirement.


• Produce documentation and contribute to Enterprise data management initiatives.

Deliverables:

• Solution Architecture Document (SAD): The primary blueprint detailing the end-to-end data platform architecture, service selection rationales, data flows, and system boundaries.


• Architecture Decision Records (ADRs): Short, structured documents capturing key technical decisions (e.g., choosing Azure Databricks over Synapse Spark), including context, considered alternatives, and consequences.


• Target State Architecture Blueprint: Visual diagrams created in tools like Visio or Lucidchart illustrating landing zones, compute layers, data lakes, and consumption endpoints using official Azure architecture icons.


• Data Model Diagrams (ERDs): Conceptual, logical, and physical entity-relationship diagrams covering relational warehouses (Star/Snowflake schemas) and NoSQL collections.


• Database DDL Scripts: Production-ready SQL scripts or Schema Definitions (JSON/Parquet/Delta) defining tables, indexes, constraints, and distribution strategies.


• Data Lake Taxonomy & Directory Specification:


• Source-to-Target Mapping (STTM) Matrix:


• Pipeline Design Templates:


• Interface Control Documents (ICD):


• Data Security & Privacy Matrix:


• Data Protection & Encryption Specification:


• Compliance & Data Lifecycle Policy:


• Microsoft Purview Configuration & Lineage Map:


• Enterprise Data Dictionary & Business Glossary:


• Data Quality Framework & SLA Specs:


• Infrastructure-as-Code (IaC) Templates:


• FinOps & Cost Management Plan:


• Operational Readiness & Runbook Document:

Required Experience:

• Minimum of 7 years of experience with large and complex database management systems.


• Hands-on experience with data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis.


• Direct experience in 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 tools, data modeling tools, data mapping tools, and data profiling tools.


• Demonstrated experience with repository creation and data information system life cycle methodologies.


• Experience with business requirements analysis, entity relationship planning, database design, and reporting structures.


• Ability to manage data and metadata migration.


• Experience with database platforms, including Microsoft Azure SQL Database, Snowflake, MySQL, PostgreSQL, Microsoft SQL Server, and Oracle Database.


• Understanding of Web Services (SOAP, XML, UDDI, WSDL).


• Objector-oriented programming experience (e.g. using Java, J2EE, EJB, .NET, Websphere, etc).


• Excellent client/user interaction skills to determine requirements.


• Power BI Platform services


• Experience with data processing flowcharting techniques.


• On-site availability at the Department's location 4040 Esplanade Way, Tallahassee, Florida is required. Remote work may be considered on an occasional, ad-hoc basis, subject to prior written approval from the Contract Manager. This arrangement is intended for intermittent use only and does not constitute a permanent or hybrid remote work schedule. Travel costs will not be reimbursed.


• Educational and Work Experience Requirements. The Contractor Data Architect, and any subsequent Contractor Data Architect provided by the Contractor, must possess, the following:


• Bachelor's or Master's degree in computer science, Information Systems, or other related fields, or equivalent work experience.


• A minimum of 7 years of experience with large and complex database management systems.


• Expertise in technical writing and documentation.


• Competency in document version control and collaborative document management.

Preferred Experience:

• Experience with Florida State Agency IT Projects.


• FLAIR (Florida Accounting Information Resource) data transfers and transformation for internal Department accounting systems.


• PALM (Planning, Accounting, and Ledger Management) data transfers and transformation for internal Department accounting systems.


• Snowflake pipeline creation


• TeamDynamix iPaaS


• Power BI platform services

Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.
Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals. To learn more, please visit .
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.