The Data Warehouse Engineer is responsible for the full life cycle of back-end development of the data warehouse including designing, developing, testing, and maintaining data architecture and databases. This role involves understanding business requirements, defining technical requirements, and providing automated solutions to deliver business insights.

Duties & Responsibilities:

Data Architecture and Modeling: Develop, maintain, and optimize data architecture, models, and database designs across platforms and applications.
ETL Development: Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked.
Data Warehouse Management: Assist in designing and setting up data warehousing tools. Create and support the ETL to facilitate bringing data into the data warehouse using ETL tools.
Performance Optimization: Monitor and optimize performance of the database, data warehouse, and ETL environment to ensure reliable and efficient data load and extraction.
Collaboration: Work closely with stakeholders, data analysts, and decision-makers to respond to their data-related needs and to ensure data consistency and security.
Documentation: Document the company's database and data warehouse schema and entities.
Compliance and Security: Ensure the data warehouse and all related systems comply with legal regulations and privacy standards.

Knowledge, Skills, and Abilities:

Knowledge of data warehousing concepts, including data warehouse technical architectures, infrastructure components, ETL, and reporting/analytic tools
Experience with SQL and SQL-based technologies (e.g., PostgreSQL, MySQL) and familiarity with programming languages (e.g., Python)
Experience with ETL tools (e.g., SSIS, Azure Data Factory).
Excellent problem-solving skills, attention to detail, and strong analytical abilities.
Good communication skills to translate data findings to non-technical team members.

Minimum Qualifications:

Bachelor's degree or equivalent advanced learning attained through professional level experience required.
Minimum of 5 years of relevant work experience, or equivalent combination of education and work experience.
Proven experience as a Data Warehouse Engineer or a similar role in data management.

Preferred Qualifications:

Master's degree preferred.
Familiarity with cloud services (e.g., AWS, Azure) and big data tools is preferred.

Outstanding UA benefits include health, dental, and vision insurance plans; life insurance and disability programs; paid vacation, sick leave, and holidays; UA/ASU/NAU tuition reduction for the employee and qualified family members; retirement plans; access to UA recreation and cultural activities; and more!

The University of Arizona has been recognized for our innovative work-life programs.

Rate of Pay: $86,870 - $112,932

Compensation Type: Salary at 1.0 full-time equivalen ce (FTE)

Grade: 11

Compensation Guidance:

The Rate of Pay Field represents the University of Arizona’s good faith and reasonable estimate of the range of possible compensation at the time of posting. The University considers several factors when extending an offer, including but not limited to, the role and associated responsibilities, a candidate’s work experience, education/training, key skills, and internal equity.

The Grade Range Minimum, Midpoint, and Maximum Fields listed below represent a full range of career compensation growth over time in this position and grade. Each unit typically sets starting pay between minimum and midpoint upon hire. The university offers compensation growth opportunities within its career architecture. To learn more about compensation, please review our Applicant Compensation Guide and our Total Rewards Calculator .

Grade Range Minimum: $86,870

Grade Range Midpoint: $112,932

Grade Range Maximum: $138,993

Career Stream and Level: PC3

Job Family: Data Analysis

Job Function: Planning and Analysis

For more information regarding this position, please contact us at careers@uagc.edu .

UAGC shall, in all solicitations or advertisements for all employees placed by or on behalf of UAGC, state that all applicants who are qualified will receive consideration for employment without regard to sex, race, color, religion, sexual orientation, national origin, ancestry, citizenship, pregnancy, marital status, registered domestic partnership status, age, physical disability, mental disability, genetic information, gender identity, military or veteran status, service in the uniformed services, or any other consideration made unlawful by federal, state or local laws.

Data Warehouse Engineer (Remote)

This job is now closed

Job Description

About the company

Other job opportunities