Edtech.com's Summary

The College of Western Idaho is hiring an IT Data Analytics Engineer. The role involves building and maintaining data pipelines within the Microsoft Fabric environment, transforming operational data into analytics-ready datasets to enhance data quality and usability for institutional decision-making across the college.

Highlights

Develop and maintain Microsoft Fabric notebooks to transform operational data for analytics use
Create and maintain curated data tables in collaboration with data warehouse architects and analysts
Apply SQL, Spark, and Python for data transformation and validation
Support Microsoft Fabric workspaces including access control and environment management
Version control notebooks and assets using GitHub Enterprise with pull requests and peer review
Bachelor's degree in relevant field or equivalent experience required
3–5 years of professional experience in analytics engineering, data engineering, or business intelligence
Strong proficiency with Microsoft Fabric analytics workloads, SQL, Spark, Python, and Git/GitHub Enterprise
Understanding of analytical data modeling principles, such as dimensional modeling and layered architecture
Collaborate with IT teams and stakeholders to align data contracts and delivery expectations

IT Data Analytics Engineer Full Description

Reports To:

Director, Enterprise Applications

Position Status:

FT - Full-Time

Position Summary:

The College of Western Idaho is looking for an IT Data Analytics Engineer who thrives at the intersection of data transformation, data engineering, and modern data platform development. This is not a report-writing or dashboard development role. It is a hands-on engineering position focused on building and maintaining a data pipeline that supports reliable, consistent analytics across CWI.

You'll work at the center of CWI's Microsoft Fabric environment, transforming mirrored operational data from Azure SQL Managed Instance into well-structured, analytics-ready datasets that serve the College's data and analytics team. Your work will serve as a critical technical bridge between source systems and data analysts, improving the quality, reliability, and usability of institutional data across the college.

Essential Functions:

Analytics Engineering & Data Preparation

• Develop and maintain Microsoft Fabric notebooks to transform and curate operational data for analytics consumption

• Working with the data warehouse architect and data analysts, create and maintain curated tables, provide technical expertise, and optimize the data pipeline for efficiency and consistency.

• Apply SQL, Spark, and/or Python transformation patterns to produce clean, validated, analytics-ready datasets

• Validate data quality and consistency across curated data layers, documenting findings and resolutions. Work with enterprise application team members to map application data entry and data flow through centrally managed systems.

• Validate enterprise application data against systems of record, developing an understanding of how the data is defined and used within those systems.

• Collaborate with information technology application team members and analysts to support system reporting and internal IT reporting needs. Partner with the data warehouse architect to align workspace design with the foundational data warehouse architecture, ensuring workspaces are effectively built to support the data and analytics team.

Maintain documentation and ensure standards compliance across all analytics engineering deliverables

Fabric Workspace Support

• Support assigned Microsoft Fabric workspaces within established governance and architectural standards

• Organize and manage analytics assets across Development, Test, and Production environments

• Create workspaces and apply workspace access controls as directed by platform and governance owners

• Work with data governance to implement uniform transformations and data cleansing across the data pipeline in alignment with approved business rules

• Identify, triage, and escalate platform or data issues as needed to maintain pipeline and workspace reliability

GitHub Enterprise & Collaboration

• Version control all notebooks and transformation assets using GitHub Enterprise

• Follow pull request and peer review practices to ensure code quality, consistency, and auditability

• Support controlled promotion of analytics assets across environments through established CI/CD patterns

• Partner with information technology team and business units to align on data contracts and delivery expectations

Minimum Qualifications:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent professional experience

• 3–5 years of professional experience in analytics engineering, data engineering, or business intelligence roles

• Hands-on experience with Microsoft Fabric analytics workloads, including notebooks, lakehouses, and curated datasets

• Strong SQL skills with working knowledge of Spark and/or Python for data transformation workflows

• Experience using Git or GitHub Enterprise, pull requests, branching strategies, and version-controlled development workflows

• Solid understanding of analytical data modeling principles, including dimensional modeling and layered data architecture

• Strong written and verbal communication skills, you can document complex data logic clearly for both engineers and non-technical stakeholders

Additional Instructions For Applicants:

Most positions at CWI are in-person and based on campus. While some roles may allow up to two remote workdays per week, eligibility for remote work is determined on a case-by-case basis at the hiring manager's discretion. All candidates must reside within, or be willing to relocate to, a reasonable commuting distance from CWI. Employment visa sponsorship is not available for this position.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, disability, veteran status, gender identity, sexual orientation, or any other applicable legally protected status.

Original Job Description