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
3 - 5 years of experience with Yardi Voyager and Elevate Minimum of 3 years technical experience as a developer 5+ years experience w / Yardi SQL development & support preferred Strong technical knowledge of MS SQL and other database languagesStrong knowledge of relational database concepts database schemas anddata hierarchies including heavy experience with Microsoft SQL Server,stored procedures, triggers, and indexes Ability to create stored procedures, triggers, views and complex queries inSQL 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 andtroubleshoot and resolve any issues which may arise Clearly communicates milestones, goals, and deliverables when workingwith others Strong critical thinking skills as it relates to identifying the root causes oftechnical issues Previous experience in the property management / real estate industryhelpful 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, CSSSkills Required
Visual Basic, Ms Sql, Apis, Ssrs, Css, yardi voyager , Microsoft Sql Server, Middleware, Sql, Html