Data Warehouse Developer/Analyst

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  
  • In 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

Preferences:

• 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