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.
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 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
facstaffada@rice.edu for support.
If you have any additional questions, please email us at
jobs@rice.edu . Thank you for your
interest in employment with Rice University.