Data Architect C - Advanced - 26-01378

Job Description

Job DescriptionJob Title: Data Architect C – Advanced

Location: Tallahassee, FL
Duration: 4 months (with possibility of extension)

Job Summary

The Data Architect C – Advanced will play a critical role in supporting data modernization and financial system transitions related to Florida PALM. This position is responsible for ensuring data model compatibility, maintaining data quality, preserving reporting continuity, and aligning business processes during system transitions. The role requires deep expertise in data architecture, ETL processes, financial data systems, and stakeholder collaboration.

Education

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field

• Relevant work experience may substitute for education on a year-for-year basis

Required Experience

• 7+ years working with large, complex database systems

• 7+ years as a Data Architect or Senior Data Analyst

• 10+ years of experience with DBMS platforms such as Oracle, SQL Server, and DB2

• Strong background in financial data systems

• Extensive experience with ETL tools, data warehousing, and automation

• Experience with data visualization tools (Power BI, Tableau, or similar)

• Familiarity with cloud-based data platforms (Azure, Snowflake, etc.)

Preferred Qualifications

• Experience with Informatica, Cloud Data Governance, or Cloud Data Integration tools

• Strong analytical, documentation, and presentation skills

• Excellent communication skills with both technical and non-technical stakeholders

Primary Job Duties & ResponsibilitiesApplication & System Support

• Provide software support for applications used by the Office of Work Program and Budget (OWPB) following documented procedures and checklists

• Diagnose and resolve basic software issues and escalate complex problems to senior technical staff

• Enter and maintain accurate records in support and issue-tracking systems

• Assist with debugging and troubleshooting mainframe operating systems under supervision

• Support conversion of legacy mainframe reports into modern software solutions

Data Analysis & Impact Assessment

• Analyze existing Work Program Datamart and General Ledger data models

• Assess the impact of Florida PALM Chart of Accounts changes

• Identify system dependencies, risks, and remediation requirements

• Ensure reporting and applications remain functional during system transitions

Data Model Design & Enhancement

• Design and enhance data models incorporating new Florida PALM data elements

• Ensure data models are scalable, robust, and aligned with industry best practices

• Support current and future financial reporting and analytics needs

ETL & Data Quality

• Review and enhance ETL (Extract, Transform, Load) processes

• Implement data quality controls to ensure accuracy, completeness, and timeliness

• Automate and streamline ETL workflows in collaboration with development teams

Reporting & Data Visualization

• Provide best practices for data visualization and reporting frameworks

• Ensure reporting solutions align with updated data models

• Support effective financial analysis and decision-making

Collaboration & Deployment

• Work closely with technical teams to deploy revised data models

• Act as a liaison between technical teams, business stakeholders, and the client

• Communicate architectural changes, impacts, and timelines clearly and effectively

Key Deliverables

• Assessment report of existing data models

• Updated data model designs aligned with Florida PALM

• ETL and data quality documentation

• Data visualization and reporting best-practice guidelines

• Implementation and deployment plan

• Ongoing stakeholder updates and presentations

Core Knowledge, Skills & Abilities (KSAs)Knowledge

• Financial management processes (accounting, general ledger, budgeting)

• Relational and dimensional data modeling

• ETL and data integration platforms

• Data governance, quality, and compliance standards

• Cloud-first architecture strategies

• Data security and privacy standards

Skills

• Advanced SQL and scripting

• Data modeling and impact analysis

• ETL automation and optimization

• Technical documentation

• Stakeholder communication

• Project planning and task prioritization

General KSAs

• Strong written and verbal communication

• Customer service orientation

• Sound decision-making and problem-solving skills

• Flexibility and adaptability to change

• Leadership and mentoring abilities

• Team collaboration and relationship building