Sr. Data Engineer



October 12, 2022

Job Description

HelioCampus, located in Bethesda, MD, Chapel Hill, NC, and Philadelphia, PA, is a data-driven tech company that serves higher education institutions. We empower institutional effectiveness through assessment, benchmarking and decision support via an enterprise analytics platform. Through three complementary lines of business, HelioCampus helps institutions measure and evaluate their effectiveness in fulfilling their mission by connecting investments with financial and student learning outcomes. With data from every corner of campus, HelioCampus takes a comprehensive, data-informed approach towards continuous improvement and learner success as a methodology to run an institution.

We are seeking a Senior Data Engineer to join our technical team working on challenging data integration projects. We value innovative employees who have a sense of ownership in their work and perform well in a fast paced, collaborative team environment. You will work on a combination of exciting new projects and initiatives while also working to improve and maintain HelioCampus’ existing solutions (using cloud technologies). You will become an integral part of a fast-growing team of ETL, BI developers and analysts dedicated to the success of higher education.

Key Accountabilities & Responsibilities:

  • Perform SQL development, unit testing and deployment of ETL solutions
  • Design complex data workflow solutions and data models based on user requirements
  • Develop ETL using open source tools and commercial solutions such as Oracle Data Integrator (ODI), Informatica
  • Performs design and code review functions for the development projects
  • Mentor and coach other ETL developers
  • Research and recommends alternative actions to resolve problems
  • Analyze trends in performance to proactively prevent problems
  • Troubleshoot ETL issues in real-time and diagnoses the root cause

Required Skills & Qualifications:

  • 6+ years in ETL and related experience
  • 4+ years leading the design and development of complex solutions
  • Bachelor’s degree from an accredited institution of higher learning

Preferred Skills & Qualifications:

  • Understanding of data warehouse concepts and structures
  • Experience developing complex SQL queries and analyzing data, systems integration experience
  • Experience with data mapping, and the ability to design and develop ETL solutions
  • Experience with translation of requirements into data model specifications
  • Ability to multi-task, ability to troubleshoot problems in real-time, and diagnose the root cause
  • Desire to join a small, growing company where the sky is the limit on opportunity
  • Attitude of self-starter and ability to explore and find solutions with minimal supervision

Compensation and Benefits:
HelioCampus offers employees a competitive salary along with paid time off, healthcare, vision, dental, 401(k) w/ company match, remote work flexibility, and a fun, collaborative work environment.

HelioCampus is an equal opportunity employer all qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.