Yardi Technical Consultant

The Apex Group was established in Bermuda in 2003 and is now one of the world’s largest fund administration and middle office solutions providers.

Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.Your career with us should reflect your energy and passion.

That’s why, at Apex Group, we will do more than simply ‘empower’ you. We will work to supercharge your unique skills and experience.

Take the lead and we’ll give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities.

For our business, for clients, and for you

Duties & Responsibilities

• 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.
• The ability to create custom tools as needed in support of internal and client-facing teams. These could include web-based applications or integrations with new software.
• Provide advice and guidance as well as 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.
• Extraction and import of client data during software migration efforts
• Provide level three application support which is focused on the research, remediation, and documentation of more complex application and technical support issues.

Required Education & Experience

• 9-10 years of experience with Yardi Voyager and Elevate
• Minimum of 5 years technical experience as a developer
• 5+ years experience Yardi SQL development & support preferred
• 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
• Previous experience in the property management/real estate industry helpful
• Working knowledge of software development life cycle (SDLC) and Agile / Scrum development methodologies.
• Knowledge in various other Yardi modules a plus: Job Cost, Maintenance, GL, Investment Accounting, Fixed Assets, International, Rent Café CRM, Advanced Budget and Forecasting, Elevate, Orion
• Knowledge of HTML, CSS

Disclaimer: Unsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.