Business Intelligence Developer II (CEMI)

Weill Cornell Medicine - Qatar; New York (NY); On-site; USD 131,000 - 150,000; Full time

Job summary

Cornell University is seeking a Business Intelligence Developer II (CEMI) to design and implement SAP BI solutions across BW, BODS, HANA, and analytics platforms. The role involves creating data warehouses, ETL processes, and reporting layers while guiding junior developers and collaborating with analysts to meet complex requirements.

The position is contingent, expected through Fall 2028 with NYC office work and strong emphasis on data integrity, security, and performance.

Qualifications

• Bachelor's degree or equivalent work experience.
• Minimum 5 years hands-on SAP BI development experience.
• Experience with SAP BW, BODS, and SAP HANA modeling.
• Experience with ABAP, SAP Analytics Cloud, and Power BI.

Responsibilities

• Create ETL data flows and backend objects for SAP BI solutions.
• Develop reporting infrastructure and complex SAP BI reports.
• Build data extractions and transformations including user exits in ABAP.
• Develop BI reports to support the college's mission and gather requirements.
• Analyze problems, design innovative solutions, and collaborate with teams.
• Troubleshoot data loads, optimize performance, and ensure data quality.
• Prepare test scripts to validate report accuracy and requirements.
• Provide end-user support and training for reporting tools.

Skills

SAP BW

SAP BODS

SAP HANA

SAP Analytic Cloud

Power BI

DAX

R

Python

SQL

SAP authorization

Agile/Scrum

SAP Finance/HCM modules

ABAP

Education

Bachelor's Degree in Computer Science or related field

Tools

Power BI Dashboard development

Job description

Title: Business Intelligence Developer II (CEMI)

Title: Business Intelligence Developer II (CEMI)

Location: Midtown

Work Days:

Weekly Hours:35.00

Exemption Status:Exempt

Salary Range:$130,500.00-$149,500.00

*As required under NYC Human Rights Law Int 1208-2018 - Salary range for this role when Hired for NYC Offices

Position Summary

Is responsible for the creation of data warehousing and reporting solutions utilizing the SAP tools across multiple systems including SAP HANA, Business Warehouse (BW) and Data Services. Create the backend data warehouse infrastructure utilizing various SAP ETL options available, and reporting layer 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. Convert 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.

This is a term position anticipated to be needed through Fall 2028 but may be ended or extended based on organizational needs, funding availability, and performance.

Job Responsibilities

• Create a variety of backend objects. Develop complete ETL data flow models, from source system extraction 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.

Education

• Bachelor's Degree in Computer Science or related field preferred
• equivalent work experience will be considered.

Experience

• Minimum of 5 years hands on experience with the development of SAP BI models (SAP BW and SAP BODS) and minimum of 5 full lifecycle projects.
• Experience with HANA Modelling
• Experience with SAP Analytic Cloud Report creation
• Hands on experience with Power BI Dashboard development
• Hands on experience in DAX(Data Analysis expressions) language to create DAX columns and measures over data models for the purpose of enhancing Power BI visuals.
• Expertise writing scripts in R and Python.
• Solid understanding of database management concepts, including sequences and programming with SQL, SQL Script, and stored procedures
• Strong experience on publishing and distributing Business Intelligence reports
• Hands on experience in SAP authorization
• Solid Power BI experience
• Experience working in an Agile/Scrum environment.
• Experience with SAP Finance (Grants, Funds, General Ledger) or Human Capital Management (HCM Payroll, Benefits, SuccessFactors) modules.

Knowledge, Skills and Abilities

• Strong verbal and written communication skills.
• Excellent organizational skills and ability to multi-task.
• Excellent analytical and problem-solving skills.
• Desire to assume increasing levels of responsibility and to learn new skills.
• Strong ability to problem-solve, troubleshoot, and apply root cause analysis
• Desire to work in a highly collaborative environment
• Knowledge in Research Administrative Systems like InfoEd, and understanding of research attributes, workflows and processes.

Licenses and Certifications

Working Conditions/Physical Demands

Position requires working in an office environment where there some physical discomforts such as dust, dirt, noise, and the like are present. Ability to work off-hours and weekends for go-lives, testing and emergencies, as well as travel between office locations, primarily within NYC is required. Occasional meetings or clinical staff interactions in typical patient care areas may be required though direct patient exposure is not expected. Occasional moving of computer equipment or similar objects up to approximately 50lbs may be required to expedite projects

Cornellwelcomes students, faculty, and staff with diverse backgrounds from across the globe to pursue world-class education and career opportunities, to further the founding principle of “any person, any study.” No person shall be denied employment on the basis of any legally protected status or subjected to prohibited discrimination involving, but not limited to, such factors as race, ethnic or national origin, citizenship and immigration status, color, sex, pregnancy or pregnancy-related conditions, age, creed, religion, actual or perceived disability (including persons associated with such a person), arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual’s genetic information, domestic violence victim status, familial status, marital status, or any other characteristic protected by applicable federal, state, or local law.

Cornell University embraces diversity in its workforce and seeksjob candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. Wehire based on merit, andencourage people from historically underrepresented and/or marginalized identities to apply.Consistent with federal law, Cornell engages in affirmative action in employment for qualified protected veterans as defined in the Vietnam Era Veterans’ Readjustment Assistance Act (VEVRRA) and qualified individuals with disabilities under Section 503 of the Rehabilitation Act. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.