Experience Inc. Jobs

Special Instructions to Applicants:

All interested applicants, please attach a cover letter and resume in PDF format.

Position Summary:

The Data Warehouse Developer is responsible for supporting the data warehouse and analytics ecosystems for Rice University. Under limited direction, develops and maintains data engineering code and pipelines for loading into the Enterprise Data Warehouse and Data Lakehouse. 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.

Workplace Requirements

This position is offered as a hybrid role, combining both in-office and remote work to provide flexibility and support collaboration. Monday - Friday 8:00 am to 5:00 pm. Per Rice policy 440 , work arrangements may be subject to change.

Proposed Hiring Range:

Expected minimum salary of $90,000, dependent on experience and qualifications.

Minimum Requirements:

• Bachelor's Degree
  • In lieu of the education requirement, additional related experience, above and beyond what is required, on an equivalent year for year basis may be substituted
• 2 or more years of related experience
  • In lieu of the experience requirement, additional related education, above and beyond what is required, on an equivalent year-for-year basis may be substituted
• Skills:
  • Mastery in business intelligence and data warehousing concepts and methodologies
  • Excellent programming, relational database skills, including expertise knowledge of SQL and PL / SQL
  • Proficiency in designing complex ETL's extracting data through XML files, RDBMS, REST APIs, and flat file sources
  • Excellent programming skills such as Python, R, C/C , Java, Shell and Perl
  • Familiarity with cloud data platforms such as Snowflake
  • Expert level in databases, data acquisition, ETL strategies, tools and technologies such as Informatica (IICS)
  • Ability to work well independently or as a team member
  • Ability to collaborate with vendors and system service providers, provide administration for system solutions, and act as a liaison
  • High proficiency to analyze and solve problems of complex scope independently

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 with designing and building systems for collecting, storing, and analyzing data at scale
• Proficiency in data modeling and designing data warehouse from heterogeneous sources
• Proficient 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
• Understanding of predictive modeling, NLP, and machine learning
• Excellent organizational and time-management skills.

Essential Functions:

• Designs and deploys complex data table structures, forms, reports, and queries.
• Coordinates and works with other technical staff to develop a data warehouse and data lakehouse.
• 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
• Diagnoses and resolves database access and performance issues
• Plans and coordinates data migrations between systems
• Develops, implements, and maintains change control and testing processes for modifications to databases
• Develops and mainta ns 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
• Oversees the release cycle process and ensures timely implementation of bug fixes, change requests, and enhancements
• Performs all other duties as assigned

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

Rice Mission and Values: Mission and Values | Rice University

Rice University is an Equal Opportunity Employer committed to diversity at all levels. It considers for employment qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national or ethnic origin, genetic information, disability, or protected veteran status.

About Us

Boasting a 300-acre tree-lined campus in Houston, Rice University is ranked among the nation's top 20 universities by U.S. News and World Report. Rice has a 6-to-1 undergraduate student-to-faculty ratio, and a residential college system, which supports students intellectually, emotionally and culturally through social events, intramural sports, student plays, lectures series, courses and student government. Developing close-knit, diverse college communities is a strong campus tradition, which is why Rice is highly ranked for best quality of life and best value among private universities.

Equal Opportunity Employer - minorities/females/veterans/individuals with disabilities/sexual orientation/gender identity