Business Intelligence Developer II
About The Position
Is responsible for the creation of data warehousing and reporting solutions utilizing the SAP tools across multiple systems including SAP HANA, Business Warehouse (BW), Data Services and Business Objects toolsets. Creates the backend data warehouse infrastructure utilizing various SAP ETL options available, and reporting layer like Universes to ensure data integrity, security, and report/data load performance. Engages with business analysts and subject matter experts to gather and document requirements, with minimum supervision. Converts requirements into professional reporting solutions. Ensures the quality of junior developer work products, ability to propose and develop innovative solutions to complex problems/user requirements, by providing technical support and guidance to junior developers. Demonstrates proficiency in backend and/or front-end development objects.
Requirements
- Minimum of 4 years hands on experience with the development of SAP BI models (SAP BW and SAP BODS) and a minimum of 4 full lifecycle projects.
- Experience with HANA Modelling developing reports using BEx Query Designer, Web Intelligence, Analysis for Excel, Dashboard Designer, Design Studio and Crystal Reports Designer, with a minimum of 4 full lifecycle projects.
- Hands on experience with the creation of Universes using the Information Designer.
- Experience publishing and distributing Business Objects reports via the BEx Broadcaster, BI Launch Pad (InfoView), BI Workspaces, folder structures, Life Cycle Manager, and authorizations.
- Strong verbal, written communications, and interpersonal skills.
- Organizational skills and ability to multi-task.
- Solid analytical and problem solving ability.
- Desire to assume increasing levels of responsibility and to learn new skills.
Nice To Haves
- Experience with SAP Finance (Grants, Funds, General Ledger) or Human Capital Management (HCM – Payroll, Benefits, SuccessFactors) modules.
- Experience with reporting from Research Administrative Systems like InfoEd, and understanding of research attributes, workflows and processes
Responsibilities
- Create a variety of backend objects.
- Develop complete ETL data flow models, from source system extraction to transformations, loading and report creation.
- Document solution directions, data flows, design and technical specifications.
- Create reporting backend infrastructure and reports.
- Create complex reports and develop reporting solutions that enhance the end user experience and meet business requirements.
- Develop extractions, transformation routines, and user exits using ABAP development programming language.
- Develop business intelligence reports in support of the college’s mission.
- Engage users to understand needs, gather and document requirements.
- Follows functional specification documents to ensure report work products meet the needs of the requester.
- Analyze complex problems.
- Recommend and implement innovative solutions.
- Communicate requirements and partner with other developers to analyze complex data and process issues.
- Troubleshoot and resolve technical issues, debug, tune and optimize data load and report performance.
- Work closely with Basis and Portal teams to optimize system performance and monitor usage.
- Create and execute test scripts to ensure that reports provide accurate results and meet the requirements of the customer.
- Collaborate and coordinate with developers and Business Analysts to analyze complex problems and recommend innovative solutions.
- Provide end user and support desk support and provide resolutions.
- Assist users with reporting navigation or data questions.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
