Business Intelligence Develope
- Employer
- Syracuse University
- Location
- New York, United States
- Salary
- Salary Not Specified
- Date posted
- May 6, 2022
You need to sign in or create an account to save a job.
Posting Details
Posting Details
Job # 038431 Department Code 20701-6024 Department Information Technology Services Job Title Business Intelligence Develope 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 IT Analyst/ BI Developer position 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.
To learn more for Information Technology Services, click here – ITS Recruitment_V1 – Syracuse University Videos Qualifications
Bachelor’s Degree in Computer Science, Information Management, Engineering or equivalent relevant work experience. Three plus year’s relevant work experience.
Advanced experience with or knowledge of most of the following software, languages, and tools, or similar products is preferred:
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/93539 Job Posting Date 05/06/2022 Application Deadline Full Consideration By Job Category Staff Message to Applicants
Posting Details
Job # 038431 Department Code 20701-6024 Department Information Technology Services Job Title Business Intelligence Develope 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 IT Analyst/ BI Developer position 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.
To learn more for Information Technology Services, click here – ITS Recruitment_V1 – Syracuse University Videos Qualifications
Bachelor’s Degree in Computer Science, Information Management, Engineering or equivalent relevant work experience. Three plus year’s relevant work experience.
- Able to multi task and handle several tasks at a given time.
- Experience with software document and version control.
- Prepare test cases and effectively conduct unit testing, including interacting with business users to validate results
- Ability to mentor/train others related to our reporting tools
- Higher Education experience a plus
- MS Word
- MS Excel
- MS Access
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
- Hyperion Interactive Reporting (IR) version 9 or newer (11 preferred)
- 3+ Years of report development experience (Tableau, Hyperion Interactive Reporting tool experience preferred)
- Hyperion Interactive Reporting experience: Report design; Dashboard creation; Report development; Report Performance Tuning; Metadata Repository Management
- Understand ad use Report Development Best Practices
- Knowledge of ETL tool(s) ( IBM Datastage preferred), as well as the entire ETL process
- Ability to communicate progress/status of assigned responsibilities on an ongoing basis to management.
- Excellent verbal and written communication skills.
- Background in developing thorough documentation to be used for supporting production application.
- 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.
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/93539 Job Posting Date 05/06/2022 Application Deadline Full Consideration By Job Category Staff Message to Applicants
You need to sign in or create an account to save a job.
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert