Data Warehouse Developer, Department of Information Systems
Wake Forest University

Job Info

---

Job location: Winston Salem, NC

Employment Type: Full-time
Posted data: 2019-11-01
Req: R0002189
Please note:

• Additional documentation must be added at the bottom of the third screen under the "My Experience."
• Internal candidates must apply via the internal career portal. Do not proceed with your application from this website.
• DO NOT complete the application without the required attachments as you will be unable to edit your application.

** Cover letter required for all positions and optional for facilities, campus services, and hospitality positions unless otherwise specified.Job Description SummaryAs a member of the IS Analytics & Data Governance team, this position is responsible for gathering requirements and designing and developing solutions that support the University's Analytic and Data Governance initiatives, providing end user and campus report writing support and training, and providing administrative support for the Enterprise Analytic tools.Job Description

Essential Functions:
Following is a summary of the essential functions for this job. Other duties may also be performed. Specific activities may change from time to time.

• Works with business partners to plan and implement enhancements to the existing Analytic infrastructure and the Enterprise Data Warehouse.
• Serve as a subject matter expert in data warehousing and Analytic solution design, development and implementation.
• Designs, develops and maintains data models, Cognos and Power BI metadata models, ETL and other reporting infrastructure components for the Enterprise Data Warehouse and other analytic environments.
• Creates, enhances, and performance tunes reports/dashboards to support BI / EDW administration.
• Responsible for the administration, maintenance, operational support, configuration management, and manages security for Enterprise BI tools.
• Serves as subject matter expert in Analytic tools working on problems of diverse scope and complexity.
• Creates, enhances, and performance tunes reports.
• Provides training and support to campus reporting community.
• Works on problems of diverse scope and complexity.
• Accountable for maintaining the security and confidentiality of any proprietary or sensitive information or data in any medium regarding the university or its students, faculty, or staff. Accessing or disclosing such information or data must be deemed necessary for the performance of one's job responsibilities and must be authorized by the employee's supervisor.
• Responsible for following the defined SDLC, ensuring solution development adheres to the process controls.
• Availability to work after hours and/or weekends and on-call, as specified by supervisor.

Required Education, Knowledge, Skills, Abilities:

The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions.

• Bachelor's degree with 3-5 years of related experience, or an equivalent combination of education and experience.
• Strong understanding of Analytic best practices.
• Strong experience in business analysis, systems analysis, and data analysis in transactional and data warehousing environments.
• Advanced knowledge of and experience with data warehousing and Analytic tools.
• Strong experience with Oracle and Linux.
• Strong experience with with integration tools (preferably SnapLogic or other cloud integration tools).
• Strong report authoring experience using Analytic tools (preferably with Cognos. Workday)
• Experience with data visualization (PowerBI, Tableau) and/or other visual analytics tools and creating engaging dashboards
• Experience with Cognos 10+ administration and support.
• Knowledge of superior customer service standards and practices.
• Ability to work independently to determine methods and procedures on new assignments. Receives no instruction on routine work, general instructions on new assignments.

Desired Education, Knowledge, Skills, Abilities:

• Experience in Higher Education with data and business processes strongly preferred.
• Ellucian/SunGard Higher Education Banner experience preferred.
• Workday HCM, Finance, Payroll, or Budget experience a plus.
• Experience with statistical software packages such as R or SPSS
• Experience with Python, or other data or scripting language.

Additional Job DescriptionTime Type RequirementFull timeNote to Applicant:This position profile identifies the key responsibilities and expectations for performance. It cannot encompass all specific job tasks that an employee may be required to perform. Employees are required to follow any other job-related instructions and perform job-related duties as may be reasonably assigned by his/her supervisor.In order to provide a safe and productive learning and living community, Wake Forest University conducts background investigations and drug screens for all final staff candidates being considered for employment.Wake Forest seeks to recruit and retain a diverse workforce while promoting an inclusive work environment committed to excellence in the spirit of Pro Humanitate. In adherence with applicable laws and as provided by University policies, the University prohibits discrimination in its employment practices on the basis of race, color, religion, national origin, sex, age, sexual orientation, gender identity and expression, genetic information, disability and veteran status and encourages qualified candidates across all group demographics to apply.

This job has expired.