Business Intelligence Analyst

Working for Equity Residential (EQR), a leading multi-family real estate investment trust (REIT), means being part of a community and striving to provide the best in apartment living, speaking boldly about new ideas for innovation, and inspiring creativity in the ways we work together. Our portfolio of high-quality properties in urban growth markets – New York City, Boston, Washington DC, Seattle, San Francisco and Los Angeles – provides homes where people most want to live, work and play. We've got the best people in the business, and our experience shows in our dedication to our residents and in how much we value each other as colleagues. That’s why our employees say they are proud to work at Equity, a company that gives our residents a place where they can Live Remarkably, and offers a culture where our employees have the opportunity to make their mark.

We are currently seeking an experienced, motivated, and curious Business Intelligence Analyst to join our Property Operations team in our Chicago corporate office. Under the general direction of the VP of Revenue and Business Intelligence, the BI Analyst will participate in the design, development, architecture, configuration, and implementation of business intelligence and other reporting solutions. In this role, you will assemble data from various sources to deliver solutions that solve key cross departmental business problems — including the design and creation of customized reports and dashboards that encompass best practices for business data visualizations while also embodying creativity and accuracy in advanced reporting tools. As a BI Analyst, you will demonstrate your passion for data and front-end design on a daily basis. Above all, you’ll have a direct hand in delivering tools that enable your business partners to be most successful in driving the organization forward and meeting their day-to-day goals.

• Knowledgeable. You’re comfortable with information gathering, data collection, and data analysis, in addition to problem-solving with a customer focus in mind. Without a doubt, you’ve got strong analytical skills and you know how to apply them accordingly across a variety of data-related activities.
• Technologically Savvy.  You’re comfortable working with relational database concepts and have a knack for quickly mastering new software. You are also experienced in testing with automation tools. In other words, technology is one of your closest friends!
• Business Liaison. When it comes to integrating business process with systems, you enjoy being the conduit with your business partners to lead the project execution and train affected users. You work closely with business partners to gather needs systematically, review viable solutions, test new functionality along the way, and track post-implementation results. Data helps you schedule work, implement agreed-upon changes, and complete assigned projects timely.
• A Problem Solver. Your previous experience has increased your understanding of data relationships, which has influenced your ability to identify relevant trends and effectively summarize possible solutions. As a result, you are often the go-to when it comes to translating business needs into functional and technical requirements.
• A Strong Communicator. Your writing and speaking skills are clear, articulate, and effective, demonstrating your ability to interact with all levels and various teams within the organization and be understood. In addition, you’re skilled in compiling and delivering presentations that help to coordinate efforts between business partners and IT.  By delivering clear communication, you help to ensure that projects stay on time, deliverables meet budget, and key stakeholders are aware of project statuses.
• Organized, Efficient, and Accountable. You multitask well, re-prioritize accordingly, and meet deadlines consistently. You have a keen eye for detail and pride yourself on delivering quality work.  Above all, you are flexible and able to juggle the needs of changing priorities of the business.
• Passionate. Motivated. Eager to Learn.  You are resourceful, ask smart questions, challenge the status quo, and regularly seek to understand. You invest extra energy to reach your goals. And when a special project arises, you volunteer!

• Conceptualize, design, produce, and maintain visually compelling reporting solutions (reports, dashboards, interfaces, etc.) using reporting tools, applications, and queries or scripts through the use of reporting and visualization techniques.
• Design dashboards that communicate information effectively and move audiences from inaction to action.
• Perform data evaluation and integration; data cleansing, standardization, un-duplication; data processing.
• Translate technical information for all users, technical and non-technical.
• Follow the entire development life cycle including coding, unit testing, bug fixes and maintenance (inclusive of regression testing for platform releases).
• Build efficient and accurate processes and standards that inspire organizational trust in data and provide consistent metrics across the organization.
• Explore new data mining, statistical and reporting tools to support Operations initiatives.
• Conduct deep-dive data analysis for business insights and recommendations, including ad hoc analytics for quick turn-around to inform executive level meetings.
• Perform other duties and participate in special projects, as needed.

• Bachelor’s degree in Computer Science, Design, Statistics, or related subject area required
• 3-5 years progressive experience in conducting business analysis and working with large relational or OLAP databases (Oracle or SQL)
• Must be able to write SQL queries to gather and analyze financial data and create reports
• Advanced level of MS Excel skills with knowledge of functions and macros
• Experience in data mining or data warehousing is a big plus but not required 
• Must be detail-oriented and able to work independently 
• Excellent written, verbal and presentation skills 
• Proven strong work ethic, ability to make decisions, and adaptable to changing priorities in a fast-paced environment, without sacrificing quality of work product
• Detail-oriented and well-organized, with an exceptional ability to multitask
• Team player who demonstrates flexibility and the ability to integrate and work well with others
• Strong communication and presentation skills – able to speak and write in a clear and articulate manner
• Motivation to succeed with the capacity to assume increasing responsibility

We recognize that everyone has different needs outside of work. That’s why, in addition to a competitive benefits package (medical, dental, vision and paid time off), we offer many unique options to employees, like adoption benefits and paid time off for community service projects. To learn more, view our Total Wellbeing page here.