Data Warehouse Developer

About the company

Rice University

Higher education · 2 to 10 employees

What you'll do

• Bachelor’s DegreeIn 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.
• 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.
• 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.
• 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.

Key skills

Keywords for your resumePro

The words this employer's screening is likely to look for.