Reporting Engineer

Colorado State University; Fort Collins (CO); Hybrid; USD 67,000 - 81,000; Full time

Job summary

Colorado State University seeks a data reporting specialist to develop and support reporting solutions for its $600M+ research enterprise, using Power BI, SQL, and ETL tooling to deliver accurate, timely data.

You will design data flows and models, build dashboards and datasets, verify data across systems, prepare reports for sponsors and agencies, and train faculty and staff on reporting tools.

Qualifications

• Experience building data reports and dashboards with Power BI or similar tools.
• Proficiency in SQL for querying databases.
• Experience developing data flows and data models for reporting.
• Familiarity with ETL tools and data integration across sources.

Responsibilities

• Develop reports and dashboards using Power BI, BIRT, or Sisense and SQL to provide timely research data.
• Create and maintain data flows, models, and datasets in Power BI using DAX and Power Query.
• Develop ETL processes with Pentaho and Boomi to integrate data from databases and cloud services.
• Support data warehouse reporting and verify data consistency across systems.
• Prepare data for federal agencies, sponsors, and internal stakeholders.
• Train faculty and staff on reporting tools and document procedures.

Skills

Data modeling

Reporting & dashboards

SQL querying

Education

Bachelor's degree in Computer Information Systems, Computer Science, Accounting, or related field

High school/GED with equivalent IT or accounting experience

Tools

Power BI

BIRT

Sisense

SQL

Pentaho

Boomi

Job description

Eligible for hybrid/on-site work

Fort Collins, CO

Full time

R2026107857

Job Description

Position Summary:

Develops and supports reporting solutions integral to the administration of Colorado State University's $600M+ research enterprise, working within the OVPR reporting and analytics area. Core functions include data modeling, interactive report and dashboard development, application support, and faculty and staff training and support. The position supports multiple reports, dashboards, and applications used by college and department business officers, research administrators, and faculty, and contributes the underlying data models and datasets that support research performance reporting and analysis for the university. These applications and reports are critical to the administrative, business process, and communications needs of the research mission.

Essential Job Duties:

• Develop custom data reports and dashboards using various reporting tools (e.g., Power BI, BIRT, Sisense) or direct SQL, so that college and department business officers, research administrators, and faculty have accurate and timely research data.

• Develop and maintain data flows, data models, and datasets in Power BI using DAX and Power Query, establishing reusable structures that support recurring reporting and analysis needs across the reporting and analytics area.

• Develop and maintain custom ETL processes, including current in-house developed solutions and common tools (e.g., Pentaho, Boomi), integrating data from databases, cloud services, and web APIs across multiple SaaS vendors.

• Support ETL processes for the central University data warehouse and verify reporting accuracy, so that research data is consistent 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 contained in multiple databases, working directly 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, so that reporting work is transparent and directed to the highest-value needs.

• 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.

Conditions of Employment:

• Pre-employment criminal background check required for all new hires.

• Occasional travel to conferences, seminars, and professional association meetings.

• Applicant must be authorization to work in the United States without the need for visa sponsorship.

Minimum Qualifications:

• Bachelor's degree in Computer Information Systems, Computer Science, Accounting, or a related field; or high school graduation/GED and 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 in using SQL for querying databases or data sources.

Preferred Qualifications:

• 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 (RDBMS).

• Familiarity with standard accounting practices.

• Continuous learning mindset and willingness to stay up to date with evolving technology and best practices in data reporting, analytics, and platform architecture.

Salary Range

$67,000 - $81,000

Employee Benefits

Colorado State University is not just a workplace; it is a thriving community that is transforming lives and improving the human condition through world-class teaching, research, and service. With a robust benefits package, collaborative atmosphere, and focus on work-life balance, CSU is where you can thrive, grow, and make a lasting impact.

• Review our detailed benefits information here. (http://hr.colostate.edu/wp-content/uploads/sites/25/2021/01/benefits-summary-afap.pdf)

• Explore the additional perks of working at CSU here.

• For the total value of CSU benefits in addition to wages, use our compensation calculator. (http://hr.colostate.edu/total-compensation-calculator/)

• Lastly, click here for more information about why Fort Collins is consistently ranked in the top cities to live in!

Background Check Policy Statement

Colorado State University strives to provide a safe study, work, and living environment for its faculty, staff, volunteers and students. To support this environment and comply with applicable laws and regulations, CSU conducts background checks for the finalist before a final offer. The type of background check conducted varies by position and can include, but is not limited to, criminal history, sex offender registry, motor vehicle history, financial history, and/or education verification. Background checks will also be conducted when required by law or contract and when, in the discretion of the University, it is reasonable and prudent to do so.

EEO

Colorado State University (CSU) provides equal employment opportunities to all applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Inspired by its land-grant heritage, Colorado State University is committed to excellence and engagement, setting the standard for public research universities in teaching, research, service and extension for the benefit of the citizens of Colorado, the United States, and the world.

Prospective Employees, click here to learn more about CSU's perks and purpose. (https://hr.colostate.edu/prospective-employees/)

Current employees will need to apply for jobs in Workday.