State Reporting Data Engineer

Pasco-Hernando State College; Town of Florida (NY); On-site; USD 70,000 - 95,000; Full time

Job summary

Pasco-Hernando State College seeks a Programmer/Analyst to provide technical programming and systems support for state reporting and institutional data functions. You will develop, test, document, and maintain Banner, Argos, SQL, and related reporting processes to improve accuracy and timeliness under the Director of Institutional Research.

Note: Job Description pending final approvals by the Strategic Leadership Team.

Qualifications

• Bachelor’s degree in CS/IS/SE/Data Analytics with 3 years of related experience.
• Equivalent combination of education and directly related experience considered.

Responsibilities

• Develop, test, and maintain programs, SQL queries, scripts, and data extracts for state reporting.
• Translate data rules into accurate technical logic and documented processes.
• Provide technical support for Student and Personnel databases and state-reporting files.
• Analyze and resolve data edits, anomalies, and variances with cross-functional teams.
• Reconcile submission files to Banner and source systems before certification.
• Develop and maintain Argos DataBlocks, enterprise reports, dashboards, and audits for state reporting.
• Diagnose data transformations and scheduling issues affecting reporting accuracy.
• Conduct unit, regression and user-acceptance testing for new/modified reporting code.
• Maintain version-controlled code and runbooks; document data lineage and mappings.
• Monitor scheduled processes, troubleshoot failures, and ensure timely submissions.
• Partner with offices to fix source-data problems and reduce manual adjustments.
• Support corrections, audits, and data requests.
• Apply information security and data retention standards.
• Provide training and user guides for Institutional Research staff.
• Participate in Banner/Argos upgrades and system migrations.
• Maintain knowledge of Florida College System reporting changes and enterprise tools.
• Perform other duties as assigned.

Skills

Relational databases

Python/SQL

Data extraction & transformation

Data validation

Documentation

Software development

Analytical thinking

Communication (technical)

Education

Bachelor's degree in CS/IS/SE/Data Analytics

Tools

Power BI

Ellucian Banner

Argos

Oracle/PLSQL

Job description

Pasco-Hernando State College seeks a Programmer/Analyst to provide technical programming and systems support for state reporting and institutional data functions. You will develop, test, document, and maintain Banner, Argos, SQL, and related reporting processes to improve accuracy and timeliness under the Director of Institutional Research.

Note: Job Description pending final approvals by the Strategic Leadership Team.