Yardi Technical Consultant

Overview

Apex Group is hiring a Yardi Technical Consultant to build custom Yardi reports, database objects, integrations and application support for internal and client-facing teams.

What you'll do

• Create custom database stored procedures, triggers, views, and complex queries in SQL.
• Develop custom Yardi reports using SQL, YSR, SSRS, Custom Analytics, Report Scheduler and other Yardi and SQL reporting tools.
• Lead initiatives for integrations and APIs between applications.
• Maintain and modify a suite of custom Excel reports using Visual Basic.
• Work with PM / Client teams to identify gaps in reporting and define/create reporting solutions to solve those issues.
• Assist with new product rollouts by reviewing existing custom and standard reporting and modifying or creating new reports as needed.
• Create custom tools as needed in support of internal and client-facing teams, including web-based applications or integrations with new software.
• Provide advice and guidance, and design and develop effective application design and system architecture for the client's system.
• Interpret written business requirements and technical specification documents to design and develop technical solutions that meet business needs.
• Develop technical design documents and test scripts.
• Extract and import client data during software migration efforts.
• Provide level three application support focused on the research, remediation, and documentation of more complex application and technical support issues.

What you'll need

• 9-10 years of experience with Yardi Voyager and Elevate.
• Minimum of 5 years technical experience as a developer.
• Strong technical knowledge of MS SQL and other database languages.
• Strong knowledge of relational database concepts, database schemas and data hierarchies, including heavy experience with Microsoft SQL Server, stored procedures, triggers, and indexes.
• Ability to create stored procedures, triggers, views and complex queries in SQL.
• Understanding of systems integrations, APIs, and middleware.
• Previous experience in SQL report creation and troubleshooting.
• Ability to implement data conversions for large disparate data sets and troubleshoot and resolve any issues which may arise.
• Clearly communicates milestones, goals, and deliverables when working with others.
• Strong critical thinking skills as it relates to identifying the root causes of technical issues.
• Working knowledge of software development life cycle (SDLC) and Agile / Scrum development methodologies.

Nice to have

• 5+ years experience Yardi SQL development & support.
• Previous experience in the property management/real estate industry.
• Knowledge in other Yardi modules: Job Cost, Maintenance, GL, Investment Accounting, Fixed Assets, International, Rent Café CRM, Advanced Budget and Forecasting, Elevate, Orion.
• Knowledge of HTML, CSS.

Details

• Employment type: Full-time.
• Work from office in Mumbai, Pune.
• Job function: Information Technology.