Data Architect Part-Time

PSR Associates is a consulting and talent solutions firm that connects qualified IT professionals with great opportunities. Whether you're looking for a contract or permanent position, we can help you find the right fit for your skills and experience. We have a team of experienced recruiters who know the IT industry inside and out, and we work with you every step of the way to ensure a smooth and successful transition. PSR Connecting Talent, Crafting Success.

Data Architect (Part Time) Position Description

We are seeking a Data Architect to join our team. The selected candidate will work 20 hours each week on a hybrid schedule consisting of three (3) days each week onsite in Tallahassee, FL.

Summary:

As part of the Department's ongoing efforts to modernize and re-engineer core financial systems, over 1,500 computing assets have been identified as supporting various financial planning, analysis, and management functions. These assets are impacted by the State of Florida's accounting system changes under the Florida Planning, Accounting, and Ledger Management (PALM) project. Florida PALM is a multiyear initiative aimed at replacing the State of Florida's existing accounting and cash management systems with a modern financial management solution. The project will replace Central, Payroll, and Departmental FLAIR functionality, with go-live scheduled for January 6, 2026.

The 1,500+ computing assets consist of interfaces, enterprise applications, databases, automated processes, and reporting programs within the department. These assets require remediation due to:

Adoption of the Florida PALM Standardized Business Process Model.

Transition to the Florida PALM Chart of Accounts values.

Replacement of Central, Payroll, and Departmental FLAIR functionality.

Redevelopment of agency interfaces to the statewide accounting system.

Implementation of Information Warehouse data to support agency-specific reporting requirements.

The PALM System Transition (FPST) will take place over two years in alignment with the Florida PALM Project timeline. The successful candidate will assist in guiding the transition to the PALM system, which involves reviewing as-is business processes, remediation strategies, reengineering, design, and integration with FM financial systems. Ensuring compatibility with cloud architecture is a key objective, aligning with the state s cloud-first policy. The role focuses on the analysis and remediation of data marts and models within the Office of Work Program and Budget (OWPB) and verifying compatibility with data once provisioned within the agency from the Florida PALM system.

Scope:

Data Analysis and Impact Assessment:

Analyze and verify existing Work Program Datamart and General Ledger data models to assess impacts related to changes in Chart of Account data elements due to the Florida PALM Project.

Evaluate the existing data models for dependencies on current Chart of Account structures and assess the scope of necessary changes.

Conduct impact analysis on reporting and application usage of data models to ensure business outcomes are not disrupted by the transition to PALM.

Data Model Design and Enhancement:

Provide a comprehensive design of data models, incorporating new Chart of Account data elements introduced by the PALM system.

Ensure that the redesigned data models are scalable, robust, and aligned with best practices in data management, supporting both current and future business needs.

Data Quality and ETL Process Improvement:

Analyze existing ETL (Extract, Transform, Load) jobs to identify inefficiencies and potential areas for enhancement.

Design and implement robust data quality measures to ensure the timeliness, accuracy, and completeness of production data on a scheduled basis, including nightly, hourly, or less frequent intervals as needed.

Collaborate with development teams to automate and streamline ETL processes to support efficient data flow and integration.

Data Visualization and Reporting Best Practices:

Provide expertise in data visualization and reporting, offering best practices to support the business s ability to analyze and interpret financial data effectively.

Develop strategies to enhance existing reporting frameworks, ensuring that they are compatible with the new data models and data structures.

Collaboration and Deployment:

Work closely with existing development teams to deploy new and revised data models, verifying that the implementation aligns with functional requirements and business goals.

Act as a liaison between technical and non-technical stakeholders, ensuring clear communication regarding data model changes, system impacts, and timelines.

Technical Leadership and Strategic Support:

Collaborate with OWPB leadership and the Office of Information Technology (Client) to develop tactical strategies for the planning, design, implementation, and maintenance of data warehousing initiatives.

Provide guidance on high-level design choices and technical standards, including software coding standards, tools, and platforms.

Act as an internal consultant, mentor, and advocate to team members, supporting ongoing improvements and change management initiatives across the OWPB computing assets.

Deliverables:

Comprehensive assessment report on current Work Program Datamart and General Ledger data models.

Enhanced data model designs integrating Florida PALM Chart of Account updates.

Thorough documentation on data quality measures and ETL process enhancements.

Guidelines on best practices for data visualization and reporting.

Detailed implementation plan for the deployment and verification of new data models.

Consistent updates and presentations to stakeholders on project progress and key insights.

The candidate will play a pivotal role in ensuring that the transition to the Florida PALM system is smooth, efficient, and aligned with the strategic objectives of the department, supporting the modernization of financial management processes and data architecture.

Education

Bachelor s or master s degree in computer science, Information Systems, or other related field. Work experience can substitute on a year for year basis for the degree.

Experience

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

A minimum of 7 years of experience as a data architect or senior data analyst, with extensive experience in designing, implementing, and maintaining data models and ETL processes.

10+ years of broad experience working with database management systems (such as Oracle, SQL Server, or DB2) and data integration tools.

Strong background in financial data systems, including data modeling, data governance, and data quality management.

Proven experience with ETL tools, data warehousing, and automation of data processes to ensure accuracy, .