Data Architect (On-site)

Join Our Team

Do you want to make an impact on the world around you? The work we do at Kyra Solutions directly impacts government entities and the citizens they serve. In Transportation practice, our solutions are designed to save lives on the roadways and in our Regulatory practice, we are designing solutions to make government digital for your accessibility. Kyra works hard to offer long-term growth potential, competitive wages, and continuous professional development for our employees.

If you are interested in furthering your career with Kyra and help us improve the way governments serve their citizens, please send your resume, and make sure to include salary expectation, availability, and contact information. You do not want to miss this opportunity!

Title

Data Architect (On-site)

Required Skills and 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 Skills and Experience

* 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, Skills and Abilities

* 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 client security standards.
Knowledge of data visualization tools (e.g., Power BI) and reporting best practices.
* Understanding of data security, privacy regulations, and compliance requirements.
* 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 client security standards.
* Knowledge of data visualization tools (e.g., Power BI) and reporting best practices.
* Understanding of data security, privacy regulations, and compliance requirements.
* 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.

Primary Responsibilities

* Analyze and verify existing data models and interfaces to assess impacts and identify potential disruptions due to the implementation of a modernized data model.
* Design and implement comprehensive data models to ensure compatibility with business processes and reporting needs.
* Review and enhance ETL processes to improve data quality, timeliness, and accuracy, and implement robust data quality measures to maintain high standards of production data.
* Collaborate with development teams to deploy revised data models, verifying successful implementation and resolving any integration issues.
* Provide expert guidance on data visualization and reporting, establishing best practices to optimize business insights, and monitor dependencies with interfacing systems to propose remediation where necessary.
* Act as a liaison between technical teams, business stakeholders, OOT, and OIT to ensure clear communication regarding data architecture changes and project timelines.
* Mentor and provide technical leadership to team members, guiding them on best practices in data integration, architecture, and quality management.
* Ensure continuous improvement in data processes by defining roadmaps, standardizing methodologies, and collaborating on strategic initiatives.
* Evaluate and align current data systems with the state s cloud-first initiative, ensuring data models are scalable and compatible with cloud architecture.

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.

Location

Tallahassee, FL

Duration

Long-Term

Why Kyra?

Founded in 1997, Kyra Solutions is a national leader of transportation technology and regulatory solutions in government. We specialize in the art and science of digital transformation in government. Our commitment to providing the highest level of service and tailored solutions has supported our consistent double-digit growth for over a decade. We are headquartered in the greater Tampa Bay area with other offices across Florida and an innovation center in Silicon Valley, CA.

Because of our dedication to our employees, we have won one of the Best Companies to Work for in Florida 3 years in a row by Florida Trend magazine. Kyra has won other numerous awards including the coveted INC magazine s one of America s Fastest Growing Companies several years in a row. Kyra's commitment to our employees, to best practices in project management and business analysis, and to solution development has led to our achievement in becoming the first Project Management Institute certified company in Florida. Our proven successful track record has resulted in several prestigious awards including the State of Florida's Diversity Business of the Year Award. We are proud to be a sponsor for the TaxWatch Productivity Awards and partner to Florida TaxWatch.

Background & References

Verifiable professional references will be required along with the resume; however, references will be checked/contacted after the interview and before the project starts. Level two background check will be done on the selected candidate for employment, criminal (State & Federal), education, and others as mandated by the client. Please make sure your resume and all other information provided are accurate. Any misrepresentation will mean permanent disqualification by the client. Equal employment opportunity employer.