Business Intelligence Analyst Intern Jobs in Bothell, WA

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 mission-with the goal of making the UW the world's greatest public university, as measured by positive impact-guides everything we do in University Advancement. Bringing together development; alumni and stakeholder engagement; marketing and communications; and advancement operations, we advance the UW's 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 a Business Intelligence Analyst.This is a full-time permanent position.

The Business Intelligence (BI) Analyst partners with University Advancement stakeholders and leadership to transform complex data into meaningful and actionable insights that support strategic decision-making.

Reporting to the Director of Reporting Services, the BI Analyst will lead the development of complex reporting and analytics solutions within a Microsoft SQL Server environment. This includes consulting with stakeholders across Advancement to understand business needs, designing and delivering custom reports and dashboards, identifying opportunities for process improvement and advancing self-service reporting capabilities across the organization.

What You Will Do

Business Intelligence and Solutions Development (70%)

• Collaborate with stakeholders across departments to understand their data needs and requirements, translating them into meaningful, thoughtful analytics solutions.
• Utilize Tableau and/or Power BI to design, develop and maintain interactive dashboards, reports and visualizations that effectively communicate complex data trends, patterns and insights.
• Lead project management activities, including gathering business requirements and authoring data needs and specifications for the Business Intelligence Developer.
• Conduct comprehensive testing to ensure the accuracy and reliability of BI solutions.
• Ensure all deliverables adhere to established design standards.
• Effectively communicate BI solutions, best practices, functions, approach, limitations, accuracy and other details to both technical and non-technical audiences.
• Perform thorough data analysis to identify trends, anomalies and opportunities for process improvements and optimization.
• Develop and implement data-driven strategies to enhance business performance, optimize operational efficiency and drive innovation.

Business Intelligence Products Support (20%)

• Respond to customer inquiries and questions regarding BI solutions supported by the team.
• Work closely with the BI Developer to troubleshoot, triage and document modifications to current stored procedures and SQL scripts.
• Conduct ad-hoc analyses and deep dives into specific business questions or problems, presenting findings and recommendations to stakeholders.
• Stay current on industry trends, best practices and emerging technologies in business intelligence, particularly Tableau and Power BI, to continuously improve processes and solutions.

Documentation and Other duties (10%)

• Create and update end user documentation of BI solutions.
• Develop and apply knowledge of University Advancement's organizational structure to support business and reporting needs.
• Advise and inform user experience development.

Required Qualifications

To be considered for this opportunity, your application must demonstrate that you meet the minimum qualifications and additional qualifications listed below. Equivalent education and/or experience may substitute for minimum qualifications except when there are legal requirements, such as a license, certification and/or registration.

Minimum Qualifications

Applicants who do not meet these qualifications will not be forwarded to the Hiring Department.

Bachelor's degree AND three years of professional experience as a Business Intelligence Analyst or in a similar role utilizing Tableau for data visualization and analysis.

Preferred Qualifications

• Demonstrated experience designing and developing dashboards in Tableau and Power BI.
• Proficiency in SQL for data manipulation, extraction and analysis from relational databases and experience using source control software.
• Understanding of data warehousing concepts, data modeling and ETL processes.
• Project management experience and the ability to manage multiple projects with tight deadlines and shifting priorities.
• Excellent analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
• Strong communication skills, with the ability to effectively convey complex concepts to both technical and non-technical audiences.
• Strong attention to detail.
• Proven ability to work independently and as part of a collaborative, cross-functional team, with a strong sense of ownership and accountability.

What You Can Expect

• Hybrid schedule of two days in the office with three days eligible for telework per week.
• Cubicle/Open workspace environment which may result in additional or higher levels of noise and visual distractions.
• Ability to work evening and weekend hours and to flex in-office days, as necessary, on short or limited notice.

Additional Application Requirement

This recruitment requires a cover letter. Applications that do not include a cover letter will not beforwardedto the hiring department.

Please address the following in your cover letter:

• Explain how your experience and qualifications align with a Business Intelligence Analyst position with an emphasis on utilizing Tableau, Power BI and SQL for data visualization and analysis.
• Includeyour interest in the role and UW Advancement.

#UWUAJOBS

Compensation, Benefits and Position Details

Pay Range Minimum:

Pay Range Maximum:

Other Compensation:

Benefits:

Shift:

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 world. In 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 206-543-6450 or dso@uw.edu.

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.