Education is ever-evolvingAnd so are we.
We seek passionate people from diverse backgrounds who are committed to helping improve the work of schools as a trusted partner in advancing learningBy joining the cognia team, you will be immersed in a community of energetic and resourceful people dedicated to a common vision to impact and inspire education providers to advance and enable pathways of success for all learnersAt cognia we have developed a holistic approach to education that empowers schools to create real outcomes and optimize learning for students of all backgrounds, servicing more than 36,000 institutions, 5 million teachers, and 25 million students in 85 countriesWhen you join cognia, you join a team of experts passionate about our mission and embracing our core values in everything we do.
Nature and scope:
Under moderate supervision, the data engineer ii accepts and validates all student level data for assigned projects to ensure data integrityCombines several sources of data used for reporting test resultsThe data engineer ii also provides input and support into internal products and systems that affect data in the companyFollows established protocols and standards when performing tasks, and work outside of standard processes and procedures must be approved by department manager.
Principal activities:
Validate and accept student level data including student demographic and test data from various sources and provided in various formats.
Perform cleanup activities to data per specifications created.
Perform documentation of data processing specifications to ensure common understanding of processes and procedures used on a project.
Participate in project meetings to ensure data integrity issues are discussed and resolved.
Write sql scripts and stored procedures to support validation, cleanup, transformation, and delivery of student data.
Provide data support to internal products and systems.
Provide input into the development of internal products and systems.
Develop appropriate quality assurance steps to be implemented on projects to ensure data accuracy.
Provide support to team members on projects as needed.
Perform duties and fulfill responsibilities that may, from time to time, include related or unrelated tasks.
Job requirements:
Education & experience:
Bachelor’s degree and three (3) to five (5) years of experience in sql development, or an equivalent combination of education and experience.
Ssis experience is a plus
Competencies:
Strong verbal and written communication skills
Comprehensive knowledge of microsoft sql server
Sql programming of complex views, stored procedures, functions, and scripts
Strong understanding of the fundamentals of developing user-facing reports and forms
Experience with visual studio and c# preferred
Knowledge of microsoft office
Ability to work within a team environment as well as accomplish individual work.
Anticipated travel (may include local, national, and/or international travel):
Limited travel (0-10%)
At cognia, we recognize the critical role played by our teams in carrying out the organization’s important educational missionAs a reflection of that recognition our exceptional benefits offerings include generous paid time off and holiday breaks, comprehensive insurance plans, and a 12.5% retirement savings contribution which is immediately vested, all effective on your date of hireThis represents an affirmative commitment by the organization to attract and retain the highest quality workforce – to ensure our continued ability to effectively serve our mission for years to come.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy-related conditions), sexual orientation, gender identity, marital status, national origin, age, physical or mental disability, citizenship, protected veteran status, genetic information or any other characteristics protected by local, state, or federal laws, rules, or regulationsCognia is an equal opportunity employer, and is committed to diversity, equity, and inclusion.
