Data Engineer / Lead Data Engineer

About this role

CampusWorks is redefining how higher education institutions use technology and functional managed services to drive transformation, financial sustainability, and student success. We serve as a true end-to-end partner to institutional leaders, delivering a fully integrated model that spans professional and managed services.
We are seeking Data Engineers at both the mid and lead level to build and operate a federated, multi-institution data platform on Azure Databricks and Microsoft Fabric. You will develop the pipelines that move data from Workday and a range of legacy source systems into a governed medallion lakehouse (Bronze / Silver / Gold), delivering clean, reliable, well-modeled data that powers analytics for multiple higher education institutions.
This posting covers two levels. As a Data Engineer, you will build and maintain production pipelines within established patterns. As a Lead Data Engineer, you will act as a senior technical lead — setting engineering standards, owning complex integrations, mentoring engineers, and reviewing code — as a hands-on individual contributor without direct-report responsibility. Please indicate in your application which level best fits your experience.
Responsibilities

Pipeline development & data modeling

Build and maintain batch data pipelines that ingest from Workday (HCM, Finance, Student) and legacy source systems into the Bronze layer

Develop transformation logic across Bronze / Silver / Gold layers using Spark, Python, and SQL on Databricks

Model data for analytics consumption, balancing performance, reliability, and maintainability

Orchestrate and schedule workloads (e.g., Databricks Workflows, Azure Data Factory, or Fabric pipelines) and monitor them for reliability

Implement data-quality checks and validation within pipelines

Platform & governance alignment

Work within the federated architecture and Unity Catalog security model, respecting the boundary between institution-administered and centrally managed catalogs

Follow the shared transformation standards and reference patterns set by the Solution Architect

Contribute to documentation, code reviews, and version-controlled deployment

Lead-level responsibilities (Lead Data Engineer)

Serve as senior technical lead on complex integrations and cross-institution data workstreams

Define and enforce engineering standards, patterns, and best practices

Mentor and provide technical guidance and code review to other engineers

Partner with the Solution Architect and governance leads on design decisions and platform improvements

The responsibilities listed above are representative of the role and may be adjusted to meet organizational priorities.

Qualifications & Requirements

Data Engineer: 3–6 years building production data pipelines. Lead Data Engineer: 7–10 years, with demonstrated technical leadership

Hands-on expertise with Apache Spark, Python, and SQL in a Databricks environment

Experience designing and building medallion or layered data architectures (Bronze / Silver / Gold or equivalent)

Proven experience integrating data from multiple ERP / SIS / operational source systems into an analytics platform

Experience with batch pipeline orchestration and scheduling (Databricks Workflows, Azure Data Factory, or similar)

Working understanding of data governance, security, and access concepts in a shared or multi-tenant environment

Strong problem-solving skills with a consistent focus on data quality and reliability

Excellent communication and collaboration skills on a remote team

Bachelor’s degree in a technical field or equivalent practical experience

Preferred Qualifications

Microsoft Fabric and/or Power BI experience

Data-quality tooling such as Great Expectations — expected for the Lead level

Experience with higher education source systems: Workday, Banner (Oracle), Colleague (SQL Server), Jenzabar, PowerFAIDS

Unity Catalog experience and familiarity with CI/CD for data (Git-based workflows, DevOps pipelines)

Exposure to streaming or near-real-time ingestion patterns

Databricks certification (e.g., Databricks Certified Data Engineer)

What You Can Expect from Us
At CampusWorks, we don't just help our clients succeed; we help our employees succeed. Competitive pay, robust benefits for full-time employees, and professional development opportunities are a few of the many reasons that CampusWorks is a great place to build your career.
Our employees enjoy:

Meaningful work. Our employees often tell us that their work gives them a sense of purpose because it makes a difference in the lives of students and educators. CampusWorks Inc., as a large consulting firm, provides its employees with an opportunity to work both onsite and remotely with our clients across the United States and in Canada. With the nature of our clients’ work evolving quickly, we’re all being asked to support larger CampusWorks initiatives. Upon joining CampusWorks in a consulting role, your talent and expertise may be applied to a range of projects, assignments, and clients.

A CEO who cares. Chairman and CEO Liz Murphy has made it her mission to create a culture that appreciates and takes good care of its people. As a result, being an employee of CampusWorks feels like being a member of a big family.

A virtual and onsite workplace. In an effort to reduce our environmental footprint, CampusWorks became a virtual company in 2012. As such, our team members are located across the U.S. and Canada, where they work from their home offices and at client sites.

Flexibility. We value work-life balance because we know that happy employees create happy customers. That's why CampusWorks offers both full-time and part-time 1099 consulting career opportunities to fit life's unique demands.

A company that gives back. Every year CampusWorks proudly supports numerous charitable fundraising initiatives that align with our vision to make higher education accessible to everyone.

At CampusWorks, we value the…