Business Intelligence Developer

Posting Details

Posting Details

Job # 033638
Department Code 20701-6024
Department Information Technology Services
Job Title Business Intelligence Developer
Location Syracuse, NY
Pay Range Commensurate with Experience
Salary Grade S5
FLSA Status Exempt
Hours

Standard University Business Hours

8:30am -5:00pm (academic year)
8:00am – 4:30pm (summer)


Hours may vary based on operational needs.

Job Type Full-time
Campus Syracuse, NY
Unionized Position Code Not Applicable
Job Description

Business Intelligence Developer performs software development, production support and provides overall expertise in the area of Data Warehouse and Reporting Applications. The duties include maintaining and enhancing data warehouse structures and the ETL integration between source systems and those structures, providing production support (including after normal working hours), developing reporting solutions, and providing data warehouse development knowledge, experience, and expertise. This position supports enterprise data warehouse structures and tools that are based on our campus ERP environments (e.g. PeopleSoft) and are utilized campus wide.

Qualifications

• Bachelor’s Degree in Computer Science, Information Management, Engineering or equivalent relevant work experience.

• Three plus year’s relevant work experience.

Job Specific Qualifications

Advanced experience with or knowledge of most of the following software, languages, and tools, or similar products is preferred:
o Oracle DBMS
o SQL Server DBMS
o Solid SQL skills
o Understanding of SQL Server Analysis Services (a plus)
o Experience with Visual Studio 2015, SQL Server Integration Services, & Team Foundation Server (a plus)
o Hyperion Interactive Reporting (IR) version 9 or newer (11 preferred)
o 3+ Years of report development experience (Tableau, Hyperion Interactive Reporting tool experience preferred)
o Hyperion Interactive Reporting experience: Report design; Dashboard creation; Report development; Report Performance Tuning; Metadata Repository Management
o Understand and use Report Development Best Practices
o Knowledge of ETL tool(s) (IBM Datastage preferred), as well as the entire ETL process
o Ability to communicate progress/status of assigned responsibilities on an ongoing basis to management.
o Excellent verbal and written communication skills.
o Background in developing thorough documentation to be used for supporting production application.
o Ability to prioritize work and estimates time for task completion.
o Able to multi-task and handle several tasks at a given time.
o Experience with software document and version control.
o Prepare test cases and effectively conduct unit testing, including interacting with business users to validate results
o Ability to mentor/train others related to our reporting tools
o Higher Education experience a plus
o MS Word
o MS Excel
o MS Access
o MS Visio

Responsibilities

• Design, develop and modify relational and multidimensional database structures, relationships, data flows and data interfaces within the data warehouse as needed.
• Understand thoroughly the architecture, data structures and fundamental design principles of the data warehouse.
• Use programming languages, software development methods, “best practice” programming techniques, and department standards guides to develop new data warehouse structures and reports and to modify existing ones to meet user requirements, to function efficiently and effectively, and to comply with departmental standards.
• Analyze and modify the data structures within the data warehouse to adapt them to the University’s business needs and add enhanced functionality to store, manage, and track data related to all aspects of the University’s mission and operations, and to support reporting and analysis.
• Participate in requirements gathering and analysis, technical design, build, testing, documentation and project planning.
• Provide production support and on-call support including problem analysis and resolution, including during and after work hours.
• Monitor and update issue logs with status and resolution information per project standards, department standards, and/or as requested.
• Maintain up-to-date status on requests in tracking system(s), issue logs, etc. as per department standards and/or as requested by manager.
• Consult with clients, DBAs, FBAs, PeopleSoft Developers etc., to gather information about needs, objectives, functions, performance expectations, and input and output requirements.
• Review, analyze, and understand functional requirements and functional specifications documents to determine whether all required elements are included, and if not, request that clients revise specifications by adding missing elements.
• Identify and propose technical alternatives to solving client requests and system problems, and recommend the best alternative by weighing client requirements, functionality, performance, time to implement, long-term maintainability and customer self-sufficiency.
• Maintain proficiency in current data warehouse development platforms, languages, and opportunities.
• Maintain proficiency in integration methods required to link the data warehouse to other systems.
• Research and stay abreast of changes in data warehouse technology and collaborate with manager and colleagues in how to implement and leverage the new and changing technology.
• Serve as a technical resource for Data Warehouse Application, report and dashboard development.
• Account access and security maintenance for supported systems

