Data Engineer

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

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
• Joyce University of Nursing and Health Sciences is dedicated to preparing people to serve as competent healthcare professionals, to advance their careers, and to encourage the pursuit of lifelong learning.
• Draper, Utah, USA
• https://www.joyce.edu/
• Growth Stage
• Total Funding
• $6.8M
• Key Investors
• Main Street Capital
• 2012-03-15
• Debt Financing· $6.8M
• Leadership Team
• Shea Smith, CPA
• Chief Financial Officer
• Ray Rodriguez
• Chief Academic Officer and Vice President of Academic Affairs
• Recent News
• GlobeNewswire
• Joyce University Honors More Than 6,600 Nurses and Nursing Students During National Nurses Day Celebration
• 2026-05-11
• Morningstar.com
• Joyce University Secures Spot on Utah Business' 2025 Best Companies to Work For List for Third Straight Year

Qualifications

• 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
• 3+ years of experience building and supporting data pipelines or data warehouses in a production environment.

Required skills

• SQL, Snowflake, ETL, SSIS, Azure Data Factory, dbt, Dimensional Data Modeling, Data Warehouse Design, Python, PowerShell, Data Pipeline Development

Experience

• 3+ years