Business Intelligence Developer - (hiring for 2 positions)

Syracuse University    Syracuse, NY
Job Description
Posting Details

Job # 035315
Department Code 20701-6024
Department Information Technology Services
Job Title Business Intelligence Developer - (hiring for 2 positions)
Location Syracuse, NY
Pay Range Commensurate with Experience
Staff Level 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

The Business Intelligence Developer works with functional business analysis from Academic Affairs; Business, Finance, and Administration; and University schools and colleges to interpret business processes, develop data interfaces, and specify dashboards and reports.

The 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 for all five Syracuse University enterprise data warehouses, the ETL integration between most all enterprise source systems and structures, providing production support (including after normal working hours), as well as developing reports and dashboards (MyReports).

The Business Intelligence Developer will support Syracuse University’s data warehouse infrastructure (namely, for the Office of Institutional Research (OIR), where most support is needed), and tool needs, which are sourced from our campus ERP applications (e.g. PeopleSoft, Degree Works, Housing).


Qualifications
  • Bachelor’s degree in one of the following: Computer Science, Computer Engineering, Information Technology, or related field preferred.
  • 3+ years’ experience designing and developing ETL programs.
  • 3+ years’ experience SQL programming.

Job Specific Qualifications
  • Advanced experience with or knowledge of most of the following software, languages, and tools, or similar products is preferred:
  • Oracle DBMS
  • SQL Server DBMS
  • Solid SQL skills
  • Relational database and SQL skills experience required (Oracle and SQL Server).
  • Reporting development tools experience required (e.g. Oracle Business Intelligence Enterprise Edition and Hyperion Interactive Reporting tool preferred).
  • Data modeling experience.
  • Extract Transform Load (ETL) experience required (IBM DataStage preferred).
  • 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 required.
  • 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.

Responsibilities
  • Design, develop and modify relational and multidimensional database structures, relationships, data flows and data interfaces within the data warehouse as needed.
  • Use programming languages, software development methods, and “best practice programming techniques to develop new ETL code that requires little overhead with the passing of time.
  • Analyze and modify the data structures within the data warehouse to adapt them to the university’s business needs, and work with clients, Business Analysts, ETL and Database developers to deliver the requested data warehouse solution.
  • Participate in requirements gathering and analysis, technical design, building, testing, documentation and project planning.
  • Provide production support and on-call support during and after work hours.

Physical Requirements

Tools/Equipment

Application Instructions

In addition to completing an online application, please attach a resume and cover letter for consideration.

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.


About Syracuse University
About the Syracuse area
EEOC
Commitment to Supporting and Hiring Veterans
Commitment to a Diverse and Inclusive Campus Community
Quick Link http://www.sujobopps.com/postings/78469
Job Posting Date 06/26/2019
Application Deadline
Full Consideration By
Job Category Staff
Message to Applicants

Tue, 16 Jul 2019 19:21:05 GMT

Recent from Blog

The Jobrino blog is written with jobseeker and employers in mind to enable them to realize their full potential. Jobrino blog is your one-stop destination to find new research about the workplace and the latest insights into the employment market.

Artificial Intelligence (AI) Will Change Health Jobs for the Better

From smartphones to advances in the healthcare industry, technology’s effect on our lives is undeniable. The budding uses of technology are innumerable, especially for healthcare professionals.  According to Keith Dreyer, chief data science officer of ...

Read more

7 Tips on How to Ace a Video Job Interview

In today’s age, a video job interview is almost as common as an in-person interview. Most of these remote-friendly companies may not in your local area. Therefore, the interview process is done ...

Read more

5 Expert Tips for Creating an Amazing Video Resume to Get the Job

Creating a video resume can never be the replacement for the paper resume, but it has its own advantages to show some intangibles qualities like confidence, professionalism, and presentation skills. The application process which included submitting a video, which has ...

Read more

How to land your next Entry level Jobs in USA

Entry level jobs are lower-level positions at companies. They requires or have less experience and responsibility. People in entry level jobs often receive more training from senior level employer. If you are just starting out in your career, or are switching ...

Read more