Data Coordinator

City of Stamford; Stamford (CT); On-site; USD 60,000 - 90,000; Full time

Job summary

The City of Stamford is seeking a data-focused professional to collect, manage, and analyze data for the City Board of Education under the supervision of the department Director or designee. The role emphasizes data entry, data integrity, maintenance, and reporting across multiple timeframes.

Responsibilities include extracting and analyzing data with advanced Excel, Access, and Word, designing reports, and assisting with state and federal reporting.

Qualifications

• Bachelor's degree in business, CS, accounting or related field with two years of related experience.
• Advanced knowledge of Excel, Access and Word; ability to run reports and generate charts.
• Experience with data extraction, reporting and databases in a school district context is a plus.

Responsibilities

• Collect, manage and analyze data for the Board of Education.
• Assist in data entry, formatting and importing data into information systems.
• Design and maintain databases related to district programs and initiatives.
• Create weekly, monthly and annual data reports; develop ad hoc reports as needed.
• Assist with Federal and State reporting; export/import data to external systems.
• Extract, manipulate and analyze data using advanced Excel features; produce graphs/charts.

Skills

Data analysis

Data entry

Data interpretation

Attention to detail

Communication skills

Autonomous work

Education

Bachelor's degree in business

Bachelor's degree in Computer Science

Bachelor's degree in Accounting

Two years of related experience

Tools

Excel

Access

Word

PowerPoint

Database systems

Job description

Under the general supervision of the department Director or designee, this position is responsible for collecting, managing, and analyzing data for the Board of Education.

Supervision Received: Under the general supervision of the department Director or designee.

Supervision Exercised: None

• Performs related duties as required.

DATA ENTRY

• Assist in the collection/input of data into the district’s information systems.
• Receives, formats, and imports data into the district’s information systems.
• Imports assessment data into the district’s information systems.

DATA INTEGRITY

• Ensures integrity of data, verifying information regarding data quality and data completeness.
• Reviews and audits databases on a regular basis to ensure accuracy of data. Makes corrections and additions to database records as required.

DATA MAINTENANCE

• Designs, establishes, and maintains data bases related to programs and initiatives.

DATA REPORTING

• Designs reports, using advance technology, as requested.
• Produces data reports as requested by administration and school district staff. Prepares weekly, monthly, quarterly, and annual data reports as needed Develops ad hoc reports as necessary.
• Uses knowledge of the information system to extract data and generate required reports and queries in varying formats as requested.
• Assist with Federal and State reporting of school district data including exporting and uploading to external systems.
• Collects and researches material necessary for the completion of annual state and federal reports, records and manuals.

DATA ANALYSIS

• Extracts, manipulates, and analyzes data utilizing advanced functions in Excel.
• Performs searches on the Internet as necessary.
• Communicates and processes of requests as necessary.
• Research specific problems and/or questions and proposes solutions.
• Ability to work with individuals from diverse backgrounds.
• Must have advanced knowledge of Microsoft Excel, Access, and Word, and the ability to run reports from these programs as necessary.
• Working knowledge of PowerPoint.
• Experience working with database systems required. Experience working with a student information system a plus.
• Knowledge of office practices and procedures.
• Strong organizational skills.
• Ability to gather, collage and or classify data.
• Excellent written, oral and interpersonal skills.
• Must be able to work autonomously with the ability to make decisions as necessary with minimal supervision and direction.
• Ability to prioritize tasks.
• Must be detail oriented.
• Ability to multi-task.
• Ability to read, understand and prepare complex written material.
• Working knowledge of the principles, practices and methods of accepted database design and management.
• Experience with data extraction, reporting, and analysis tools.
• Ability to generate graphs/charts for reporting.
• Thorough knowledge of Business Mathematics and English.
• Ability to deal effectively with others, including department heads, principals, employees, parents, and other governmental agencies.
• Ability to communicate effectively in writing and orally.
• Graduation from an accredited college or university with a bachelor’s degree in business, Computer Science, Accounting or a related field and two (2) years of experience in the accounting, information technology or business environment, OR the equivalent commensurate combination of training, schooling and experience in the business, information technology or accounting environment.

SCOPE OF EXAMINATION:

Qualified applicants will be evaluated on their level and quality of related experience, education and training documented on the application and application supplement. Incomplete applications will be rejected.