IT DATA ANALYTICS ENGINEER

The College of Western Idaho invites applications for an IT Data Analytics Engineer. This hybrid role based in Nampa, Idaho focuses on building and maintaining data pipelines and the analytics platform. You will actively transform data within Microsoft Fabric and deliver analytics-ready datasets that support departments across the enterprise. This hands-on position offers direct ownership of data workflows and the chance to shape how data is collected, organized, and consumed.

Responsibilities

• Create and maintain Microsoft Fabric notebooks to transform operational data for analytics-ready consumption.
• Collaborate with the data warehouse architect and analysts to build and maintain curated tables, provide technical guidance, and optimize pipelines for performance and consistency.
• Employ SQL, Spark, and Python transformation patterns to produce clean, validated analytics-ready datasets.
• Assess data quality across curated layers, document findings and resolutions, and partner with enterprise application teams to map data entry and data flow through centrally managed systems.
• Ensure enterprise application data aligns with systems of record, understanding definitions and usage.
• Support system reporting and internal IT reporting needs by partnering with IT application teams and analysts; align workspace design with the foundational data warehouse architecture.
• Maintain documentation and ensure standards compliance across all analytics engineering deliverables.
• Support assigned Microsoft Fabric workspaces within 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.
• 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 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, with the ability to document complex data logic clearly for both engineers and non-technical stakeholders.

Technologies

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

Additional information 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.

Interested?

We invite and welcome all applicants and look forward to receiving your application. Qualifications need not precisely match the job description to be considered for this role.