Business Intelligence Developer II

Weill Cornell Medicine

New York (NY)

On-site

USD 131,000 - 150,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Weill Cornell Medicine is seeking a Business Intelligence Developer II to design and implement data warehousing and reporting solutions using SAP tools across SAP BW, BODS, and HANA environments. You will collaborate with analysts to translate requirements into robust BI solutions, ensure data integrity, and optimize data loads and reports while mentoring junior developers.

The role requires 4+ years of hands-on SAP BI experience, a Bachelor’s degree in a related field, and the ability to work

Qualifications

  • 4+ years of SAP BI development experience.
  • Experience with SAP BW and SAP BODS lifecycle projects.
  • Experience with HANA modelling and reporting tools.
  • Knowledge of InfoEd or related research systems preferred.

Responsibilities

  • Develop ETL data flows from source to target and document data models.
  • Build reporting backends and complex reports to meet requirements.
  • Create ABAP extractions and data transformations.
  • Publish and distribute BI reports across audiences.
  • Collaborate with analysts to translate requirements into BI solutions.
  • Troubleshoot performance issues and optimize loads.
  • Create test scripts to validate report accuracy.
  • Provide end-user support and training on reporting.

Skills

SAP BI
Data warehousing
ETL development
ABAP development
SAP BW
Web Intelligence
Information Designer

Education

Bachelor's Degree in related field

Tools

SAP BW
SAP BODS
SAP HANA
BEx Query Designer
Web Intelligence
Analysis for Excel
Dashboard Designer
Design Studio
Crystal Reports Designer
Information Designer

Job description

Select how often (in days) to receive an alert:

Title: Business Intelligence Developer II

Title: Business Intelligence Developer II

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), 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.

Job 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 andpartner 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 related field
Experience

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.

Knowledge, Skills and Abilities
  • 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.
  • 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
Licenses and Certifications
Working Conditions/Physical Demands

Cornell welcomes 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, 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 seeks job candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. We hire based on merit, and encourage 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). We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Integration Engineer II- SAP BW (CEMI)- 2 Year Term Appointment
Data Integration Engineer II- SAP BW (CEMI)- 2 Year Term Appointment

Weill Cornell Medicine • New York (NY)

On-site
USD 130,000 - 143,000
Data Integration Engineer II- Informatica (CEMI)- 2 Year Term Appointment
Data Integration Engineer II- Informatica (CEMI)- 2 Year Term Appointment

Weill Cornell Medicine • New York (NY)

On-site
USD 130,000 - 143,000
Consulting Application Developer / Business Intelligence Report Developer
Consulting Application Developer / Business Intelligence Report Developer

Rutgers University • New Brunswick (NJ)

Hybrid
USD 122,000 - 176,000
Medical benefits
Paid vacation
Retirement plan
+3
Engineer, Business Intelligence
Engineer, Business Intelligence

Great Lakes Cheese, Inc • Hiram Township (OH)

On-site
USD 85,000 - 110,000
Senior SAP BI Developer - ETL & Reporting
Senior SAP BI Developer - ETL & Reporting

Weill Cornell Medicine • New York (NY)

On-site
USD 131,000 - 150,000
Business Intelligence Developer
Business Intelligence Developer

Fordham • New York (NY)

On-site
USD 90,000 - 110,000
Business Intel Developer II
Business Intel Developer II

University of Rochester • United States

On-site
USD 61,000 - 85,000
Business Intelligence Developer
Business Intelligence Developer

Albany International • Portsmouth (NH)

On-site
USD 110,000 - 140,000
9/80 work schedule
401(k) match
Health benefits
+1
Workday & Snowflake Report Developer
Workday & Snowflake Report Developer

New Jersey Institute of Technology • Newark (NJ)

Hybrid
USD 79,000 - 149,000
Workday & Snowflake Report Developer
Workday & Snowflake Report Developer

New Jersey Institute of Technology • Randolph (VT)

Hybrid
USD 79,000 - 149,000