Analytics Engineer

Job Description

For over 160 years the University of Washington has been a hub for learning innovation problem solving and community building. Supporting this legacy and important public missionwith the goal of making the UW the worlds greatest public university as measured by positive impactguides everything we do in University Advancement. Bringing together development; alumni and stakeholder engagement; marketing and communications; and advancement operations we advance the UWs impact by developing meaningful connections that foster pride advocacy and philanthropic support.

The Advancement Operations team empowers University Advancement to achieve and sustain its mission and vision. This starts with creating a culture of belonging within our organization that values the diverse experiences and expertise of our team members allowing everyone to thrive and to contribute their unique talents as we strive to achieve our shared goals.

The Information Management team has an exciting opening for an Analytics is a full-time permanent position.

The Analytics Engineeris responsible forsupporting the development of a strong data infrastructure to improve business practices and support University Advancement initiatives through data requires a deep understanding of data storagecleaningand conforming techniques including the ability to effectivelyutilizedata analysis processes and Analytics Engineer reports to the ManagerforData Analytics & Business Intelligence.

What You Will Do:

Technical Implementation

• Develop a dedicated analytics environment within the wider technical framework.
• Work withanalysts reportdevelopersand data science team memberstoidentifyprimary and exhaust datafrom institutional and third-party systems.
• Develop pipelines to make data available to the analytics environment.
• In collaboration with analysts data scientists and business partners operationalize and deploy the output of analytics efforts for the benefit of the entireUniversity Advancement organization.
• Manage and direct technical vendors and data suppliersasappropriate.

Program Management

• Lead specific technical efforts understand the business problems the efforts are intended to address develop a framework for addressing the problems assign work to self and others on the team to implement the solutions and communicate status and constraints clearly to leadership.

Relationship Management

• Work with technical and non-technical stakeholders throughout the organization to develop data specifications articulate complex technical constraints in plain language and seek to increase the overall level of data literacy.

Minimum Requirements:

Bachelors degree in related field and two years of experience as a data engineer or in a similar role.

Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements such as a license/certification/registration.

What You Bring:

• Demonstrated ability to utilize industry-standard tools to design build and maintain data ETL/ELT pipelines.
• Strong skills in SQL for querying transforming and optimizing data in relational environments.
• Experience with distributed data processing tools such as Databricks PySpark or equivalent.
• Hands-on experience with cloud-based data platforms and services (preference for Azure).
• Experience ingesting structured semi-structured and unstructured data into a medallion architecture.
• Proven skills in at least two of the following technology sets:
  • Data Integration & ETL (e.g. Azure Data Factory SSIS)
  • Data Analytics Platforms & Pipelines (e.g. Synapse Databricks Fabric cloud-native data services)
  • Data Manipulation & Programming (e.g. SQL Python)
  • APIs & Messaging Queues (e.g. REST APIs Kafka Azure Service Bus)
  • Enterprise Data Platforms (e.g. Microsoft Dynamics Dataverse)
• Experience with enterprise data platforms and business applications such as Microsoft Dynamics 365 (including Customer Insights and Customer Journeys) and Dataverse.
• Proven expertise in data governance metadata management and enforcing best practices for data quality and security.

What You Can Expect:

• Cubical/Open workspace environment which may result in higher levels of noise and visual distractions.
• Hybrid work schedule of at least two days in office.

#UWUAJOBS

Compensation Benefits and Position Details

Pay Range Minimum:

Pay Range Maximum:

Other Compensation:

Benefits:

Temporary or Regular

FTE (Full-Time Equivalent):

Union/Bargaining Unit:

About the UW

Working at the University of Washington provides a unique opportunity to change lives on our campuses in our state and around the world.

UW employees bring their boundless energy creative problem-solving skills and dedication to building stronger minds and a healthier return they enjoy outstanding benefits opportunities for professional growth and the chance to work in an environment known for its diversity intellectual excitement artistic pursuits and natural beauty.

Our Commitment

The University of Washington is committed to fostering an inclusive respectful and welcoming community for all. As an equal opportunity employer the University considers applicants for employment without regard to race color creed religion national origin citizenship sex pregnancy age marital status sexual orientation gender identity or expression genetic information disability or veteran status consistent with UW Executive Order No. 81.

To request disability accommodation in the application process contact the Disability Services Office at or .

Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under Washington state law.