Data Engineer

How You’ll Help

As a Data Engineer II, you will be a key architect in building and maintaining our specialized higher education data warehouse. You will ensure that institutional data is reliable, high‑performing, and delivered in a timely manner, directly enabling university leaders to make informed, strategic decisions.

• Develop:
  Design, build, and deploy robust ETL/ELT solutions using SQL and Python.
• Test & Deploy:
  Perform comprehensive unit testing and participate in code reviews to ensure data integrity and system reliability.
• Analyze:
  Monitor and evaluate pipeline performance trends to proactively prevent bottlenecks and system failures.
• Troubleshoot:
  Diagnose and resolve complex ETL issues in real‑time, identifying root causes to prevent recurrence.
• Collaborate:
  Work closely with analysts and senior engineers to expand reporting models that meet evolving university goals.

• Previous experience in the Higher Education or EdTech sector.
• 3+ years of professional experience specifically in ETL/SQL development and data engineering.
• Expertise in SQL:
  Strong proficiency in developing complex queries, analyzing data, and managing system integrations.
• Data Architecture Knowledge: A solid understanding of data warehouse concepts, structures, and dimensional modeling.
• Coding Proficiency:
  Experience with at least one object‑oriented programming language (Python, Java, etc.).
• An Analytical Mindset:
  The ability to think on your fly and approach technical challenges with a solution‑oriented focus.
• Autonomy: A drive to explore technical hurdles and find solutions with minimal supervision in a fast‑paced environment.

• Experience with AWS tools (Redshift, S3, Glue) or other major Cloud Service Platforms.
• Exposure to No
  
  SQL data transformation approaches.
• Proficiency in translating complex business requirements into technical SQL specifications.

• Higher Ed Data Warehouse Expansion:
  Scaling our core warehouse to accommodate new data sources and institutional partners.
• KPI Modeling:
  Refining and expanding reporting models to track student learning outcomes and financial sustainability.
• Pipeline Modernization:
  Optimizing existing ETL processes to leverage modern cloud‑native features for faster processing.

Helio Campus has two locations, Bethesda, MD and Chapel Hill, NC. This specific role is primarily remote, with occasional travel to an office or client site.

Helio Campus offers employees a competitive salary along with paid time off, healthcare, vision, dental, 401(k) match, parental leave, remote work flexibility, home office perks, and a collaborative work environment.

Helio Campus is an equal opportunity employer, and 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.

The list of responsibilities described above is not comprehensive. Other tasks not mentioned here may be required. Changing business conditions may trigger changes to job responsibilities. This job description is not an employment contract.

• Vision:
  Sufficient visual acuity to read documents, view computer screens, and engage in tasks that require attention to detail.
• Hearing:
  Ability to communicate effectively in person (as applicable) and via phone or video conferencing, ensuring clear understanding of verbal instructions.
• Fine Motor
  
  Skills:
  
  Proficient use of hands for typing, using a mouse, and managing office equipment such as printers and scanners.
• Lifting:
  Occasional lifting of up to 10 pounds (e.g., office supplies or equipment).