Principal Data Warehouse & BI Engineer
Position Information
WORKING TITLE: Principal Data Warehouse & BI Engineer
UW SYSTEM OFFICIAL TITLE: Data Warehouse Engineer/Developer III
POSTING DATE: November 18, 2024
Essential Job Functions
The University of Wisconsin - Green Bay has an opening for a Principal Data Warehouse and Business Intelligence Engineer (Data Warehouse Engineer/Developer III). This role will be a member of both the Information Technology (IT) and Finance teams and will be responsible for driving innovation in our data warehousing and analytics. This is a new role that will be critical to transforming UW-Green Bay into a best-in-class data informed decision-making organization.
To be successful in this role, the candidate must possess strong leadership skills executed through coaching, training, and mentoring other employees across the institution. Candidates who have experience conducting peer reviews of technical solutions and quality review of business requirements documents (BRDs) and technical development documents (TDDs) for analytic solutions are encouraged to apply. A thorough understanding of higher educational processes and data will be beneficial in this role.
From a technical aspect, this position will manage the entire analytic development lifecycle from ideation through deployment. This role will require partnering with our IT department to build and deploy ETL processes for Amazon Redshift, as well as partnering with all stakeholders within the organization to identify opportunities for analytic solutions. These solutions will be initially focused on financial data, such as operational scorecard and metrics, management reporting, analytic insights, and data driven alerting. This role will expand to include all data sets across the organization. Success for this role will be evaluated by the number of data sources (complete and accurate) housed in Redshift, insights delivered through analytics, and stakeholder interactions with the Tableau dashboards. Our team primarily delivers analytic solutions through SQL, Tableau Prep, and Tableau and will also require working extensively within Amazon Redshift to warehouse data.
What You'll Do
- Develop interfaces to warehouse all organizational data on Amazon Redshift, build data models on Amazon Redshift, and create proactive monitoring to ensure completeness and accuracy of data
- Create and maintain a pipeline of ideas for analytics and business intelligence by partnering with key stakeholders to ensure audience needs are met
- Build analytic solutions primarily using SQL, Tableau Prep, and Tableau, coupled with a track record for creating solutions that are efficient, effective, essential, and delivered on time
- Foster strong relationships with all key stakeholders
- Navigate within a technology environment to locate, validate, and format data for consumption
- Be an excellent project manager, creating and delivering to deadlines
- Critically think with an innovative mindset to evolve the organization
- Communicate analytic and data model results in a clear and effective manner
- Add projects or shift priorities readily and efficiently
- Develop and document standards and procedures for data mappings, data quality assessments, model architectures, and data curation
- Mentor other team members
Qualifications
MINIMUM QUALIFICATIONS:
- 3 years of SQL experience
- 2 years of ETL experience
- 2 years of Tableau experience
PREFERRED QUALIFICATIONS:
- Bachelor's degree at time of application
- 6 years of SQL experience
- 5 years of ETL (Extract, Transform, Load) experience
- 3 years of Amazon Redshift experience
- 3 years of Tableau experience
- 2 years of leadership experience
- 3 years of Tableau prep experience
The Successful Candidate
The successful candidate will be expected to work inclusively and respectfully within a diverse campus community and practice civility in the workplace. The University welcomes applicants who are dedicated to the appreciation and promotion of inclusivity and equity as crucial components in the pursuit of organizational excellence.
In addition, the successful candidate will have strong oral, written, interpersonal, and organizational skills, demonstrated integrity and strong leadership, and the willingness to work independently and as part of a collaborative team. The University invites applicants who are dedicated to enriching the quality of life for students and the community by embracing the educational value of diversity, promoting environmental sustainability, encouraging engaged citizenship, and serving as an intellectual, cultural, and economic resource.
Conditions of Appointment
This position may have the option to work on-campus, a hybrid schedule, or fully remote, subject to approved telecommuting request.
The home campus of this position is Green Bay and the successful candidate may occasionally be required to travel to or work at the Marinette, Sheboygan or Manitowoc Campus, based on operational needs.
Position is a full-time Academic Staff appointment. Official transcripts of the highest degree achieved will be required of finalist(s). A criminal conviction investigation will be conducted on the finalist(s). In compliance with the Wisconsin Fair Employment Act, the University does not discriminate on the basis of arrest or conviction record.
All final candidates will be asked to provide names, email contact information, and/or phone numbers for three (3) references, with at least one being from a manager or supervisor, during the interview process. All final candidates must be asked, prior to hire, whether they have been found to have engaged in, are currently under investigation for, or left employment during an active investigation in which they were accused of sexual violence or sexual harassment. When obtaining employment reference checks, these same sexual violence or sexual harassment questions must also be asked.
The University of Wisconsin-Green Bay does not offer H-1B or other work authorization visa sponsorship for this position. Candidates must be legally authorized to work in the United States at the time of hire and maintain work authorization throughout the employment term. If you have questions regarding this, please contact Human Resources.
Compensation and Benefits
SALARY INFORMATION
Minimum salary of $87,000.
This position is exempt from the overtime provisions of the Fair Labor Standards Act (FLSA).
BENEFIT DETAILS
The UW System provides an excellent benefits package to meet the diverse needs of its employees. This includes several health insurance options, with annual deductibles as low as $250/individual and $500/family. Our benefits package also includes dental, vision, several life insurance options, AD&D and Accident insurance and Flexible Spending and Health Savings Accounts. We participate in the Wisconsin Retirement System (WRS), where employer contributions begin immediately and employees are fully vested after 5 years of service. The UW System also provides supplemental retirement savings programs including a 403(b) and Deferred Compensation.
In addition, employees receive several types of paid leave benefits, which are prorated for employees working less than 100%. This includes 9 legal holidays, 36 hours of personal holiday and between 96-130 hours of sick leave annually. Employees earn 13-27 days of vacation each year, depending on years of service and employment type.
For more details, please review the benefit quick guide linked below.
Apply
STEP 1: Please select the applicable link below:
External Applicants: (NOT currently employed by the University of Wisconsin System)
Internal Applicants: (Currently employed by the University of Wisconsin System)
STEP 2: From "Search Jobs" screen:
- Click "View All Jobs"
- Select "Principal Data Warehouse & BI Engineer"
- You must login before you can apply. Input your "User Name" and "Password" and select "Sign In."
- If you have not yet registered, click "Register Now" to begin the registration process.
STEP 3: Submit application materials:
Please be sure to complete all required fields, and include all required documents before submitting your application. Once submitted, you will not be able to edit or attach any application materials. Files must be complete to be considered. Please include the following documents:
- Cover letter
- Resume
You must select "Submit" to forward your application materials to the search committee.
If you have any questions, need accommodations, or submitted your application with missing materials, call or email:
Tracy VanErem
Phone: (920) 465-2693
Email: vaneremt@uwgb.edu
Application Deadline
To ensure consideration, please submit application materials by Sunday, December 1, 2024.
Note: The University of Wisconsin System will not reveal the identities of applicants who request confidentiality in writing, except that the identity of the successful candidate will be released. See Wis.Stat. sec. 19.36(7).
For more information regarding the University of Wisconsin-Green Bay and the surrounding area, see our Campus and Community section. For Campus Safety information see our University Police website and our Annual Security Report (for a paper copy please contact the Office of Human Resources at (920) 465-2390). This report includes statistics about reported crimes, as well as information about crime prevention and campus security policies and procedures.
The University of Wisconsin-Green Bay is an Affirmative Action Equal Employment Opportunity employer committed to achieving a diverse workforce and to maintaining a community which welcomes and values a climate supporting equal opportunity and difference among its members. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender and/or gender identity or expression, marital or parental status, genetic information, national origin, ethnicity, citizenship status, veteran or military status (including disabled veteran, recently separated veteran, other protected veteran, or Armed Forces service medal veteran status), age, or disability.