Data Warehouse Developer

Rice University•Houston, TX

8h•$73,326 - $85,000•Remote

About The Position

The Data Warehouse Developer supports Rice University’s data warehouse and analytics ecosystems. Under supervision, this role develops and maintains data-engineering code and pipelines for loading data into the Enterprise Data Warehouse. Work spans data integration, data management, and analytics, as well as programming tasks such as analyzing, designing, developing, implementing, modifying, and maintaining computer programs. The developer partners with stakeholders to translate institutional needs into rigorous, reproducible analytical solutions, using Python, R, and/or SQL. The role contributes to data collection and management practices across admissions, student, HR, research, and finance data, and may apply statistical and predictive modeling to expand existing reporting and analytics. The position also helps broaden the team’s analytical toolkit, building on descriptive analysis and incorporating predictive and prescriptive approaches to inform institutional strategy. This is a fully remote position; work may be performed 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. The position is salaried, exempt from overtime, and offers a hiring range of $73,326–$85,000 annually, commensurate with experience. Applicants must be authorized to work in the United States without current or future employer visa sponsorship. Applicants are asked to attach a resume and cover letter, preferably in PDF format.

Requirements

Bachelor’s degree; additional related experience beyond the stated requirement may substitute on an equivalent year-for-year basis.
Two or more years of related professional work experience; additional related education beyond the stated requirement may substitute 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 skills.
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 or modifications affecting the data warehouse.
Identify database inefficiencies 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 functioning and performance.
Perform quality-control testing and provide results.
Participate in release cycles and ensure timely implementation of bug fixes, change requests, and enhancements.
Contribute to special projects and emerging priorities supporting departmental and institutional goals; duties may shift to align with strategic initiatives.
Perform other duties as assigned to support departmental and institutional priorities.