Business Intelligence Developer II (CEMI) Hybrid

About the role

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.

Responsibilities

• Create a variety of backend objects.
• Develop complete ETL data flow models, from source system extraction transformations, loading and report creation.
• 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.
• Create business intelligence reports in support of the college's mission.
• Engage users to understand needs, gather and document requirements.
• 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.
• Aid users with reporting navigation or data questions.

Requirements

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

Qualifications

• Bachelor's Degree in Computer Science or related field preferred, equivalent work experience will be considered.
• 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.

Skills

• 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.
• Experience working in an Agile/Scrum environment.
• Experience with SAP Finance (Grants, Funds, General Ledger) or Human Capital Management (HCM Payroll, Benefits, SuccessFactors) modules.

Benefits

N/A

Pay

$130,500.00 - $149,500.00

Schedule

Hybrid Location: Midtown