Hybrid Reporting Engineer: Research Data Dashboards

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

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.