[Hiring] Data Warehouse Developer @Rice University

Role Description

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
• Analytics

Executes all programming tasks, including:

• Programming
• Analyzing
• Designing
• Developing
• Implementing
• Modifying
• Maintaining computer programs

Qualifications

• Bachelor’s Degree
• Two or more (2+) years of related professional work experience
• In lieu of the education requirement, additional related experience may be substituted on an equivalent year-for-year basis
• In lieu of the experience requirement, additional related education may be substituted on an equivalent year-for-year basis

Requirements

• 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
• Performs other duties as assigned to support departmental and institutional priorities

Benefits

• For details, visit Rice University Benefits