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 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.