Data Warehouse Developer/Analyst

Rice University Minimal Template External Career Site

2d•$90,000•Hybrid

About The Position

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.

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

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

Responsibilities

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 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
Oversees the release cycle process and ensures timely implementation of bug fixes, change requests, and enhancements
Performs all other duties as assigned