Data Integration Analyst - SQL Specialist

Company: Pearson
Location: Madison
Posted on: March 18, 2023

Job Description:

At Pearson, we''re committed to a world that''s always learning and to our talented team who makes it all possible. From bringing lectures vividly to life to turning textbooks into laptop lessons, we are always reexamining the way people learn best, whether it''s one child in our own backyard or an education community across the globe. We are bold thinkers and standout innovators who motivate each other to explore new frontiers in an environment that supports and inspires us to always be better. By pushing the boundaries of technology-and each other to surpass these boundaries-we create seeds of learning that become the catalyst for the world''s innovations, personal and global, large and small.Pearson Virtual Schools (PVS) provide high-quality, highly accountable online education solutions to schools, school districts, and students in grades K-12. It serves families and schools with a variety of digital learning and online school solutions including Connections Academy, International Connections Academy, and Pearson Online Classroom. Recognized for its outstanding curriculum, high-quality teachers, and leadership, Pearson Virtual Schools is committed to expanding quality education through technology and helping students achieve both academic and personal success.Position Summary:Working remotely, the Data Integration Analyst - SQL Specialist 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 and Legal team. This is a newly created position with the opportunity to gather requirements, develop, communicate, and implement processes. The employee is responsible for anticipating, creating, organizing, updating, and maintaining the SQL queries and reports for the state reporting team. He/she will also prepare ad hoc reports requested by external audiences often requiring a short turnaround. The ideal candidate will have strong technical aptitude, a desire for continuous improvements, takes initiative, enjoys problem-solving, experience with project management, and school reporting as it relates to data manipulation, report writing, automation, importing, and exporting between applications. In addition, the candidate will be able to communicate effectively and confidently with state reporting colleagues as well as other corporate and school leaders.Responsibilities:* Provide data to support the school''s academic and financial operations for multiple complex schools; Extract, Transform and Load (ETL) data between systems.* Manage data sets with students, staff, and course information. Partner with school personnel and program and district liaisons to monitor and track data for inconsistencies, research discovered inconsistencies, and develop a plan for correction and future prevention.* Interpret technical file specifications, export, and import data to fulfill requirements, and document steps for replication and audit preparation.* Manage deadline tracking systems and ensure timely submission of all required reports.* Maintain data integrity and ongoing quality of delivered reports.* Support cross-team requirements and development efforts for multiple projects.* 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.* Represent PVS, the school, and the department at internal and external conferences including preparing and delivering presentations.* Identify and lead opportunities for improvements to increase accuracy and efficiency.* Serve as subject matter expert in data tools and techniques.* Maintain departmental process and procedure documentation.* Other duties as assigned.Requirements:* Strong knowledge of SQL with experience querying large complex data models.* Proven experience with report design and ability to present data in a meaningful way using Power BI, Reporting Services, and/or MS Excel* 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 including leading and owning the relationship with partner-customers and resolving conflicts* Excellent project management, organizational, and planning skills with the ability to balance multiple tasks and competing deadlines* Experience with Salesforce data structures* 4-8 years of professional experience* Bachelor''s degree or equivalent experience in Math, Statistics, Education, Social Science, Research, or related field* Due to the nature of this position, the applicant will need the ability to work from home or during off-hours as necessary.* Experience in K-12 education and/or State educational reporting a plusCapabilities:* 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.Behaviors:* High level of integrity and transparency;* Customer-centric mentality;* High degree of flexibility;* Positive attitude;* Evidence of a strong work ethic, and;* Demonstrated team playerPearson Virtual Schools is focused on providing a flexible work environment to its employees, including the ability to work from home on a regular basis in most positions. We believe that flexibility in work/life balance is a critical part of our culture and employee satisfaction, and we are proud to provide our employees the ability to work from anywhere, anytime. In exchange, we require that employees have the appropriate means to work remotely, including adherence to our work-at-home policies regarding home office setup, including but not limited to privacy of records, technology standards, equipment standards, and expectations.The following equipment will be provided to you by the company as a full-time employee:* Laptop* Monitor* Mouse* Keyboard* HeadsetThe following equipment will need to be provided by you, as the employee, when working from home:* 2nd monitor (required)The anticipated starting salary range for Colorado-based expressing interested in this position is $63,000-$70,000. This position is eligible to participate in an annual incentive program.Benefits available to eligible employees can be seen at: is the most powerful force for change in the world. More than 20,000 Pearson employees deliver our products and services in nearly 200 countries, all working towards a common purpose - to help everyone achieve their potential through learning. We do that by providing high quality, digital content and learning experiences, as well as assessments and qualifications that help people build their skills and grow with the world around them. We are the world''s leading learning company. Learn more at .Pearson believes that wherever learning flourishes, so do people. We are committed to being an anti-racist?company in everything we do. We value the power of an inclusive culture and a strong sense of belonging. We promote a culture where differences are embraced, opportunities are accessible, consideration and respect are the norm, and all individuals are supported in reaching their full potential. Through our talent, we believe that diversity, equity, and inclusion make us a more innovative and vibrant place to work. People are at the center, and we are committed to a sustainable environment and workplace where talent can learn, grow, and thrive.To learn more about Pearson''s commitment to a diverse and inclusive workforce, please click here:? is an Affirmative Action and Equal Opportunity Employer and a member of E-Verify. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. The more inclusive we are, the better our work will be. All employment is decided based on qualifications, merit, and business need.?All qualified applicants will receive consideration for employment without regard to race, ethnicity, color, religion, sex, sexual orientation, gender identity, gender expression, age, national origin, protected veteran status, disability status, or any other group protected by law.Job: TECHNOLOGYOrganization: Virtual LearningSchedule: FULL_TIMEReq ID: 7436

Keywords: Pearson, Madison , Data Integration Analyst - SQL Specialist, Accounting, Auditing , Madison, Wisconsin