Data Architect C - Advanced

Novalink Solutions LLC
4d

About The Position

As part of the Department's ongoing efforts to modernize and re-engineer core financial systems, over 100 computing assets have been identified as supporting various financial planning, analysis, and management functions within the Office of Work Program and Budget (OWPB). 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. These computing assets consist of interfaces, applications, databases, automated processes, and reporting programs within the office. 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 FDOT PALM System Transition (FPST) will take place over the next year 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.

Requirements

  • 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, timeliness, and completeness of data.
  • Experience in data visualization and reporting best practices, with familiarity with tools like Power BI, Tableau, or similar platforms.
  • Familiarity with cloud-based data integration solutions, such as Azure or Snowflake.

Nice To Haves

  • Experience with Informatica, Cloud Data Governance and Catalog, Cloud Data Integration, or other modern data integration platforms.
  • Strong analytical skills and the ability to translate business requirements into technical specifications.
  • Excellent communication and collaboration skills, capable of working effectively with technical and non-technical stakeholders.

Responsibilities

  • Analyze and verify existing data models and interfaces in the Work Program Datamart and General Ledger to assess impacts and identify potential disruptions due to the Florida PALM transition.
  • Design and implement comprehensive data models, integrating new PALM data elements to ensure compatibility with business processes and reporting needs.
  • Review and enhance ETL processes to improve data quality, timeliness, and accuracy, and implement robust data quality measures to maintain high standards of production data.
  • Collaborate with development teams to deploy revised data models, verifying successful implementation and resolving any integration issues.
  • Provide expert guidance on data visualization and reporting, establishing best practices to optimize business insights, and monitor dependencies with interfacing systems to propose remediation where necessary.
  • Act as a liaison between technical teams, business stakeholders, and OIT to ensure clear communication regarding data architecture changes and project timelines.
  • Mentor and provide technical leadership to team members, guiding them on best practices in data integration, architecture, and quality management.
  • Ensure continuous improvement in data processes by defining roadmaps, standardizing methodologies, and collaborating on strategic initiatives.
  • Evaluate and align current data systems with the state’s cloud-first initiative, ensuring data models are scalable and compatible with cloud architecture.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service