Data Architect

8 Job Specific Knowledge, Skills, and Abilities (KSAs)

The submitted candidate must be able to apply Knowledge, Skills, and Abilities in the following areas:

Knowledge:

·         Strong knowledge of financial management business processes, including accounting, ledger management, and budget reporting.

·         In-depth understanding of data modeling principles, including relational and dimensional modeling techniques.

·         Familiarity with the Florida PALM system or similar state or federal financial management systems.

·         Proficiency in database management systems (DBMS) such as Microsoft SQL Server and DB2.

·         Comprehensive understanding of ETL processes and data integration tools like Informatica, Talend, or Microsoft SSIS.

·         Knowledge of cloud-based data integration platforms (e.g., Azure, Snowflake) and cloud-first strategies.

·         Familiarity with data quality management practices, data governance frameworks, and best practices.

·         Knowledge of data visualization tools (e.g., Power BI) and reporting best practices.

·         Understanding of data security, privacy regulations, and compliance requirements.

 Skills:

·         Proficiency in SQL and scripting languages for database querying and data manipulation.

·         Strong analytical and problem-solving skills, with the ability to conduct complex systems analysis and identify areas for improvement.

·         Skill in designing scalable and robust data models that support business processes and reporting needs.

·         Ability to work with ETL tools to streamline and automate data extraction, transformation, and loading processes.

·         Skilled in verbal and written communication, with the ability to explain technical concepts to non-technical stakeholders.

·         Competency in project management, including the ability to plan, prioritize, and manage multiple tasks effectively.

·         Strong collaboration and interpersonal skills to work effectively with cross-functional teams and stakeholders.

·         Skilled in conducting data impact assessments and presenting findings to management and development teams.

Abilities:

·         Ability to lead and mentor technical teams, providing guidance on best practices in data architecture, integration, and quality management.

·         Ability to conduct detailed analysis of existing systems and identify opportunities for optimization and modernization.

·         Capability to develop comprehensive data models and ETL processes that align with business requirements and organizational goals.

·         Ability to translate user requirements into technical specifications and scalable data solutions.

·         Ability to integrate research, trends, and industry best practices into continuous improvement efforts.

·         Ability to communicate effectively with stakeholders at all levels, ensuring alignment between technical solutions and business needs.

·         Ability to adapt to changing requirements and priorities, maintaining a focus on quality and project deadlines.

·         Strong organizational skills and attention to detail, with the ability to document data architecture, processes, and standards.

·         Ability to ensure data solutions comply with security, privacy, and compliance standards.

5 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.

6 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, 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.

Preferred Qualifications:

·         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.