Information Technology Services
Business Intelligence (BI) Developer
Commensurate with Experience
Standard University business hours
8:30am – 5:00pm (academic year)
8:00am – 4:30pm (summer)
Hours may vary based on operational needs.
Unionized Position Code
The Business Intelligence Developer works with subject matter
experts from all areas across the University, including but not
limited to: Academic Affairs; Business, Finance, and
Administration; Advancement; Enrollment and the Student Experience;
IVMF ; Human Resources, and the University’s schools and colleges.
This work includes integration of data driven business processes,
development of data interfaces, critical tactical and strategic
analytical activities, data security and access, as well as
development of in-depth dashboards and reports.
The Business Intelligence Developer performs development (coding),
analysis (troubleshooting), and production support, and provides
overall expertise in the area of data warehouse and reporting
applications. The duties include maintaining and enhancing data
warehouse structures for all Syracuse University enterprise data
warehouses, the ETL (Extract, Transform, Load) integration between
most all enterprise source systems and structures, and providing
production support (including after normal working hours), as well
as developing reports and dashboards (MyReports). The current ETL
tool used for this development and integration is IBM
• Bachelor’s Degree in Computer Science, Information Management,
Engineering, or equivalent combination of education and relevant
• Two (2) plus years of relevant work experience.
Job Specific Qualifications
• Experience with or knowledge of most of the following software,
languages, and tools, or similar products is preferred.
• Relational database and SQL skills experience required (Oracle
• Reporting development tools experience required (e.g., Tableau,
SSRS, and Hyperion Interactive Reporting tool preferred).
• Experience in developing legible and well-structured scripts and
queries in SQL .
• Knowledge of basic data modeling techniques.
• Extract Transform Load ( ETL ) experience preferred ( IBM
• Strong aptitude to learn and adapt to technology.
• Linux and windows operating system experience preferred.
• Strong interpersonal and communication skills, including written,
verbal and active listening required.
• Ability to prioritize work, have attention to detail and
flexibility in work assignments required.
• Ability to work independently as well as on a team
• Ability to communicate progress/status of assigned
responsibilities on an ongoing basis to management.
• Experience developing thorough documentation to be used for
supporting production applications.
• Thorough understanding and demonstrated use of the SDLC .
• Ability to mentor/train others required.
• Higher Education experience preferred.
• Knowledge of MS Word, Excel and Access preferred.
• 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
• Monitor and update issue logs with status and resolution
information per project standards, department standards, and/or as
• Maintain up-to-date status on requests in tracking system(s),
issue logs, etc. as per department standards and/or as requested by
• 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, extensibility, and customer
• 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.
In addition to completing an online application, please attach a
resume and cover letter.
About Syracuse University
Syracuse University is a private, international research university
with distinctive academics, diversely unique offerings and an
undeniable spirit. Located in the geographic heart of New York
State, with a global footprint, and nearly 150 years of history,
Syracuse University offers a quintessential college
The scope of Syracuse University is a testament to its strengths: a
pioneering history dating back to 1870; a choice of more than 200
majors and 100 minors offered through 13 schools and colleges;
nearly 15,000 undergraduates and 5,000 graduate students; more than
a quarter of a million alumni in 160 countries; and a student
population from all 50 U.S. states and 123 countries. For more
information, please visit www.syracuse.edu.
About the Syracuse area
Syracuse is a medium-sized city situated in the geographic center
of New York State approximately 250 miles northwest of New York
City. The metro-area population totals approximately 500,000. The
area offers a low cost of living and provides many social,
cultural, and recreational options, including parks, museums,
festivals, professional regional theater, and premier shopping
venues. Syracuse and Central New York present a wide range of
seasonal recreation and attractions ranging from water skiing and
snow skiing, hiking in the Adirondacks, touring the historic sites,
visiting wineries along the Finger Lakes, and biking on trails
along the Erie Canal.
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
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
Job Posting Date
Full Consideration By
Message to Applicants