Pearson Associate Data Management Engineer in Lansing, Michigan
Working remotely, the Associate Data Management Engineer will work with school staff, the technology team and partners to accurately report student and staff data to state Departments of Education and Federal Government Agencies, as well as supply critical data to other departments within Pearson Online and Blended Learning K-12 including the Executive team and Legal. This person will have specific responsibilities for major projects and initiatives 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 strong technical aptitude, initiative, project management skills, and experience with school reporting as it relates to data manipulation, report writing and programming and importing and exporting between applications. In addition, the ideal candidate will be able to communicate effectively and confidently with school leaders, district superintendents, and state officials.
Provide data to support the academic and financial operations for 1-3 schools of varying complexity; 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.
Create and maintain SQL Server Reports to accommodate state reporting and corporate requirements.
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. Partner with school personnel, program 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.
Other duties as assigned.
Bachelor’s degree in Math, Statistics, Education, Social Science, Research, or related field or equivalent experience working in educational reporting
Advanced Excel user
2-5 years professional experience
Experience working with large data sets from different sources
Experience with SQL Server Reports, SSRS, SPSS, PowerBI, Business Objects Crystal Reports, Cognos or similar and knowledge of VBA or XML a plus
Excellent communication skills, both oral and written including leading and owning the relationship with partner-customers
Comfortable with technology and ability to 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 organizational and planning skills with the ability to balance multiple tasks and competing deadlines
Experience in K-12 education and/or State educational reporting a plus
Customer Centric – Acts with a strong customer mindset (both internal and external) and is a visible advocate for the customer. Builds strong partnerships with customers and uses those to improve their experience and outcomes.
Delivering Financial Results – A strong track record of delivering against budgets and commitments.
Communications - A great communicator who engages teams and stakeholders with thoughtful delivery and messages that resonate.
Works well in a matrix - Models collaboration, solves problems with peers, builds trust and support.
Takes personal responsibility – Can be relied on to complete tasks timely and well, demonstrates “ownership” regardless of the outcome, proactive in exploring and exploiting new opportunities.
High level of integrity and transparency;
Customer centric mentality;
High degree of flexibility;
Evidence of a strong work ethic, and;
Demonstrated team player
The anticipated starting salary range for Colorado-based individuals expressing interest in this position is $50,000. This position is eligible to participate in an annual incentive program.
Benefits available to eligible employees can be seen at: https://pearsonbenefitsus.com/
Organization: North America Connections
Req ID: 996