Data Warehouse Developer

Position Summary:

The Data Warehouse Developer is responsible for supporting the data warehouse and analytics ecosystems for Rice University. Under supervision, they will develop and maintain data engineering code and pipelines for loading into the Enterprise Data Warehouse. 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.

Special Instructions to Applicants:

All interested applicants should attach a resume and cover letter in the Supporting Documents section of the application, preferably in PDF format.

This position is not eligible for employment visa sponsorship. Applicants must be authorized to work in the United States without requiring employer sponsorship now or in the future.

Ideal Candidate Statement:

The ideal candidate operates comfortably at the intersection of stakeholder partnership and advanced analytics. You combine strong technical execution with the ability to translate complex institutional needs into rigorous, reproducible analytical solutions using Python, R, and/or SQL. You have substantial experience with best practices in data collection and management, understand the interconnected nature of admissions, student, HR, research, and finance data, and can apply advanced statistical and predictive modeling techniques to deepen and extend existing reporting and analytical practices. As a mentor and technical leader, you will help the team broaden its analytical toolkit—building on a strong foundation of descriptive analysis to incorporate predictive and prescriptive approaches that inform institutional strategy.

Workplace Requirements:

This position is fully remote, permitting all tasks to be completed from any location within the United States. Working hours will remain at Central Standard Time. Per Rice policy 440, work arrangements may be subject to change.

Hiring Range: $73,326 - $85,000 annually (commensurate with experience)

This is an exempt (salaried) position under FLSA and not eligible for overtime.

Minimum Requirements:

• Bachelor’s Degree
  • In lieu of the education requirement, additional related experience, above and beyond what is required, may be substituted on an equivalent year-for-year basis.
• Two or more (2+) year of related professional work experience.
  • In lieu of the experience requirement, additional related education above and beyond what is required may be substituted on an equivalent year-for-year basis.
• Skills:
  • Familiarity in business intelligence and data warehousing concepts and methodologies.
  • Excellent programming, relational database skills, including hands on knowledge of SQL and PL/SQL.
  • Beginner proficiency in implementing ETL’s extracting data through XML files, RDBMS, REST APIs, and flat file sources.
  • Entry level programming skills such as Python, R, C/C++, Java, Shell, and Perl.
  • Familiarity with cloud data platforms such as Snowflake, AWS, or Azure
  • Familiarity with databases, data acquisition, ETL strategies, tools, and technologies such as Informatica (IICS).
  • Ability to work well as a team member under the direction of senior developers.
  • High proficiency to analyze problems and recommend solutions.

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 in prototyping systems for collecting, storing, and analyzing data at scale.
• Understanding of fundamentals in data modeling and designing data warehouses from heterogeneous sources.
• Familiarity 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.
• Excellent organizational and time-management skills.

Essential Functions:

• Implements complex data table structures, forms, reports, and queries.
• Follow up with other technical staff to identify and define gaps in requirements and processes.
• Collaborates closely with internal and external …