Business Intelligence (BI) Developer

Posting Details



Job # 036817 Department Code 20701-6024 Department Information Technology Services Job Title Business Intelligence (BI) Developer 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 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 DataStage.

Qualifications

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

• 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 and SQLServer).

• 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 DataStage preferred).

• 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 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.

• 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, extensibility, 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.

Physical Requirements

Not Applicable

Tools/Equipment

Not Applicable

Application Instructions

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 experience.

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.

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.

Quick Link https://www.sujobopps.com/postings/86044 Job Posting Date 02/15/2021 Application Deadline Full Consideration By Job Category Staff Message to Applicants