Data Architect (Onsite)

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.

Title:

Data Architect (Onsite)

Location:

Tallahassee, FL ||

Duration:

Long-Term Required Skills and Experience

• 5+ years of experience in Azure SQL Database, Synapse Analytics, ETL, Synapse pipeline/Azure Data Factory, and Dedicated SQL Pools.
• 5+ years of experience in

DDL, DML T-SQL

skills, advanced stored procedure writing skills, tables, primary keys, foreign keys, constraints, indexes, transactions, process logging, and error handling.

• 4+ years of experience in data architecture design principles, methodologies, and best practices.
• 3+ years of experience in data governance principles and compliance requirements related to data security and privacy.
• 3+ years of experience in integrating data from various sources and managing large data pipelines.
• 2+ years of experience in cloud computing concepts, particularly in Microsoft Azure, including storage solutions and computing capabilities.
• 1+ years of Experience with programming languages such as Python.
• 1+ years of experience in LLM
• Strong analytical and problem-solving skills to address complex data challenges.
• Ability to design and implement robust, scalable, and efficient data architectures.
• Ability to provide excellent customer support; meticulous quality of work and work product. Primary Responsibilities
• Collaborate with stakeholders and development teams to define project scope, gather requirements, and prioritize deliverables.
• Design and implement data architectures that align with business objectives, leveraging Azure SQL Database, Azure Synapse Analytics, LLM integration, and related Azure data services.
• Manage and optimize Dedicated SQL Pools in Azure Synapse to support large-scale data warehousing and analytics workloads.
• Design, develop, and maintain databases using Azure SQL and Azure SQL Managed Instance, ensuring performance, scalability, availability, and security.
• Develop, optimize, and maintain complex SQL queries, stored procedures, functions, and views. Optimize database performance by analyzing queries, identifying bottlenecks, and implementing effective tuning and troubleshooting strategies to ensure reliability and efficiency.
• Build and manage ETL/ELT pipelines using Synapse Pipelines or equivalent tools to support reliable and efficient data integration.
• Create and maintain scalable data models to support reporting, analytics, and downstream applications.
• Implement data governance practices, including data quality, lineage, and cataloging.\
• Ensure data security, privacy, and compliance with applicable standards and organizational policies.
• Monitor system performance, troubleshoot issues, and implement tuning strategies to improve efficiency.
• Support deployment processes, including CI/CD pipelines and version control for database objects.
• Maintain technical documentation, including system design, data flows, and operational procedures.
• Evaluate and recommend new technologies, tools, and best practices to improve data platform capabilities.
• Provide technical guidance and mentorship to junior team members and support cross-functional teams. Education
• Bachelors or higher in Computer Science, Information Systems, or related field.

Or equivalent work experience. 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! 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 numerous other awards including the coveted INC magazine's recognition as 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.