Data Integration Analyst - SQL Specialist
Company: Pearson
Location: Little Rock
Posted on: March 16, 2023
|
|
Job Description:
At Pearson, were committed to a world thats 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 its
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
technologyand each other to surpass these boundarieswe create seeds
of learning that become the catalyst for the worlds 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
terpret 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 ExcelAbility to interpret
technical file specification documents to produce error-free import
filesExperience establishing procedures for data management and
quality controlExcellent communication skills, both oral and
written including leading and owning the relationship with
partner-customers and resolving conflictsExcellent project
management, organizational, and planning skills with the ability to
balance multiple tasks and competing deadlinesExperience with
Salesforce data structures4-8 years of professional
experienceBachelors degree or equivalent experience in Math,
Statistics, Education, Social Science, Research, or related
fieldDue 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 munications - 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:LaptopMonitorMouseKeyboardHeadsetThe 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 worlds leading learning company. Learn more at .Pearson
believes that wherever learning flourishes, so do people. We are
committed to being an anti-racistcompany 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 Pearsons 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, Little Rock , Data Integration Analyst - SQL Specialist, Accounting, Auditing , Little Rock, Arkansas
Click
here to apply!
|