Data Integration Engineer
Posted on 4/3/2023
INACTIVE
Ellevation

201-500 employees

English learning software platform
Company Overview
Ellevation mission is to help English Language Learners realize their highest aspirations. Ellevation's product suite includes a best-in-class data and instructional planning platform, resources to build teacher capacity, and student-facing programs to teach academic language.
Education

Company Stage

Series B

Total Funding

$37.5M

Founded

2011

Headquarters

Boston, Massachusetts

Growth & Insights
Headcount

6 month growth

1%

1 year growth

18%

2 year growth

47%
Locations
Remote
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
Python
MySQL
R
Git
SQL
Postgres
Pandas
JIRA
Oracle
Data Analysis
Excel/Numbers/Sheets
CategoriesNew
Data & Analytics
Requirements
  • 1-3 years experience working with many heterogeneous datasets and formats from a variety of vendors, providers and platforms
  • Understanding complex data and translating issues into non-technical terms
  • You have a knack for problem solving complex data discrepancies
  • Demonstrated success and effectiveness working in and promoting a rapidly changing, collaborative, and time-critical work environment
  • Attention to detail and strong written and verbal communication skills
  • Customer service orientation, and an understanding of the importance of meeting customer needs and maintaining strong customer satisfaction
  • Able to translate customer requests into technical solutions
  • Commitment to continuous improvement and the mission; desire to focus talents on helping improve outcomes for others
  • Collaborates well with others, and not afraid to ask for help when needed
  • Self Starter/Learner - Comfortable with ambiguity
  • Proficiency with Python (Pandas Library or other scripting languages such as R)
  • Basic understanding of Coding/Programming Logic
  • Experience with Microsoft Office Excel or Google Sheets
  • Familiarity with SQL and RDBMS concepts (SQL Server, Oracle, MySQL, PostgreSQL, etc.)
  • Experience implementing prevention and detection controls to ensure data integrity
  • Statistics/data-study based experience
  • Working with, extending and defining data interchange standards and best practices
  • Experience with SFTP, FTPS and other file transfer protocols
Responsibilities
  • Writing and committing easy to read, reproducible code
  • Importing student, staff, schedule, and test files
  • Automating set up processes
  • Meeting Service Level Agreements for imports and troubleshooting tasks requested by partners
  • Prioritizing multiple projects at once
  • Designing solutions to automate and/or simplify integration processes
  • Gain familiarity and knowledge of Ellevation, its team structure, and product/services
  • Know our mission, values, and product offering
  • Know teams and high-level responsibilities of each
  • Learn about our platform and have familiarity with our product offerings
  • Setup and Familiarize yourself with our internal tools and communication norms (Slack, GSuite, Jira, Wiki)
  • Attend PSO team overviews and shadow partner calls to further understand who the Data Integration Team (DIT) collaborates with on a daily basis and how we provide service to our partners
  • Set up a development environment on your computer to execute all Data Integration Engineer (DI Eng) tasks (python, SQL, git)
  • Start to become familiar with addressing DIT data processing and imports (Student, Schedule, Staff, ELP test, Grade file evaluations and uploads & Review and practice Python code development)
  • Develop familiarity with our data model
  • Be able to navigate our DB and locate key tables relevant to DI Eng tasks
  • Develop proficiency in importing various data types, including standardized tests
  • Take on automated tasks
  • Learn how to commit code
  • Learn automation setup process
  • Familiarize with and begin contributing to DI Eng projects
  • Start to take on responsibility for Enterprise partner(s)
  • Take on more technical DI Eng project work
  • Work independently
  • Troubleshoot data issues independently
  • Maintain SLA on your assigned work
  • Continue to develop your technical skills
  • Maintain a high level of data fidelity for partners
  • Collaborate on new projects and initiatives
  • Work to improve our processes and code libraries
  • Automate manual tasks
Desired Qualifications
  • : SIS/K-12 student data/Ed-Fi experience