University of Wisconsin-Green Bay
Principal Data Warehouse & BI Engineer
University of Wisconsin-Green Bay, Green Bay, Wisconsin, United States, 54311
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.
UW System Employee Benefits Brochure Faculty, Academic Staff, and Limited Quick Guide Total Compensation Estimator
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.
UW System Employee Benefits Brochure Faculty, Academic Staff, and Limited Quick Guide Total Compensation Estimator