On Site Senior Data Architect (/Databricks/ Data modeling; Snowflake; data governance; SQL Server/Oracle/PostgreSQL; Power BI)

Each staff member assigned to this project must have a background screening that is equivalent to a Level Two (2) screening standard.

This is a fixed fee/hourly based project which is inclusive of travel, lodging, per diem expenses and all other costs associated with the completion of the associated tasks.

Interviews: 
In the event an interview is requested; all interviews will be conducted via web Cam. 

Telecommuting: 
Not allowed for this position.

Scope of Work
    The Contractor shall provide Information Technology (IT) staff augmentation services in support of the Department's Office of Information Technology (OIT). The Contractor must propose at least one qualified Data Architect in its Response who in the Department's sole discretion has the experience and ability to fulfill the requirements of this Scope of Work (SOW). The Department may fill one or multiple positions from this RFQ based on experience and ability to fulfill the requirements of this Scope of Work (SOW).

Reporting and Key Responsibilities

The Data Architect will report to the Application Development and Support Manager, as well as the designated Contract Manager, on an ongoing basis. Key responsibilities include:

    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.

The Data Architect applies accepted data content standards to technology projects and plays a critical role in maintaining the integrity and efficiency of organizational data systems.

Activities and Tasks

The Data Architect will provide, but not be limited to, the following activities and tasks.

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.

Contract Deliverables

Contractor's Data Architect shall perform the tasks listed above. 

    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: A document defining the folder structures, file formats, compression standards, and partitioning strategies across ADLS Gen2 landing, staging, and curated zones.
    Source-to-Target Mapping (STTM) Matrix: A granular spreadsheet detailing source systems, target tables, column-level transformations, business logic, data types, and refresh frequencies.
    Pipeline Design Templates: Standardized design specs or code templates for Azure Data Factory (ADF) pipelines, Change Data Capture (CDC) frameworks, and error-handling/logging modules.
    Interface Control Documents (ICD): Specifications outlining API endpoints, streaming topic schemas (Event Hubs/Kafka), and file exchange formats for third-party integrations.
    Data Security & Privacy Matrix: A detailed document mapping Role-Based Access Control (RBAC), Object-Level Security (OLS), and Row-Level Security (RLS) policies to Entra ID user groups.
    Data Protection & Encryption Specification: Documentation detailing Key Vault integrations, secret management procedures, Customer-Managed Key (CMK) configurations, and network isolation specs (Private Endpoints).
    Compliance & Data Lifecycle Policy: Policy documentation defining data retention schedules, automated ADLS Gen2 lifecycle rules (Hot to Archive tiering), and masking requirements for PII/sensitive data.
    Microsoft Purview Configuration & Lineage Map: An active, populated Purview data catalog featuring registered data sources, automated scan schedules, custom data classifications, and end-to-end data lineage diagrams.
    Enterprise Data Dictionary & Business Glossary: Standardized business definitions, metadata tags, sensitivity labels, and data ownership matrices assigned within the governance platform.
    Data Quality Framework & SLA Specs: Formal definitions of data quality rules, validation thresholds, alert thresholds, and Service Level Agreements (SLAs) for critical data assets.
    Infrastructure-as-Code (IaC) Templates: Bicep, ARM, or Terraform scripts stored in version control for automated deployment of all data infrastructure across Dev, Test, and Prod.
    FinOps & Cost Management Plan: A resource estimation report establishing tagging strategies, cluster auto-scaling limits, serverless thresholds, and projected monthly Azure burn rates.
    Operational Readiness & Runbook Document: Handover documentation detailing deployment guides, CI/CD pipeline structures, monitoring dashboards (Azure Monitor/Log Analytics), and incident triage workflows for DataOps and Support teams.
    Time Reports: A report detailing the tasks worked each day and the hours spent on each task. The Contractor shall submit this report to the Department's Contract Manager no later than the 5th day of the month that follows the month for which the total hours worked are being submitted via a mutually agreed upon timesheet.
    Project Related Deliverables: Project artifacts as assigned to the Data Architect per the project plan. This can include, as an example, technical documentation, system instructions, process and procedure documentation. The Project Related Deliverable documentation must be satisfactorily completed within the response time specified by project plan and accepted by the Department's Contract Manager.
    Additional Documentation: Any additional documentation required by the Department's Contract Manager, which must be submitted within the timeframe specified by the Department's Contract Manager.

Note: A Contractor Data Architect with access to the Department's network is required to complete the Department's security awareness training. This training must be completed within fifteen (15) calendar days of the Contractor Data Architect's start date.

Qualification Requirements for Data Architect

The Data Architect candidate(s) submitted by the Contractor to provide these staff augmentation services must possess the following minimum qualifications and experience:

    Minimum of 13-15 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.
    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 13-15 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 Qualifications

The Data Architect candidate(s) submitted by the Contractor to provide these staff augmentation services may possess the following preferred qualifications and 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.

Education: Bachelor’s Degree in Computer Science, Information Systems or other related field. Or equivalent work experience.

Resume for One Proposed Consultant - Resume Should have the following information :
- Name
- All work experience related to the CLIENT’s request for service
- Sufficient detail for CLIENT to determine dates of the related work experience, how extensive the related work experience is, and the depth of knowledge and skills of the proposed candidate related to the needs of CLIENT
- Candidate Education
- Professional Summary
- Technical Skills
- Work Experience

"When replying please make sure to list your (All Inclusive) Compensation requirements !!!"

Note : This is a Full time ON SITE Contract Position with no REMOTE options allowed !!

Start date : Nov 2026

# OF POSITIONS : 1

No phone calls please.
Local Citizens are encouraged to Apply
No relocation assistance provided.
ONLY Candidates with an exact match will be contacted
Candidates should be authorized to work in the US.