Data Warehouse Developer

Rice University; Houston (TX); Remote; USD 73,000 - 85,000; Full time

Job summary

Rice University seeks a Data Warehouse Developer to support its data warehouse and analytics ecosystem. You will develop and maintain data engineering code and pipelines for loading into the Enterprise Data Warehouse, handling data integration, management, and analytics.

The ideal candidate translates institutional needs into reproducible analytical solutions using Python, R, and SQL, mentoring teammates and expanding the analytics toolkit with descriptive, predictive, and prescriptive methods.

Qualifications

• Familiarity with BI and data warehousing concepts.
• Excellent programming and relational database skills, including SQL.
• Beginner to intermediate ETL experience with multiple data sources.
• Proficiency in Python, R, or similar scripting languages.
• Knowledge of Snowflake, AWS, or Azure cloud platforms.
• Experience with Informatica IICS and data tools.
• Ability to work in a team and analyze problems to propose solutions.

Responsibilities

• Develop and maintain data pipelines and code for the data warehouse.
• Collaborate with internal/external teams to apply changes impacting the warehouse.
• Produce ad-hoc queries and develop reports to support business needs.
• Identify inefficiencies and monitor data quality and performance.
• Create and maintain technical documentation and data warehouse components.
• Participate in data migrations and release cycles with proper change control.

Skills

SQL/PLSQL

ETL basics

Python

R

Cloud platforms

Informatica IICS

Teamwork

Analytical thinking

Education

Bachelor’s Degree

Tools

Snowflake

AWS

Azure

Informatica (IICS)

Job description

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.

Job Description

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

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+) yearof 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 teams to understand and apply changes/modifications impacting the data warehouse.
• Identifies inefficiencies in current databases and investigates solutions.
• Uncovers database access and performance issues for further analysis.
• Participates in data migrations between systems, owning parts of the migration plan.
• Adheres to 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.
• Participates in the release cycle process and ensures timely implementation of bug fixes, change requests, and enhancements.
• Performs all other duties as assigned.

Additional Functions

• Contributes to special projects and emerging priorities as needed to advance departmental and institutional goals. Duties may expand or shift in alignment with strategic initiatives.
• Performs other duties as assigned to support departmental and institutional priorities.

Rice University HR | Benefits: https://knowledgecafe.rice.edu/benefits

Rice Mission and Values: Mission and Values | Rice University

Rice University is committed to ensuring Equal Employment Opportunity and welcoming the fullness of diversity into our candidate pools. Rice considers qualified applicants for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national or ethnic origin, genetic information, disability, or protected veteran status. Rice also provides reasonable accommodations to qualified persons with disabilities. If an applicant requires a reasonable accommodation for any part of the application or hiring process, please get in touch with Rice University’s Human Resources Office via email at [e-mail] for support.

If you have any additional questions, please email us at [e-mail] . Thank you for your interest in employment with Rice University.