Job
Description
Role Overview: As a developer in this role, you will be responsible for creating custom database stored procedures, triggers, views, and complex queries in SQL. You will also develop custom Yardi reports using SQL, YSR, SSRS, Custom Analytics, Report Scheduler, and other Yardi and SQL reporting tools. Additionally, you will take the lead on initiatives for integrations and APIs between applications and maintain and modify a suite of custom Excel reports using Visual Basic. Your role will involve working with PM/Client teams to identify gaps in reporting and define/create reporting solutions to address those issues. Moreover, you will assist with new product rollouts by reviewing existing custom and standard reporting and modifying or creating new reports as necessary. You should possess the ability to create custom tools as needed to support internal and client-facing teams, which could involve web-based applications or integrations with new software. Providing advice, guidance, and designing effective application systems architecture for the client's system will also be part of your responsibilities. You will interpret written business requirements and technical specification documents to design and develop technical solutions that meet business needs, as well as develop technical design documents and test scripts. Key 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 - Assist with new product rollouts by reviewing and modifying or creating new reports - Create custom tools as needed to support internal and client-facing teams - Provide advice, guidance, and design effective application design and system architecture - Interpret written business requirements and technical specification documents - Develop technical design documents and test scripts - Extraction and import of client data during software migration efforts - Provide level three application support focused on research, remediation, and documentation of complex application and technical support issues Qualification Required: - 3 - 5 years of experience with Yardi Voyager and Elevate - Minimum of 3 years technical experience as a developer - 5+ years experience with 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 arising issues - Clearly communicate milestones, goals, and deliverables when working with others - Strong critical thinking skills in identifying the root causes of technical issues - Previous experience in the property management/real estate industry is helpful - Working knowledge of software development life cycle (SDLC) and Agile/Scrum development methodologies - Knowledge in various other Yardi modules is a plus: Job Cost, Maintenance, GL, Investment Accounting, Fixed Assets, International, Rent Caf CRM, Advanced Budget and Forecasting, Elevate, Orion - Knowledge of HTML, CSS,
