Data Analytics Engineer - Microsoft Fabric Pipelines

College of Western Idaho; Nampa, Northern (ID, KY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

The College of Western Idaho is seeking an IT Data Analytics Engineer to blend data transformation, engineering, and platform development. You will build and maintain a reliable data pipeline supporting analytics across CWI, transforming Azure SQL data into analytics-ready datasets for the analytics team.

As part of the Fabric environment, you’ll ensure data quality, collaborate with the data warehouse architect, and maintain comprehensive documentation while upholding governance and CI/CD

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or 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

Responsibilities

• Develop and maintain Microsoft Fabric notebooks to transform and curate operational data for analytics consumption
• Collaborate with the data warehouse architect and data analysts to create and maintain curated tables and optimize the data pipeline
• Apply SQL, Spark, and/or Python transformation patterns to produce clean, validated datasets
• Validate data quality and consistency across curated data layers and document findings
• Work with enterprise application teams to map data entry and data flow through centrally managed systems
• Support system reporting and internal IT reporting needs; align workspace design with data warehouse architecture
• Maintain documentation and ensure standards compliance across analytics engineering deliverables
• Version control notebooks/assets with GitHub Enterprise; participate in PRs and CI/CD processes

Skills

SQL

Spark

Python

Analytical thinking

Communication skills

Data modeling

Education

Bachelor's degree in Computer Science or related field

Tools

Microsoft Fabric

Azure SQL Managed Instance

Git / GitHub Enterprise

Job description

The College of Western Idaho is seeking an IT Data Analytics Engineer to blend data transformation, engineering, and platform development. You will build and maintain a reliable data pipeline supporting analytics across CWI, transforming Azure SQL data into analytics-ready datasets for the analytics team.

As part of the Fabric environment, you’ll ensure data quality, collaborate with the data warehouse architect, and maintain comprehensive documentation while upholding governance and CI/CD