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
• 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
• Founded in 1979, Joyce University of Nursing and Health Sciences, formerly Ameritech College of Healthcare, is an accredited university based in Draper, Utah, near Salt Lake City, specializing in pre- and post-licensure nursing education.
• 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

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

• Azure Data Factory, Data Warehousing, Dimensional Data Modeling, PowerShell, Python, SQL, SSIS, Snowflake, dbt

Preferred skills

• Written and Verbal Communication

Experience

• 3+ years