Database Developer

Job Title

Job Description

- Design, build, and manage reports and data feeds for accounting and financial systems.

- Develop and support custom solutions integrated with Yardi Systems, including reporting and data extraction.

- Provide advanced troubleshooting and support for data and system issues.

- Collaborate with Business Analysts to assist in solution design and perform gap analysis between specifications and system capabilities.

- Ensure data integrity and baseline object consistency across multiple databases.

- Author technical documentation for internal processes and best practices.

- Stay current with industry technology trends and methodologies.

- Write efficient and optimized SQL queries, stored procedures, and functions.

- Create and manage automated data feeds and scheduled reporting processes.

- Investigate and resolve data inconsistencies, performance bottlenecks, and system errors.

- Participate in Agile/Scrum activities such as sprint planning, stand-ups, and retrospectives.

- Use Microsoft Excel to manipulate, analyze, and visualize data.

- Collaborate with Business Analysts to translate business requirements into technical solutions and identify system limitations or enhancement opportunities.

- Experience using Yardi Systems or developing custom solutions for Yardi databases is required.

- 2+ years of hands-on experience in software or database development.

- Strong proficiency in MS SQL, including writing complex queries, stored procedures, and performance tuning.

- Strong knowledge of Microsoft Excel, including formulas, pivot tables, and data analysis tools.

- Familiarity with version control systems such as Git.

- Experience working in Agile development environments.

- Proficiency using Data Integration Tools (SSIS, Azure Data Factory, etc.) is a plus.

- Experience with accounting systems or financial data is highly desirable.
 

- Strong analytical and problem-solving skills.

- Effective communication and teamwork abilities.

- High attention to detail and commitment to quality.

- Ability to manage multiple priorities and meet deadlines.

- Willingness to learn and adapt to new technologies.

- Comfort working with accounting-related data and terminology.

- Ability to bridge the gap between business requirements and technical implementation.

- Self-motivated with a continuous improvement mindset.