Data Engineer

This is a fully remote position, open to applicants in Utah.

📋 Description

• Design, develop, and sustain ETL/ELT pipelines that load data from SIS, LMS, CRM, and external sources.

• Create integrations using APIs, flat files, and database connections, incorporating scheduled and incremental loads.

• Oversee pipeline executions, establish alerting mechanisms, and promptly rectify failures with documented root-cause analysis.

• Architect and manage the University data warehouse utilizing dimensional modeling, including star schemas, conformed dimensions, and slowly changing dimensions.

• Develop curated, reusable datasets for enrollment, retention, course success, financial aid, and finance.

• Optimize SQL Server performance through indexing, partitioning, and query tuning.

• Implement automated data-quality checks and reconcile warehouse data against source systems.

• Enforce role-based access, encryption, and data masking to adhere to FERPA, GLBA, and University policies.

• Provide data sources and semantic models for Sigma and assist report builders.

• Ensure accurate data provision for IPEDS, accreditation, and internal reporting purposes.

• Convert stakeholder requests into requirements, user stories, and acceptance criteria.

• Assess data systems and propose enhancements in architecture, tools, and processes.

• Utilize Git, conduct code reviews, and manage changes for pipeline and database code.

• Communicate project status, risks, and changes with stakeholders and leadership.

• Undertake additional related duties as assigned.

⛳️ Requirements

• Bachelor’s degree in computer science, information systems, data science, or a related discipline, or an equivalent combination of education and experience.

• 3+ years of experience in building and supporting data pipelines or data warehouses within a production setting.

• Proficient SQL skills, including complex queries, stored procedures, and performance tuning, preferably in Snowflake.

• Practical experience with at least one ETL tool, such as SSIS, Azure Data Factory, dbt, or similar.

• Familiarity with dimensional data modeling and data warehouse design.

• Experience with at least one scripting language, such as Python or PowerShell, for automation and data manipulation.

• Strong written and verbal communication skills to engage both technical and non-technical team members.

🏝️ Benefits

• Self-directed paid time off.

• 12 paid holidays.

• Medical, dental, and vision insurance.

• Employer-covered short-term and long-term disability benefits.

• 401(k) retirement plan.

• Opportunities for professional development.

• Continuing education opportunities.

• A mission-driven workplace dedicated to healthcare education and student success.

• Flexibility to work fully remote or in a hybrid setup from our Draper, Utah campus.