Data Warehouse Developer/Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

Rice University · 14 hours ago

Data Warehouse Developer/Analyst

Rice University is ranked among the nation’s top 20 universities and is seeking a Data Warehouse Developer/Analyst to support their data warehouse and analytics ecosystems. The role involves developing and maintaining data engineering code and pipelines, executing programming tasks, and collaborating with teams to enhance data management and integration.

EducationHigher EducationService IndustryUniversities
check
Growth Opportunities
check
H1B Sponsor Likelynote

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

Qualification

Data warehousing conceptsSQLPL/SQLETL designImplementationCloud data platformsInformatica (IICS)PythonData modelingData quality monitoringTableauAnalytics toolsProblem-solvingTeam collaborationOrganizational skills

Required

Bachelor's Degree
2+ or more years of related experience
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

Preferred

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

Company

Rice University

company-logo
Rice University is a private research university that focuses on providing undergraduate education services.

H1B Sponsorship

Rice University has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (113)
2024 (81)
2023 (71)
2022 (65)
2021 (82)
2020 (86)

Funding

Current Stage
Late Stage
Total Funding
$80.9M
Key Investors
National Heart, Lung and Blood InstituteAdvanced Research Projects Agency for HealthUS Department of Energy
2024-09-19Grant
2024-08-13Grant· $18M
2023-07-27Grant

Leadership Team

leader-logo
Ken Medlock
James A Baker III and Susan G Baker Fellow in Energy and Resource Economics
linkedin
leader-logo
Kyle Judah
Executive Director, Liu Idea Lab for Innovation & Entrepreneurship (Lilie)
linkedin
Company data provided by crunchbase