Senior Data Architect / Data Integration Lead

Core Technical Skills

• Strong experience with DB2 and Microsoft SQL Server.
• Hands-on experience with ETL and data integration platforms: Informatica, Azure Data Factory, Snowflake, SSIS.
• Proficiency in SQL and scripting for data querying and transformation.
• Experience with Azure, Snowflake, PostgreSQL, and cloud-first architectures.
• Strong understanding of data pipelines, batch vs. real-time processing, and API-driven architectures.
• Expertise in data modeling: relational, dimensional, canonical models, schema design, and integration patterns.
• Experience building scalable ingestion and transformation workflows.

Domain & Systems Knowledge

• Familiarity with financial management systems such as WPA, RCI LRS, RCI/TCI, Pavement Systems, and Florida PALM (or similar state/federal systems).
• Knowledge of spatial data concepts and event segmentation.

Responsibilities & Abilities

• Translate business requirements into scalable technical solutions.
• Perform systems analysis, data impact assessments, and modernization initiatives.
• Lead and mentor technical teams on data architecture, integration, and quality best practices.
• Ensure solutions meet security, privacy, and regulatory compliance requirements.
• Collaborate effectively with technical and non-technical stakeholders.
• Manage priorities across multiple initiatives while maintaining quality and timelines.

Soft Skills

• Strong communication, collaboration, and stakeholder management skills.
• Proven analytical, problem-solving, and decision-making abilities.
• Demonstrated leadership, adaptability, and organizational skills.