Data Architect

Job Title: Data Architect

Duration : 12+ Months With high possibility of extension


Location: Tallahassee, FL 32399 (Onsite from Day One)

Required Skills:
• 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 DB2 systems.
• Experience with Informatica 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.

Knowledge :

• Familiarity with financial management Work Program Application (WPA), RCI LRS, RCI/TCI, and Pavement Systems.

• In-depth understanding of data modeling principles, including relational and dimensional modeling techniques, canonical models, schema design, and integration patterns

• 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, Snowflake, or Microsoft SSIS.

• Proficiency with AZURE, Snowflake, Informatica, PostgreSQL, and cloud-first strategies.

• Understanding of data pipelines, batch vs. real-time integration, and API-driven architectures.

• Knowledge of spatial data concepts and event segmentation

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

• Knowledge of role-based access, encryption, and FDOT security standards.

• 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.
• Translate business requirements into technical solutions that scale.
• Create architecture diagrams, data dictionaries, and governance playbooks for stakeholders.
• Ability to design scalable and robust canonical data models and coordinate schemas across disparate systems to support business processes and reporting needs.
• Ability to work with ETL tools to streamline and automate data extraction, transformation, and loading processes.
• Build efficient ingestion and transformation workflows using Informatica or AZURE Data Factory.
• Skilled in developing RESTful endpoints for spatial and engineering data exchange.
• 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 to align technical and business goals.
• Skilled in conducting data impact assessments and presenting findings to management and development teams.