Data Engineer

Job Description:

• 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