Data Architect

Data Architect

Reporting Structure

• 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

• Establish data architecture standards, policies, and procedures for the organization, including the structure, attributes, and nomenclature of data elements.
• Ensure compliance and security across all data-related activities.
• Support application rollouts and select appropriate tools for data management.
• Manage data quality and lead data management practices.
• Collaborate with cross-functional teams to drive effective data solutions.
• Conduct business analysis, data acquisition, and access analysis and design.
• Optimize Database Management Systems and design and implement recovery and load strategies.
• Apply accepted data content standards to technology projects.
• Play a critical role in maintaining the integrity and efficiency of organizational data systems.

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, including ERP, CRM, SCM, SAP, PeopleSoft, and other applications.
• Liaise with vendors and service providers to select products and 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.

Minimum Qualifications and 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
• Business requirements gathering and analysis
• Direct experience 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
• 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
• Oracle Database
• Understanding of Web Services, including SOAP, XML, UDDI, and WSDL.
• Object-oriented programming experience, such as using Java, J2EE, EJB, .NET, Websphere, and similar technologies.
• Excellent client/user interaction skills to determine requirements.
• Experience with Power BI Platform services.
• Experience with data processing flowcharting techniques.
• 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.
• Bachelor's or Master's degree in Computer Science, Information Systems, or other related fields, or equivalent work experience.
• 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 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.