Sr. Programmer Analyst
Want to feel like you're on top of the world? That's where you'll be when you join CBRE. As the leader in commercial REAL ESTATE services, we've established the global standard in providing clients with the most comprehensive service offerings and highest level of client service. And we've built that reputation with people like you. For a century now, CBRE has sought out the best talent to sustain and grow the organization. Today, we're looking for people with great ideas and fresh perspectives to establish a foundation of excellence for the next 100 years. If that sounds appealing to you, put yourself at the top of our list.
Description:
YARDI Voyager is CBRE Global Investors’ platform to account for its global funds. It provides an integrated, centralised browser-based accounting, property and fund management solution that spans the global marketplace. YARDI offers real estate investment and management tools with the ability to record and calculate real estate investment transactions, such as cash flows between levels of ownership, equity pick-ups, and consolidations of investments.
Position Overview
The Yardi Programmer Analyst will lead the design and development of Yardi database reporting for our global business, including data modelling and integration/consolidation of multiple diverse data sources. Our Yardi Voyager applications currently run on Oracle 10g version databases. Yardi applications, real estate industry/accounting knowledge, as well as experience with different reporting tools, are all desired experiences for this position. This position is located in our downtown LA headquarters.
Responsibilities
• Work closely with business analysts, project managers and end users to translate requests into database queries, analyzing data and transforming results into actionable reports
• Provide vision and guidance on the best possible report development approach using available tools
• Design and develop reports and sub-reports using both Yardi in-house reporting platforms as well as integrated reporting applications such as Crystal and Cognos
• Validate report results against requirements
• Develop stored procedures required for reporting
• Provide technical and end-user documentation for created reports
• Continuously monitor the performance of existing reports. Optimize and fine tune slow running reports
Qualifications:
• Bachelor’s degree in Computer Science, Information Technology or equivalent work experience
• Experience in developing financial, property management and accounting reports. Experience with financial applications is a great plus
• Advanced SQL report scripting skills.
• SQL tuning and performance optimization skills
• Strong Crystal Report writing
• Oracle PL/SQL skills
• XML Coding
• ASP .NET programming experience is a plus
• Yardi specific report writing experience is highly desired:
- YSL
- Crystal Reports
- Custom Analytics
- Launch Word/Excel
- Correspondence Manager
- Ad Hoc
• Advanced user of MS Office applications (Excel, Word, PowerPoint) with knowledge of Excel formulas, functions and macro experience.
• Strong requirements gathering skills.
• Superior communication and customer service skills.
• Advanced user of Excel/Word/Adobe Acrobat
• Natural ability to take ownership, act with a sense of urgency and accept challenges.
• Highly organised, with an attention to detail.
• Ability to prioritize demands of third parties.
Salary/Benefits: Salary commensurate with experience
Job Location: Los Angeles, CA
Job Number: 11709
Company Profile:
CBRE Group, Inc. (NYSE:CBG), a Fortune 500 and SP 500 company headquartered in Los Angeles, is the world’s largest commercial real estate services firm (in terms of 2010 revenue). The Company has approximately 31,000 employees (excluding affiliates), and serves real estate owners, investors and occupiers through more than 300 offices (excluding affiliates) worldwide. CBRE offers strategic advice and execution for property sales and leasing; corporate services; property, facilities and project management; mortgage banking; appraisal and valuation; development services; investment management; and research and consulting. Please visit our Web site at www.cbre.com .
CBRE Global Investors, a global real estate investment management firm with over $94 billion in assets under management, sponsors investment programs across the risk/return spectrum for institutional investors worldwide.
As an independently operated affiliate of CBRE (NYSE:CBG), CBRE Global Investors harnesses the research, investment sourcing and other resources of the world's premier, full-service real estate services company for the benefit of its investor clients and partners. Including partners and affiliates, CB Richard Ellis has over 300 offices in more than 50 countries.
To be considered for a position with CBRE, Inc., please apply online at http://cbre.com/careers . Click on “Search and Apply” on the left side of the screen. If a pop-up window does not open, please check your browser’s settings. On the login window either login with your existing username and password or click on “Register Today” to create one. Once you are logged in you can either apply for specific jobs or submit your general application using the link at the bottom of the page.
Current CBRE employees should apply online through the myHR section of Employee Self Service.
EOE AA Employer M/F/D/V
Open all references in tabs: [1 - 3]