Data Warehouse Developer

Rice University•Houston, TX

1d•Remote

About The Position

The Data Warehouse Developer supports Rice University’s data warehouse and analytics ecosystems. Under supervision, the role develops and maintains data engineering code and pipelines that load data into the Enterprise Data Warehouse. Work includes data integration, data management, analytics, and programming tasks such as analyzing, designing, developing, implementing, modifying, and maintaining computer programs. The position is fully remote, with work permitted from any location within the United States. Working hours remain on Central Standard Time, and work arrangements may be subject to change under Rice policy 440. This is an exempt, salaried position and is not eligible for overtime. Applicants must be authorized to work in the United States without employer sponsorship now or in the future. The ideal candidate combines technical execution and stakeholder partnership to translate institutional needs into rigorous, reproducible analytical solutions using Python, R, and/or SQL. They bring substantial experience with data collection and management, understand connections among admissions, student, HR, research, and finance data, and can apply advanced statistical and predictive modeling to extend reporting and analytics. The role also provides mentorship and technical leadership as the team develops predictive and prescriptive approaches to inform institutional strategy.

Requirements

Bachelor’s degree, or additional related experience beyond the required experience on an equivalent year-for-year basis.
At least two years of related professional work experience, or additional related education beyond the required education on an equivalent year-for-year basis.
Familiarity with business intelligence and data warehousing concepts and methodologies.
Excellent programming and relational database skills, including hands-on knowledge of SQL and PL/SQL.
Beginner proficiency implementing ETL processes that extract data from XML files, RDBMS, REST APIs, and flat-file sources.
Entry-level programming skills in one or more of 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 in analyzing problems and recommending solutions.

Nice To Haves

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 such as AWS Redshift, Google BigQuery, or Microsoft Azure.
Knowledge of multiple existing and next-generation data engineering and pipeline tools.
Proficiency prototyping systems for collecting, storing, and analyzing data at scale.
Understanding of data-modeling fundamentals and designing data warehouses from heterogeneous sources.
Familiarity with implementing systems and processes to monitor data quality.
Knowledge of Tableau or comparable analytics tools.
Proficiency in data mining, visualization, and machine learning.
Excellent organizational and time-management skills.

Responsibilities

Implement complex data table structures, forms, reports, and queries.
Follow up with technical staff to identify and define gaps in requirements and processes.
Collaborate with internal and external teams to understand and apply changes affecting the data warehouse.
Identify inefficiencies in current databases and investigate solutions.
Uncover database access and performance issues for further analysis.
Participate in data migrations between systems and own parts of the migration plan.
Follow change-control and testing processes for database modifications.
Develop and maintain data pipelines and code.
Ensure database systems meet business and performance requirements.
Produce ad-hoc queries and develop reports to support business needs.
Create and maintain technical documentation.
Develop and maintain the Data Warehouse.
Monitor ETL processes, system audits, the analytics platform, dashboard reporting, and presentation-layer functionality and performance.
Perform quality-control testing and provide results.
Participate in the release cycle and ensure timely implementation of bug fixes, change requests, and enhancements.
Contribute to special projects and emerging priorities in support of departmental and institutional goals.
Perform other duties as assigned to support departmental and institutional priorities.