Data Engineer
Posted 8hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Engineer building pipelines, warehouses, and analytics data for Joyce University’s healthcare education mission. Supporting reporting, compliance, accreditation, and institutional decision-making.
Responsibilities:
- Design, build, and maintain ETL/ELT pipelines loading data from the SIS, LMS, CRM, and third-party sources
- Build integrations through APIs, flat files, and database connections, including scheduled and incremental loads
- Monitor pipeline runs, set up alerting, and quickly fix failures with documented root-cause notes
- Design and maintain the University data warehouse using dimensional modeling, including star schemas, conformed dimensions, and slowly changing dimensions
- Create curated, reusable datasets for enrollment, retention, course success, financial aid, and finance
- Tune SQL Server performance through indexing, partitioning, and query optimization
- Build automated data-quality checks and reconcile warehouse figures against source systems
- Apply role-based access, encryption, and masking to comply with FERPA, GLBA, and University policy
- Deliver data sources and semantic models for Sigma and support report builders
- Supply accurate data for IPEDS, accreditation, and internal reporting
- Translate stakeholder requests into requirements, user stories, and acceptance criteria
- Evaluate data systems and recommend improvements in architecture, tooling, and processes
- Use Git, code review, and change management for pipeline and database code
- Share project status, risks, and changes with stakeholders and leadership
- Perform other related duties as assigned
Requirements:
- Bachelor's degree in computer science, information systems, data science, or a related field, or an equivalent combination of education and experience
- 3+ years of experience building and supporting data pipelines or data warehouses in a production environment
- Advanced SQL skills, including complex queries, stored procedures, and performance tuning, ideally in Snowflake
- Hands-on experience with at least one ETL tool such as SSIS, Azure Data Factory, dbt, or similar
- Working knowledge of dimensional data modeling and data warehouse design
- Experience with at least one scripting language, such as Python or PowerShell, for automation and data processing
- Clear written and verbal communication skills with both technical and non-technical colleagues
Benefits:
- Self-directed paid time off
- 12 paid holidays
- Medical, dental, and vision insurance
- Employer-paid short-term and long-term disability coverage
- 401(k) retirement plan
- Professional development opportunities
- Continuing education opportunities
- A mission-driven environment focused on healthcare education and student success
- The flexibility to work fully remote or in a hybrid arrangement from our Draper, Utah campus


