Physical Requirements

Not Applicable

Tools/Equipment

Not Applicable

Application Instructions

About Syracuse University

Syracuse University is a private research university of extraordinary academics, distinctive offerings and an undeniable spirit. With a gorgeous campus in the heart of New York State, a global footprint and a history that dates to 1870, we embrace diverse backgrounds and viewpoints.

Our student population includes nearly 15,000 undergraduates and 5,000 graduate students, representing all 50 U.S. states and 123 countries. Our proud commitment to veterans and their families is unrivaled in higher education. Home to 11 schools and colleges, Syracuse University blends the foundational power of the liberal arts with the intense focus of professional programs. We offer undergraduate, graduate, and professional degrees in Architecture, Arts and Sciences, Education, Engineering and Computer Science, Sport and Human Dynamics, Information Studies, Law, Management, Citizenship and Public Affairs, Public Communications, and Visual and Performing Arts.

A medium-sized city situated in the geographic center of the state, Syracuse, N.Y., is approximately a four-hour drive from New York City, Boston, Philadelphia, Toronto and Montreal. With a metropolitan population of 700,000, Syracuse is a center for cultural, recreational and artistic events, including the Everson Museum of Art, Syracuse Stage, Symphoria, Destiny Mall, multiple sporting events, and festivals including Jazz Fest and Winterfest. The outdoor enthusiast will enjoy having the Adirondack Mountains, the Finger Lakes, Lake Ontario, and the Thousands Islands Region within easy driving distance of the Syracuse campus.

EEOC

Syracuse University is an equal-opportunity, affirmative-action institution. The University prohibits discrimination and harassment based on race, color, creed, religion, sex, gender, national origin, citizenship, ethnicity, marital status, age, disability, sexual orientation, gender identity and gender expression, veteran status, or any other status protected by applicable law to the extent prohibited by law. This nondiscrimination policy covers admissions, employment, and access to and treatment in University programs, services, and activities.

Commitment to Supporting and Hiring Veterans

Syracuse University has a long history of engaging veterans and the military-connected community through its educational programs, community outreach, and employment programs. After World War II, Syracuse University welcomed more than 10,000 returning veterans to our campus, and those veterans literally transformed Syracuse University into the national research institution it is today. The University’s contemporary commitment to veterans builds on this historical legacy, and extends to both class-leading initiatives focused on making an SU degree accessible and affordable to the post-9/11 generation of veterans, and also programs designed to position Syracuse University as the employer of choice for military veterans, members of the Guard and Reserve, and military family members.

Commitment to a Diverse and Inclusive Campus Community

Syracuse University maintains an inclusive learning environment in which students, faculty, administrators, staff, curriculum, social activities, governance, and all other aspects of campus life reflect a diverse, multi-cultural, and international worldview. The University community recognizes and values the many similarities and differences among individuals and groups. At Syracuse, we are committed to preparing students to understand, live among, appreciate, and work in an inherently diverse country and world made up of people with different ethnic and racial backgrounds, military backgrounds, religious beliefs, socio-economic status, cultural traditions, abilities, sexual orientations and gender identities. To do so, we commit ourselves to promoting a community that celebrates and models the principles of diversity and inclusivity.

Job Posting Date 06/01/2017
Application Deadline
Full Consideration By
Job Category Staff
Message to Applicants

Applicant Documents

Required Documents
  1. Resume/CV
  2. Cover Letter
Optional Documents
  1. Other Document

Supplemental Questions

Required fields are indicated with an asterisk (*).