SQL Data Analyst / Technical Analyst

Quantam; Frankfort (KY); Hybride; USD 55 000 - 83 000; Plein temps

Avantages offerts par ce poste

Health benefits

Paid time off

401(k) plan

Résumé du poste

Quantam Solutions is seeking an experienced SQL Data Analyst in Kentucky to support enterprise-level data management, reporting, and data quality initiatives. This role involves working with KSIS/Infinite Campus for statewide education data reporting and regulatory compliance.

The ideal candidate has strong SQL skills, experience in data extraction and validation, and the ability to translate business requirements into technical solutions while ensuring reporting accuracy and consistency.

Qualifications

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

Responsabilités

• Lead requirements gathering for complex education data reporting from Infinite Campus, ensuring alignment with objectives and stakeholder needs.
• Design, develop, and validate SQL-based data extraction processes for enterprise reporting and compliance.
• Perform data validation and QA on extracted datasets to ensure accuracy and integrity.
• Collaborate with data stewards and system users to identify reporting needs and document functional specifications.
• Communicate data integrity issues and coordinate solutions with stakeholders.

Connaissances

SQL queries

Data validation

Requirements gathering

Stakeholder comms

Formation

Bachelors in CS/Math

Equivalent experience

Outils

SharePoint

SQL

Office 365

Description du poste

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. Candidates must be located in Kentucky and able to work hybrid 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.