Talent.com
Data Architect and Report Developer

Data Architect and Report Developer

Colorado State UniversityFort Collins, CO
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

The Data Architect and Report Developer serves the office by writing both simple and complex SQL code to extract data for reporting and / or use in research projects that inform institutional decision-making.

With supervision, the position applies database architecture and management principles to oversee data extracts within the IRPE Oracle database to ensure tables, views, and / or extracts are designed to meet BI reporting standards. This is in support of creating a student data reporting structure for campus to utilize and for building data extracts for BI or R reporting. Again, with supervision, the position applies database architecture and management principles to oversee the collection of co-curricular student activities into the student information system and then within the IPRE Oracle database to ensure campus can accurately record participation and merge with student success data.

Additionally, the position serves as a report developer using industry standard tools to create standardized reports following established office protocols and documentation; includes both hard copy and online BI reporting (current tools are Power BI and R Studio).

This is a hybrid working position. Hybrid schedules are allowed; however, weekly in-person days in Fort Collins are required. The successful candidate must be legally authorized to work in the United States by the time of hire. Institutional Research, Planning and Effectiveness will not provide visa sponsorship for this position. Required Job Qualifications

  • Bachelors Degree in related field.
  • Experience using SQL programming.
  • Experience working with relational databases.
  • Experience with report development utilizing automated processes.
  • Experience reviewing data and reports, identify data inconsistencies, and take initiative to provide solutions.
  • Demonstrated ability to work effectively with members of a team, with willingness to serve as a resource to others.
  • The successful candidate must be legally authorized to work in the United States by the time of hire. Institutional Research, Planning and Effectiveness will not provide visa sponsorship for this position.

Preferred Job Qualifications

  • Masters degree in related field.
  • Experience with higher education data report creation.
  • Knowledge and experience with Banner ODS.
  • Experience with Power BI and Fabric.
  • Experience with R Studio, including functional programming and report rendering with Quarto. Experience in data warehouse design and development.
  • Experience with and skill in ETL performance tuning.
  • Strong communications skills with ability to organize and present information clearly in analyses and reports.

    • Essential Duties Job Duty Category Data Architecture Management / SQL Programming Duty / Responsibility

  • With limited supervision, creates and uses SQL to gather institutional data from enterprise systems (HR, student, finance, LMS etc.) to further the processes of accreditation, institutional research, program review, and strategic planning.
  • With limited supervision, submits data to outside entities and / or assists with external survey reporting by writing complex SQL code to extract data from an Oracle database,
  • Support the office in developing processes and policies to ensure captured data reflects the university priorities, including the creation of new data pipelines the co-curricular data pipelines).
  • Employs knowledge of university policies, process, and reporting schedules to ensure data are appropriately and cleanly captured.
  • Supports the maintenance of reporting data dictionary to ensure accurate definitions and data source tracing within the Oracle database and Power BI. Additionally, supports the maintenance of IR data glossary on IRs website.

    • Percentage Of Time 40 Job Duty Category Report Development Duty / Responsibility

  • Creates and maintains interactive reports to inform institutional decision-making using industry standard tools (current tool is Power BI).
  • Creates and maintains automated hard-copy reports to inform institutional decision-making using industry standard tools (current tool is R).
  • Serves as the office resource for Power BI, R, and website display of reports.
  • Maintains documentation for all reports.
  • Contributes to the review of office reports to validate and ensure consistency in reporting.
  • Serves as an office expert for business intelligence reporting.

    • Percentage Of Time 40 Job Duty Category Collaboration, Communication, Documentation Duty / Responsibility

  • Communicates effectively within the office to understand and meet campus data needs.
  • Communicates effectively with campus stakeholders to understand and meet their data needs; Contributes to university data literacy training and support.
  • Communicates with external stakeholders to provide data needed for university initiatives and adjusts the IRPE data infrastructure to support those initiatives; specifically the PDP data collection
  • Prepares written procedures, documentation, and narratives to ensure consistency over time and across staff.

    • Percentage Of Time 20 Application Details

    serp_jobs.job_alerts.create_a_job

    Data Architect • Fort Collins, CO