Data Integration Analyst I | Connections Education Columbia, MD, US

Job Details:
Position Summary:
Working remotely, or from our office in Columbia, MD, the Data Integration Analyst I will work with school staff, the technology team and partners to accurately report student and staff data on state and federal Department of Education reports, and supply data to other Connections Education departments. This person will have specific responsibilities for major projects within the department as well as regular student and staff reporting tasks – including the data needed to support state reporting and customer invoicing in multiple states. This individual will also prepare ad hoc reports requested by external audiences often requiring a short turnaround. The ideal candidate will have experience with school reporting requirements and have expertise in data manipulation, report creation and importing and exporting between applications.
*.Provide data to support the academic and financial operations of the school; Extract, Transform and Load (ETL) student data from school data system to state reporting systems.
*.Interpret technical file specifications, export and import data to fulfill requirements, and document steps for replication and audit preparation.
*.Plan and organize target date/deadline timelines and tracking systems for all required reports and ensure timely submission of all reports.
*.Assist with developing procedures and oversee implementation of procedures for reporting to external audiences including state agencies, funding sources, school boards, partner organizations, etc.
*.Manage data sets with student, staff, and course information. Work with school personnel, partners and district liaisons to monitor and track data for inconsistencies, research discovered inconsistencies, develop a plan for correction and future prevention.
*.Maintain departmental process and procedure documentation.
*.Create and maintain SQL Server Reports to accommodate state reporting and corporate requirements.
*.Other duties as assigned.
*.Bachelor’s degree in Math, Statistics, Education, Social Science, Research, or related field
*.Advanced Excel user
*.2-5 years professional experience
*.Experience working with large data sets from different sources
*.Comfortable with technology and experience quickly learning new technologies
*.Ability to interpret technical file specification documents to produce error-free import files
*.Experience establishing procedures for data management and quality control
*.Excellent communication skills, both oral and written
*.Excellent organizational and planning skills with the ability to balance multiple tasks and competing deadlines
*.Practical understanding of how relational databases work..
..More Details» [Apply]

No comments: