Data Engineer

Boston, MA, US
Sep 11, 2019
The Boston Public Schools seeks a junior Data Engineer to help create and optimize the data pipeline architecture for the Office of Data and Accountability. You will be a key member of the Office of Data and Accountability and deliver great support to the team's core group of analysts. Over the past two years, the Office of Data and Accountability and the Office of Instructional and Information Technology have worked collaboratively to implement the Ed-Fi data standard with support from the Michael and Susan Dell Foundation. The work of this position will directly support the departments' collaborative work in implementing the Ed-Fi data standard.

Reports to: Director of Analytics, Office of Data and Accountability

Key responsibilities:
  • Implement data pipelines using agile, iterative processes to deliver value quickly
  • Treat data quality, reliability, and documentation as fundamental acceptance criteria for data pipelines
  • Partner with data analysts to implement develop and deliver products that serve internal and external BPS stakeholders
  • Collaborate with the team to make the best technology choices
  • Deliver solutions that ensure data accuracy, high availability, robust security, and that are built for scaling
  • Assists team in the development and maintenance of best practices, methodologies, standards and frameworks
  • Continually seeks ways to improve processes, workflows and/or operations
  • Assist with other analytical tasks as assigned
  • Bachelor's degree in a related field - a quantitative field is a plus
  • 2+ years of full time, professional work experience
  • At least 2 years of experience with SQL - experience with T-SQL is a plus
  • Experience in optimizing queries and tuning database performance
  • Must have knowledge and experience in descriptive statistics and regression
  • Experience in cleaning data and building data pipelines - Python, R, or Java experience is a plus
  • Understands business value, context and priorities of the team's work
  • Collaborates in scoping, solution design and evaluation
  • Attention to detail - All downstream work is only as good as the quality and integrity of the data you're moving through the pipeline
  • Appreciation for clean design - You should appreciate the elegance of clean and simple designs that are not over-architected
  • Good communication skills - You'll have to talk to people from other departments to understand the playing field before you design anything and you should find satisfaction in helping colleagues solve problems
  • Excitement about working on back-end systems - You have to take pride in being the hero behind the scenes
  • A love of learning - Things change fast and you need to be able to quickly understand, evaluate, and learn new tools if necessary
  • Current authorization to work in the United States - Candidates must have such authorization by their first day of employment
  • Experience working in public schools, preferably in a large urban setting
  • Experience working with normalized databases and Microsoft SQL Server
  • Knowledge of Ed-Fi Data Standard
TERMS: Managerial, Tier C
This position subject to the City of Boston residency requirement.

Please refer to (under "Employee Benefits and Policies") for more information on salary and compensation. Salaries are listed by Unions and Grade/Step.

NOTE: School-based managerial employees will work 223 days between July 1st and June 30th each year. The 223 day work-year will include the 180 days in which school is in session, and the additional days will be determined by the employee and the principal or headmaster of the school. This position subject to the City of Boston residency requirement.

School-based managerial employees are not eligible for vacation time or compensatory time. In the event of school cancellation due to snow or inclement weather, school-based managerial employees need not report to work.

The Boston Public Schools, in accordance with its nondiscrimination policies, does not discriminate in its programs, facilities, or employment or educational opportunities on the basis of race, color, age, criminal record (inquiries only), disability, homelessness, sex/gender, gender identity, religion, national origin, ancestry, sexual orientation, genetics or military status, and does not tolerate any form of retaliation, or bias-based intimidation, threat or harassment that demeans individuals' dignity or interferes with their ability to learn or work.

Similar jobs

Similar jobs