General Summary

This role will support the business by managing and maintaining various systems, with a primary focus on SAP Business Objects, SAP Data Services, Data Integrator, Chatham, and Data Warehouse, Ivalua, Yardi. The position also involves development work critical to the business’s operations. Responsibilities include writing Data Integrator Jobs to facilitate data flow between multiple systems. Additionally, this role will assist in the creation and development of essential Dimensional and Fact Tables, which are integral to the structure and functionality of the Data Warehouse.

Essential Job Functions/Responsibilities

• Ensure timely execution of business requirements without relying on external vendors.
• Write and maintain Data Integrator (DI) jobs and tools to support business processes, specifically in the Integration Layer.
• Facilitate the migration of data between systems that do not communicate with each other, such as creating jobs to transfer mortgage data from Chatham (third-party software) to Yardi.
• Create and maintain data flows and workflows to populate data for the Data Warehouse, ensuring that data is properly structured and ready for reporting.
• Work closely with the Webi interface to generate comprehensive reports.
• Develop, write, and maintain reports using the TR2K reporting system.
• Administer the LeFrak Treasury Dashboard, ensuring that it is up-to-date and aligned with the business’s reporting and data needs.
• Collaborate with the business to identify and propose solutions that streamline daily operations and improve efficiency.
• Provide expert-level support for production issues, ensuring that any system or process-related problems are resolved promptly to minimize business disruption.
• As the Ivalua Administrator and Developer you be responsible for making necessary workflow changes or alerts in Ivalua to meet business needs, eliminating the need to go directly to Ivalua for enhancements and avoiding additional charges.
• Experience with Yardi table and data sets.
  
  

Technical Skills

• Strong practical knowledge of applications and network technologies
• Project Management experience
• Thick, thin and web client application development experience
• Ability to integrate security as part of design & development
• ETL Experience/ Demonstrated mastery of ETL concepts and best practices
• System architecture
• Demonstrated awareness of routine SQL Admin/Maintenance procedures
• Demonstrated knowledge of development and database tools
• Reporting Tools (Business Objects/Crystal Reports)
• Experience supporting financial/procurement systems
• Ability to work in a team environment with technically skilled individuals
• Proficient in creating SAP Jobs, Data Flows, and Workflows to facilitate seamless data integration.
• Experienced in creating staging tables, as well as developing necessary Dimensional and Fact tables for use in the Universe.
• Skilled in writing and developing reports using Business Intelligence tools to extract actionable insights from the Data Warehouse.
• Knowledgeable in providing support, training, making workflow changes, configuring system settings, setting up alerts, and testing new code deliveries within Ivalua.
• Proficient in using Visual Basic 6.0 and .NET for application development and enhancements.
  
  

Qualifications

• Bachelor’s Level Degree is required
• Minimum 7-8 Years Experience