The Reporting Analyst, working with system analysts, designers and functional leads will modify, develop, write and implement reporting solutions using SQL reporting Services 2008-2012, ReportsNow and Excel. This position must be adept at using query tools and must be able to determine the best source of the required information. Once the source is determined this role will then write queries, write reports, extract data, format data, reviews/tests query results to validate the results and then provide those results to end users or system analyst in accounting, operations or information technology. Additionally the job will require that code and design documents are updated as needed to ensure changes are communicated to all parties associated with the project or report. In addition to developing designed reports this position may provide ad-hoc query results to end users and assist accounting and operations with monthly reporting requirements. Reporting Analyst Job Duties: •Working knowledge of relational database concepts and reporting •Ability to perform complex data queries and mapping. Understand data modeling concepts (e.g., the entity-relation model) and their application: entities and tables, relations and constraints, attribute data types and column data types. •Experience extracting information from databases and/or data conversion projects •Experience gathering and analyzing business requirements for reporting needs •Develop and implement operational or accounting reports to alleviate problems and improve business operations. •Ensure that information is presented accurately and in a clear, concise, and business-relevant manner. •Ensure that reporting has be reconciled and tested to ensure accuracy •Understanding of customer support concepts related to reporting system operations •Adhere to existing change management procedures. Recommend improvements to existing procedures. •Documents underlying code and reports per our code maintenance guidelines •Contributes to team effort by accomplishing related results as needed. •Performs Yardi Software Maintenance as needed. •Able to learn the ReportsNow reporting package •Able to learn JD Edwards financial tables •Able to learn Yardi software data tables This position is located at the corporate headquarters of EdR Collegiate Housing.