What are the responsibilities and job description for the Data Warehouse Developer/Analyst position at Rice University?
Job Description
Special Instructions to Applicants: All interested applicants, please attach a cover letter and resume in PDF format.
About Rice
Boasting a 300-acre tree-lined campus in Houston, Texas, Rice University is ranked among the nation’s top 20 universities by U.S. News & World Report. Rice has a 6-to-1 undergraduate student-to-faculty ratio, and a residential college system, which supports students intellectually, emotionally and culturally through social events, intramural sports, student plays, lectures series, courses and student government. Developing close-knit, diverse college communities is a strong campus tradition, which is why Rice is highly ranked for best quality of life and best value among private universities.
Rice is also a wonderful place to work. Rice faculty, staff and students share values that are essential to our success as a healthy community. Those values guide our decisions and behaviors and shape Rice’s culture. They come through in the way we treat each other and the welcome we extend to our visitors. These values can be recalled simply by our name — RICE — Responsibility, Integrity, Community and Excellence.
Position Summary
The Data Warehouse Developer is responsible for supporting the data warehouse and analytics ecosystems for Rice University. Under limited direction, develops and maintains data engineering code and pipelines for loading into the Enterprise Data Warehouse and Data Lakehouse. The work of the Data Warehouse Developer includes data integration, data management, and analytics. Executes all programming tasks, including programming, analyzing, designing, developing, implementing, modifying, and maintaining computer programs.
Workplace Requirements
This position is offered as a hybrid role, combining both in-office and remote work to provide flexibility and support collaboration. Monday – Friday 8:00 am to 5:00 pm. Per Rice policy 440 , work arrangements may be subject to change.
Proposed Hiring Range
Expected minimum salary of $90,000, dependent on experience and qualifications.
Minimum Requirements
Rice Mission and Values: Mission and Values | Rice University
Rice University is an Equal Opportunity Employer committed to diversity at all levels and considers for employment qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national or ethnic origin, genetic information, disability, or protected veteran status.
Rice University is committed to ensuring Equal Employment Opportunity and the full inclusion of all qualified persons in the workplace. This commitment includes providing reasonable accommodations to persons with disabilities. For applicants with disabilities who require a reasonable accommodation for any part of the application or hiring process, please contact Rice University’s Disability Resource Center at 713-348-5841 or adarice@rice.edu for support.
Special Instructions to Applicants: All interested applicants, please attach a cover letter and resume in PDF format.
About Rice
Boasting a 300-acre tree-lined campus in Houston, Texas, Rice University is ranked among the nation’s top 20 universities by U.S. News & World Report. Rice has a 6-to-1 undergraduate student-to-faculty ratio, and a residential college system, which supports students intellectually, emotionally and culturally through social events, intramural sports, student plays, lectures series, courses and student government. Developing close-knit, diverse college communities is a strong campus tradition, which is why Rice is highly ranked for best quality of life and best value among private universities.
Rice is also a wonderful place to work. Rice faculty, staff and students share values that are essential to our success as a healthy community. Those values guide our decisions and behaviors and shape Rice’s culture. They come through in the way we treat each other and the welcome we extend to our visitors. These values can be recalled simply by our name — RICE — Responsibility, Integrity, Community and Excellence.
Position Summary
The Data Warehouse Developer is responsible for supporting the data warehouse and analytics ecosystems for Rice University. Under limited direction, develops and maintains data engineering code and pipelines for loading into the Enterprise Data Warehouse and Data Lakehouse. The work of the Data Warehouse Developer includes data integration, data management, and analytics. Executes all programming tasks, including programming, analyzing, designing, developing, implementing, modifying, and maintaining computer programs.
Workplace Requirements
This position is offered as a hybrid role, combining both in-office and remote work to provide flexibility and support collaboration. Monday – Friday 8:00 am to 5:00 pm. Per Rice policy 440 , work arrangements may be subject to change.
Proposed Hiring Range
Expected minimum salary of $90,000, dependent on experience and qualifications.
Minimum Requirements
- Bachelor’s Degree
- In lieu of the education requirement, additional related experience, above and beyond what is required, on an equivalent year for year basis may be substituted
- 2 or more years of related experience
- I n lieu of the experience requirement, additional related education, above and beyond what is required, on an equivalent year-for-year basis may be substituted
- Skills:
- Mastery in business intelligence and data warehousing concepts and methodologies
- Excellent programming, relational database skills, including expertise knowledge of SQL and PL / SQL
- Proficiency in designing complex ETL’s extracting data through XML files, RDBMS, REST APIs, and flat file sources
- Excellent programming skills such as Python, R, C/C , Java, Shell and Perl
- Familiarity with cloud data platforms such as Snowflake
- Expert level in databases, data acquisition, ETL strategies, tools and technologies such as Informatica (IICS)
- Ability to work well independently or as a team member
- Ability to collaborate with vendors and system service providers, provide administration for system solutions, and act as a liaison
- High proficiency to analyze and solve problems of complex scope independently
- Bachelor’s degree in Computer Science, Information Technology, Business Administration, or a related field.
- Experience with higher education data systems and processes.
- Familiarity with cloud-based data warehousing solutions (e.g., AWS Redshift, Google BigQuery, Microsoft Azure).
- Knowledge in multiple existing and next generation data engineering and pipeline tools
- Proficient with designing and building systems for collecting, storing, and analyzing data at scale
- Proficiency in data modeling and designing data warehouse from heterogeneous sources
- Proficient with implementing systems and processes to monitor data quality
- Knowledge of Tableau or comparable analytics tools
- Proficient in data mining, visualization, and machine learning skills
- Understanding of predictive modeling, NLP, and machine learning
- Excellent organizational and time-management skills.
- Designs and deploys complex data table structures, forms, reports, and queries.
- Coordinates and works with other technical staff to develop a data warehouse and data lakehouse.
- Collaborates closely with internal and external teams to understand and apply changes/modifications impacting the data warehouse
- Identifies inefficiencies in current databases and investigates solutions
- Diagnoses and resolves database access and performance issues
- Plans and coordinates data migrations between systems
- Develops, implements, and maintains change control and testing processes for modifications to databases
- Develops and maintains the data pipelines and code
- Ensures all database systems meet business and performance requirements
- Produces ad-hoc queries and develops reports to support business needs
- Creates and maintains technical documentation
- Develops and maintains Data Warehouse
- Monitors ETL processes, system audits, analytics platform, dashboard reporting, and presentation layer functioning and performance
- Performs and provides results in quality control testing
- Oversees the release cycle process and ensures timely implementation of bug fixes, change requests, and enhancements
- Performs all other duties as assigned
Rice Mission and Values: Mission and Values | Rice University
Rice University is an Equal Opportunity Employer committed to diversity at all levels and considers for employment qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national or ethnic origin, genetic information, disability, or protected veteran status.
Rice University is committed to ensuring Equal Employment Opportunity and the full inclusion of all qualified persons in the workplace. This commitment includes providing reasonable accommodations to persons with disabilities. For applicants with disabilities who require a reasonable accommodation for any part of the application or hiring process, please contact Rice University’s Disability Resource Center at 713-348-5841 or adarice@rice.edu for support.
Salary : $90,000