Enterprise Data Warehouse Architect

Posted on4/26/2018
Job typeFull-time
Reports toInformation Technology Department
Reports in officeInformation Technology Department
Application due dateopen until filled
Job start dateTBD
CityWinter Park
InstitutionRollins College
Institution descriptionRollins seeks to foster and to model a campus environment that is welcoming, safe, and inclusive to all of our administrators, faculty, staff, and students. We view differences (e.g. nationality, race, gender, age, sexual orientation, socioeconomic class, physical ability, learning styles, perspectives, etc.) not as obstacles to be overcome but as rich opportunities for understanding, learning, and growth.

Through its mission, Rollins College is firmly committed to creating a just community that embraces multiculturalism; persons from historically under-represented minority groups are therefore encouraged to apply. Rollins does not discriminate on the basis of sex, disability, race, age, religion, color, national or ethnic origin, ancestry, marital status, veteran status, sexual orientation, gender identity, gender expression, genetic information, physical characteristics, or any other category protected by federal, state, or local law, in its educational programs and activities.
Job dutiesThe Information Technology Department is seeking an experienced Enterprise Data Warehouse Architect to join their team.

Primary responsibilities include:

Database modelling & data warehouse architecture.
ETL processes, tools and query languages.
Establishing the framework for data quality and reliability.
Constructing the data architecture to establish a 21st century institutional data warehouse.
Monitor the data warehouse and business intelligence system performance and integrity, and provide corrective and preventative maintenance as required.
Design data warehouse schema and define extract/translate/load (ETL) processes for the data warehouse.
Research new opportunities for data acquisition.
Serves as a subject matter expert for all data contained within the data warehouse.
Creates, implements and enforces standard operating procedures, recommends policies and processes for existing and new services within the defined function/scope for enterprise data warehousing.
Diligently identifies and pursues data anomalies to ensure the highest level of data integrity.
QualificationsBachelor’s degree and certification in relevant major OR equivalent experience in the field. Master’s preferred.
Five years relevant experience.
Experience with data integration software (e.g. SAS Data Integration Studio).
Experience with database management system software (e.g. SQL Server).
Experience with ETL software.
Strong willingness to learn new technologies and lead change.
Understanding of data visualization, dashboard and infographic tools (e.g., Tableau, Qlik, SAS BI).
Experience designing and documenting ETL processes and tuning ETL performance.
Experience with higher education data.
Knowledge of logical and physical data modeling.
Strong willingness to learn new technologies and lead change.
Understanding of data visualization, dashboard and infographic tools (e.g., Tableau, Qlik, SAS BI).
Ability to juggle multiple projects.
Excellent communication and interpersonal skills.
Knowledge of Agile Scrum approaches for project management.
Salary rangeDependent on qualifications and experience
Salary benefitsMedical, dental, vision, and life insurance
Health reimbursement accounts
Flexible spending accounts
Employee assistance program
Generous paid time off
Flexible scheduling
Short-term disability
Long-term disability
403(b) retirement plan
Paid tuition for employees and dependents
Tuition assistance for other educational institutions
Same and opposite-sex domestic partner benefits
Paid holidays
Application procedureTo learn more and to apply please visit our website.