Responsible for the review and application of business requirements as directed by the Business Intelligence Manager, collection or construction of technical specifications, and the subsequent development of technology solutions that require development to be viable to support enterprise-wide data warehousing and business data information solutions. Responsible for the analysis, modeling under the supervision of the Business Intelligence Manager, specification of extract logic, testing, documentation, and maintenance of database structures developed to support enterprise-wide data warehousing and reporting objectives. Occasional travel to other two colleges as required by the project.
This position will work 38.75 hours per week, Monday - Friday. Flexible day/evening/weekend hours based upon the needs of the WILM Consortium (Wisconsin Indianhead, Lakeshore and Mid-State Technical Colleges) The location of this position could be at any of the three colleges.
Duties & Responsibilities
Work with end user requirements to analyze, design, develop, and document subject area databases/tables within the data warehouse. This includes requirements’ gathering and analysis, as well as understanding business processes as directed by the Business Intelligence Manager. Expert understanding of data warehousing concepts (e.g., ODS, metadata management, data marts, star schema, operational vs. analytical reporting, relational vs. dimensional modeling).
Participate throughout project life cycles, from planning to production implementation, with emphasis on business and data requirements and follow-through to production. Includes facilitating design sessions providing technical options for functional requirements, writing detailed table design and extract specifications. Analyze data in source systems to understand and develop Extract-Transformation-Load (ETL) architecture specifications and structures; design, create, deploy, and maintain models, packages, cubes, and reports.
Document data structures and technical information. Create draft business requirements documents based on user needs and subject to approval by Business Intelligence Manager.
Data support for data warehouse and business data information. This includes data modeling as meets the strategic Business Intelligence objectives as defined by the Business Intelligence Manager, data design, testing, implementing, and documenting extract programs and database objects consistent with business specifications, complying with standards and customer requirements.
Ability to understand higher education data and reporting requirements then translating those requirements into an overall data warehouse solution.
Responsible for the day-to-day operational support of the data warehouse ensuring data integrity, database availability and performance. Responsible for data information reporting and multi-dimensional ad-hoc analysis views (cubes).
Test and reconcile data to source systems and business/data specifications.
Support and maintain production and development systems for the data warehouse and reporting. Data server support and monitoring. Communicate with DBA’s and/or programmers to find integrated solutions to daily problems.
Data file management, performance monitoring/tuning, and security setup for the data warehouse and reporting.
Responsible for Cognos Administration.
Attend professional growth activities through meetings, seminars, and classes to keep skills current with technology and programming changes.
Provide 5 Star Service throughout all customer interactions. Other duties as assigned.
Bachelor’s degree or equivalent in computer programming or related field required. Experience working in Windows, Cognos, data warehousing, SQL Server, T-SQL Script, development of Client Server environment required.
Minimum of two years' experience in PeopleSoft preferred. Web programming and ASP preferred.
Working knowledge of dimensional models and star schemas.
Working knowledge of current Windows OS and Microsoft Office.
Experience in providing technical support to PeopleSoft or similar ERP implementation on an SQL platform preferred. Manage and maintain PeopleSoft ERP user security.
Complete database tuning and implement the backup and recovery procedures for web applications.
Comprehensive knowledge of the uses of computer-based data processing systems and their limitations; knowledge of the methods and techniques of systems analysis, design, and programming.
Knowledge of Cognos ReportNet, Inpromptu, Powerplay and Decision Stream software.
Ability to communicate effectively with other personnel in the analysis of computer-based systems efforts.
Design, create and maintain Databases, Tables, and all other SQL Server objects (inside .asp code and ad-hoc).
Knowledge of information systems, table structures, and reporting methods.
Plan, test and implement upgrades and patches.
Exemplify college values in all staff and student interactions, as well as services delivered.
Ability to establish and maintain effective working relationships and relate successfully with staff, students, and citizens of diverse cultural, social or educational backgrounds.
Fluent, bilingual individual is desirable.
Compensation & Benefits
Compensation is dependent upon experience and qualifications.
Benefits include Health Insurance;Employee Assistance Program (EAP);Vacation; Dental Insurance;Paid Leave of Absence (PLOA);Health Reimbursement Account (HRA); Long Term Disability;Professional Development;Flexible Spending Program; Life Insurance; Tuition Reimbursement; On-Site Child Care; Wisconsin Retirement System (WRS);Holidays;Wellness/Fitness Center. (Some benefits may be based on location.)
How To Apply
To be considered for this position, you must complete an online application. You should have the following information available when completing an application:
Contact information (addresses, phone numbers)
Electronic copy of resume and transcripts
Application materials submitted via mail, fax, email, or in-person will not be considered.
Incomplete applications or applications noting "See Resume" will not be considered.
Please note that Mid-State’s main form of communication during the recruitment process is email. In addition to receiving communications from email addresses with an @mstc.edu domain, you may receive emails from email@example.com. Please be sure to watch your inbox as well as junk, spam, and clutter folders.
Continuous recruitment with first review of completed applications starting February 10, 2020. Applications received on or after February 10th may be considered in a secondary pool.
Mid-State Technical College, an equal opportunity employer and educator, does not discriminate on the basis of race, color, national origin, gender, disability, sexual orientation, or other applicable legislated categories, in its services, employment programs, and/or its educational programs and activities, including but not limited to admission, treatment, and access. Mid-State Technical College provides reasonable accommodations to assist persons with disabilities to access or participate in its programs and activities. The following person has been designated to handle inquiries regarding the nondiscrimination policies: VP-Human Resources, 32nd Street N, Wisconsin Rapids, WI 54494, Phone: 715-422-5325 or Email:firstname.lastname@example.org.
Optimize Your Online Application Experience
Below you will find a few technical tips to help ensure a positive and successful online application experience:
Be sure to fill in each field in the application. You will receive an error message at the time of submission and your application will not be submitted if each required field is not filled in.
Avoid clicking the back, forward, or refresh buttons while applying. Doing so will interfere with the submission and may result in data loss.
Clear your browser's temporary files/cache and cookies prior to beginning the application.
Disable pop-up blockers.
Do not bookmark or favorite the application. Navigate to the careers site each time you wish to access your saved/submitted application.
Your application session will remain open for 24 hours assuming you do not close your browser. To ensure submission, complete the application process within that time frame.
The following browsers are currently supported:
Internet Explorer 9, 10, 11
The following operating systems are currently supported:
Windows 7 and 8, both 32-bit and 64-bit, as well as Mac OS 10.6 and greater.
If you experience issues in submitting your online application, please contact Human Resources at 715.422.5568.