Business Intelligence Developer II (CEMI) Hybrid
About The Position
Responsible for designing, developing, and supporting business intelligence, reporting, and data visualization solutions using Power BI and other BI tools. Leverages data from SAP BW/HANA, Amazon Redshift, SQL databases, and other enterprise systems to deliver scalable and actionable insights. Partners with business stakeholders to translate requirements into effective analytics solutions and utilize Informatica and related ETL technologies to ensure data quality and performance. The ideal candidate will have experience with Power BI, SAP, Redshift, SQL, and Informatica, along with a strong understanding of data warehousing, business intelligence best practices, and exposure to AI, Generative AI, or AI-driven analytics solutions. 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.
Requirements
- Bachelor's Degree in Computer Science or related field preferred
- equivalent work experience will be considered.
- 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.
- 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.
Nice To Haves
- exposure to AI, Generative AI, or AI-driven analytics solutions.
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.
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
