Research Professional Position No
Posting Number 201700888AP
Position Type Admin Professional/ Research Professional Number of Vacancies 1 Work Hours/Week 40 Proposed Annual Salary Range Desired Start Date Position End Date (if temporary) Open Posting Date Open Until Filled Yes To ensure full consideration, applications must be received by 11:59pm (MT) on 12/10/2017
Description of Work Unit
Provide design, development, delivery and ongoing operation and support of Operational Data Store (ODS), data warehouse, and business intelligence solutions related to CSU’s central administrative systems.
Full time, permanent Data Architect position located in the Colorado State University’s (CSU) Central Information Systems Department (IS) in Fort Collins, CO. Position will be responsible for data analysis and designing data models, tables, views and developing and implementing associated data migration processes. Must have understanding of database administration role, and works with DBA’s to design tables/data structures to effectively support data access. Must have understanding of and practical knowledge working with Operational Data Store(s) (ODS), preferably with Ellucian Banner ODS. Must have experience in ETL architecture and development using Pentaho. Must have experience designing reports and dashboards. Must have experience in project management, including certification in Agile project management.
Required Job Qualifications
•Bachelor’s degree in Computer Science, Information Systems, or other related area; plus minimum 5 years’ experience with large-scale, enterprise database design and development. Significant experience in programming, debugging, development and analysis of automated processes is required.
•Working knowledge of Operational Data Store (ODS) design and development.
•Working knowledge of Dimensional data warehouse systems design and development.
•ETL architecture, development and automation using Pentaho in a Linux environment.
•Familiarity with logical data modeling and Oracle database physical modeling.
•Experience with designing reports from ODS as well as dimensional databases.
•Knowledge and experience with Banner ODS.
•Experience in star schema and data mart design.
•Experience and knowledge of data governance requirements.
•Experience with data modeling tools, including Erwin data modeling tool.
•Experience and skills in SQL performance tuning.
•Experience and skills in ETL performance tuning.
•Experience working in a higher education setting.
•Project lead/management experience.
•Certification in Agile Project Management.
Preferred Job Qualifications Diversity Statement
•Reflecting departmental and institutional values, candidates are expected to have the ability to advance the Department’s commitment to diversity and inclusion.
Job Duty Category Data Modeling/Analysis/Database Design Duty/Responsibility
Participates in communications with end-users and subject matter experts to understand the current state of data, and to identify information and reporting requirements that support the institution’s ODS, data warehousing, and business intelligence initiatives. These requirements include what data is being collected, how data flows through systems, and how/what data is being used and analyzed.
Based on understanding of current state and information requirements, designs and builds logical and physical data models and architectures to meet the requirements and desired future state. Participates in data model reviews with subject matter experts, developers and DBA’s to collaborate and gain consensus.
Functions as technical resource regarding future data warehouse/data mart design and implementation. Consults with functional areas to obtain related data and information requirements. Designs and builds data warehouse and data marts to support user requirements using appropriate methodologies, designing for efficient access and maintenance. Develop and maintain data models for data warehouse and data marts.
Works with DBA’s to translate logical data models into physical data models, and participates in database design and other architectures such as data marts.
Evolves the logical data model over time and works with developers and DBA’s to ensure it is leveraged across all projects.
Ensures data models are documented and kept up to date.
Percentage Of Time 50 Job Duty Category Data Loading and Delivery, Quality Assurance Duty/Responsibility
Designs efficient and effective Extraction, Transformation and Load (ETL) processes for targeted data stores. Using data mappings and ETL tool(s), develop routines for extracting data from operational systems. Integrate data appropriate for the ODS, data warehouse/data marts, and cleanse, transform, aggregate and summarize data as needed to populate the data warehouse.
Develop and implement quality assurance checks as routine part of incremental data loads to verify that ODS and warehouse data is correctly loaded from production data. Work with functional teams to test and verify ETL processes are working correctly and correct any problems with data mappings or incorrect data.
Percentage Of Time 25 Job Duty Category Team Participation Duty/Responsibility
Work collaboratively with BI – Data Warehouse Team colleagues, database administrators, developer staff, and stakeholders in the planning, implementation and support of major ODS, data warehouse/data mart and business intelligence projects and initiatives. Participate in ongoing University data governance groups and processes.
Participate in assigned team(s) in Information Systems Department, as well as occasional cross-functional teams. Attend team and project meetings, communicate effectively and support other team members.
Percentage Of Time 15 Job Duty Category Project and Work Management Duty/Responsibility
Learn and use the IS Department’s change and project management processes and software tools to enter and track assigned work activities and hours.
Percentage Of Time 5 Job Duty Category Personal and Professional Development Duty/Responsibility
Engage in training and educational opportunities to learn new technologies and enhance personal and professional growth.
Percentage Of Time 5 Application Details
Special Instructions to Applicants
For full consideration, please apply to this posting with a cover letter addressing the required qualifications, resume and 3 to 5 professional references. Review of applications will begin on 12/11/17.
References will not be contacted without prior notification of candidates.
Conditions of Employment Pre-employment Criminal Background Check (required for new hires) Search Contact Pat Spooner, Pat.Spooner@colostate.edu or 970-491-1587, EEO Statement
Colorado State University is committed to providing an environment that is free from discrimination and harassment based on race, age, creed, color, religion, national origin or ancestry, sex, gender, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or pregnancy and will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. Colorado State University is an equal opportunity/equal access/affirmative action employer fully committed to achieving a diverse workforce and complies with all Federal and Colorado State laws, regulations, and executive orders regarding non-discrimination and affirmative action. The Office of Equal Opportunity is located in 101 Student Services.
The Title IX Coordinator is the Executive Director of the Office of Support and Safety Assessment, 123 Student Services Building, Fort Collins, CO 80523 -2026, (970) 491-7407.
The Section 504 and ADA Coordinator is the Associate Vice President for Human Capital, Office of Equal Opportunity, 101 Student Services Building, Fort Collins, CO 80523-0160, (970) 491-5836.
Background Check Policy Statement
Colorado State University (CSU) 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. The type of background check conducted varies by position and can include, but is not limited to, criminal (felony and misdemeanor) history, sex offender registry, motor vehicle history, financial history, and/or education verification. Background checks will be conducted when required by law or contract and when, in the discretion of the university, it is reasonable and prudent to do so.
Minimum Requested 3 Maximum Requested 5 Supplemental Questions
Required fields are indicated with an asterisk (*).
Applicant Documents Required Documents
- Cover Letter