Note: The job is a remote job and is open to candidates in USA. Joyce University is seeking a Data Engineer to build and maintain the data pipelines and warehouse that support decision-making across the University. The role delivers reliable, secure data solutions for operational and strategic planning, compliance and regulatory reporting, accreditation, and institutional analytics.
Responsibilities
- Design, build and maintain ETL/ELT pipelines that load 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 fix failures quickly with documented root-cause notes
- Design and maintain the University data warehouse using dimensional modeling (star schemas, conformed dimensions, slowly changing dimensions)
- Create curated, reusable datasets for key areas such as 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 so data use complies with FERPA, GLBA and University policy
- Deliver data sources and semantic models for Sigma and help report builders use them well
- Supply accurate data for state and federal reporting (IPEDS), accreditation and internal dashboards
- Translate stakeholder requests into clear requirements, user stories and acceptance criteria
- Evaluate current data systems and recommend improvements in architecture, tooling and process
- Use version control (Git), code review and change management for all pipeline and database code
- Share project status, risks and changes with stakeholders and leadership
- Perform other related duties as assigned
Skills
- 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
- A culture of care: treating people with warmth, respect, and genuine care
- Opportunities to build your skills, pursue professional development, and grow alongside the University
- Talented, collaborative colleagues committed to helping one another succeed
Company Overview