SQL Data Analyst / Technical Analyst

Quantam Solutions provides IT solutions and consulting for various clients. We offer competitive hourly wages, health benefits, paid time off, and a 401(k) plan. We are currently seeking an SQL Data Analyst. This role offers a hybrid work location schedule in accordance with our client’s telework policy, ideally suited for individuals who can be present on-site weekly in Frankfort, KY.

Job Description:

Our client is seeking an experienced SQL Data Analyst to support enterprise-level data management, reporting, and data quality initiatives. This position will work extensively with the Kentucky Student Information System (KSIS)/Infinite Campus to support statewide education data reporting, regulatory compliance, and system integration needs.

The ideal candidate will have strong SQL skills, experience with data extraction and validation, and the ability to gather business requirements, analyze complex datasets, and develop technical solutions to ensure data accuracy and reporting consistency.

Key Responsibilities

• Lead requirements gathering for complex education data reporting from Infinite Campus, ensuring alignment with business objectives, reporting standards, and stakeholder needs.
• Analyze business and technical requirements, document functional specifications, and collaborate with data stewards and system users to identify reporting and system needs.
• Design, develop, and validate complex SQL-based data extraction processes to support enterprise reporting and regulatory compliance.
• Perform data validation, testing, and quality assurance on extracted datasets to ensure accuracy, consistency, and data integrity.
• Utilize SQL queries and database tools to compare datasets, troubleshoot discrepancies, and resolve data quality issues.
• Analyze database structures, system integrations, and interfaces to identify root causes of data integrity concerns and recommend technical solutions.
• Collaborate with system users and stakeholders to communicate data integrity issues, identify solutions, and improve reporting processes.
• Define reporting requirements, establish reporting calendars, and maintain technical documentation for ongoing reporting activities.
• Develop and maintain standardized documentation for data extraction, reporting, and quality assurance procedures using SharePoint.
• Demonstrate strong organizational, analytical, and communication skills while independently managing assigned responsibilities and meeting deadlines.
• Perform additional duties as needed to support enterprise data quality and reporting initiatives.

Required Qualifications

• Bachelor's degree in Computer Science, Mathematics, or a related field, or an equivalent combination of education, training, and experience.
• Ability to perform SQL/database queries and support data reporting responsibilities.

Preferred Qualifications

• Experience gathering business requirements and documenting functional and technical specifications.
• Experience developing, testing, and validating SQL-based data extracts.
• Knowledge of relational databases, database structures, and data integration processes.
• Experience identifying and resolving data discrepancies and data integrity issues.
• Proficiency with Microsoft Office 365, SharePoint, SQL, and data visualization platforms.
• Experience supporting enterprise-level reporting and data quality initiatives.
• Experience with student information systems, particularly Infinite Campus.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent verbal and written communication skills.
• Ability to work independently, prioritize tasks, and collaborate with technical and nontechnical stakeholders.

Work Location

This is a hybrid contract position based in Frankfort, Kentucky. Candidates must be able to meet the position's onsite work requirements.