C

Colorado State University

Reporting Engineer

Business IntelligenceUpdated on Nov 15
Full-timeFort Collins, CO, USA$67k - $81k

About the Job

Requirements

  • A bachelor's degree in Computer Information Systems, Computer Science, Accounting, or a related field, or high school graduation/GED with equivalent demonstrated IT or accounting experience.
  • Experience developing data flows, data models, reports, and dashboards using Power BI or a similar data modeling/reporting tool.
  • Proficiency using SQL to query databases or data sources.

Responsibilities

  • Develop custom data reports and dashboards using reporting tools such as Power BI, BIRT, or Sisense, or direct SQL, to provide accurate and timely research data to college and department business officers, research administrators, and faculty.
  • Develop and maintain data flows, data models, and datasets in Power BI using DAX and Power Query, establishing reusable structures for recurring reporting and analysis.
  • Develop and maintain custom ETL processes, including in-house solutions and tools such as Pentaho and Boomi, integrating data from databases, cloud services, and web APIs across SaaS vendors.
  • Support ETL processes for the central University data warehouse and verify reporting accuracy to ensure consistency across university systems and reporting products.
  • Prepare and provide University data to federal agencies, sponsors, and other internal and external stakeholders in response to recurring and ad hoc reporting requirements.
  • Serve as a subject matter expert for University research data in multiple databases and work with database administrators to construct scripts, tables, database views, and schemas for research data needs.
  • Monitor incoming report requests and assist with prioritizing and communicating request status to stakeholders.
  • Document technical solutions and reporting-tool procedures for non-technical stakeholders, and train faculty and staff on new and current reporting products.
  • Interact with administrative, academic, and operational stakeholders to gather requirements, troubleshoot issues, and identify strategic improvements to reporting products.
  • Travel occasionally to conferences, seminars, and professional association meetings.

Desired Qualifications

  • At least 2 years of experience with Power BI, including designing data flows and data models, creating datasets, and building interactive dashboards and reports.
  • Proficiency using DAX and Power Query for data manipulation, extraction, and transformation within Power BI.
  • Experience with Kuali Research and/or Kuali Finance software.
  • Previous experience with ETL tools and process development incorporating diverse data sources such as databases, cloud services, and APIs.
  • Proficiency using Oracle, MySQL, or another relational database management system.
  • Familiarity with standard accounting practices.
  • Willingness to stay up to date with evolving technology and best practices in data reporting, analytics, and platform architecture.

About the Company

Company size
Not listed
Company stage
Not listed
Total funding
Not listed
Headquarters
Not listed
Founded
Not listed

Recently Posted Jobs

Explore more opportunities at Colorado State University

See more jobs