IT DATA ANALYTICS ENGINEER

The IT Data Analytics Engineer role at the College of Western Idaho is designed to design and sustain data pipelines and the analytics platform. This hands-on position centers on transforming data in Microsoft Fabric and delivering analytics-ready datasets across the organization.

Responsibilities

• Build and maintain Microsoft Fabric notebooks to transform operational data for analytics-ready consumption
• Collaborate with the data warehouse architect and analysts to create and sustain curated tables, provide technical guidance, and optimize pipelines for efficiency and consistency
• Use SQL, Spark, and Python transformation patterns to generate clean, validated analytics-ready datasets
• Validate data quality and consistency across curated layers, document findings and resolutions, and map data entry and data flow through centrally managed systems
• Assess enterprise application data against systems of record and understand how data is defined and used within those systems
• Partner with IT application teams and analysts to support system and internal IT reporting needs, aligning workspace design with the foundational data warehouse architecture
• Maintain documentation and ensure standards compliance across all analytics engineering deliverables
• Support designated Microsoft Fabric workspaces within governance and architectural standards
• Organize and manage analytics assets across development, testing, and production environments
• Create workspaces and apply access controls as directed by platform and governance owners
• Collaborate with data governance to implement uniform transformations and data cleansing across the data pipeline in line with approved rules
• Identify, triage, and escalate platform or data issues to maintain pipeline and workspace reliability
• Version control notebooks and transformation assets using GitHub Enterprise
• Adhere to 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
• Collaborate with IT teams and business units to align on data contracts and delivery expectations

Requirements

• 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, able to document complex data logic clearly for engineers and non-technical stakeholders

Technologies

• Microsoft Fabric
• Azure SQL Managed Instance
• SQL
• Spark
• Python
• GitHub Enterprise
• Git

Additional information for applicants

Most College of Western Idaho roles are in person on campus. Some positions may allow up to two remote workdays per week, with eligibility determined case by case by the hiring manager. All candidates must reside within, or be willing to relocate to, a reasonable commute distance from CWI. Visa sponsorship is not available for this position.

Interested in applying

We welcome applications from all qualified candidates. Your experience and skills will be considered even if they do not exactly align with every listed requirement.