Data Architect
3B Staffing LLC, Tallahassee, FL, United States
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.
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.