Job description: Business intelligence (BI) analysts use analysis tools to query data repositories and generate reports. These reports help managers make business decisions by identifying trends and patterns in a company's stored operational data. The data to be analyzed may be varied: inventory, sales, customers and the like. It is usually stored in companywide repositories called data warehouses or in smaller departmental databases. A BI analyst may design daily reports, such as those that sales managers use to track demand for specific products in different geographic regions. The BI analyst also helps managers generate one-time, ad hoc reports by crafting a custom query against the data repository. "This is definitely a hot role whose value to the company is helping it analyze its business data," says Ari Kaplan, president of the Independent Oracle Users Group.
Why you need a BI analyst: "If you don't do anything with your corporate data, it's just sitting there. To take that data and make it a business weapon, you need a BI analyst," says Jim Lanzalotto, vice president at Yoh Services, a firm that offers recruiting and outsourcing services. Analyzing data gives a company a clear view of its business operations, the key to competing effectively. By spotting trends in stored data, a company can fine-tune sales strategies, marketing programs, supply chain operations, customer support and fraud-protection efforts. A BI analyst can also detect information the company needs to make informed business decisions.
Desired skills: Deep understanding of a company's business goals and operations. Experience with database and data analysis technology, as well as with enterprise applications and project management. An MBA or CPA degree. At least five years of experience.
How to find them: Look internally first, Kaplan says. The CIO (chief information officer) might also consider candidates from the company's industry or similar sectors. Lanzalotto cautions against assuming that a hire must emerge from the IT side, since a thorough understanding of business operations is key. "Know precisely the kind of person you're looking for. The biggest flaw you have in this type of search is a lack of understanding of what you need," he says.
What to look for: Good BI analysts are very methodical so that they can devise strategies for making sense out of mounds of data. They must also have good communication skills, be logical thinkers and work well in teams. "Playing nice in the sandbox is important," says Lanzalotto. "You need the ability to get your point across effectively in small group settings."
Elimination round: Ask candidates a question that goes to the heart of their role as your BI analyst. For instance, a pharmaceutical company CIO should ask candidates how they have worked with clinical trials data and how their analysis helped the company.
Salary range: US$80,000 to US$90,000 (Midlevel), US$100,000 to US$125,000 (Senior level)
Read up on the latest ideas and technologies from companies that sell hardware, software and services. Solve Exchange Mailbox Storage Issues Once and for All
Business Intelligence and Enterprise Performance Management: Trends for Emerging Businesses
Achieving the impossible: Unlimited application scalability
Taking On Demand CRM Integration to the Next Level
Gaining Competitive Advantage Through Enterprise Planning
IT Service Management Needs and Adoption Trends: An Analysis of a Global Survey of IT Executives
Controlling storage costs with Oracle database 11g
Best Practice in Building an Integrated Information Management Strategy
Zones provide focussed content from Computerworld and leading technology partners.Discover how SOA can create smarter outcomes for your business.
Attend and learn:
- How SOA is helping leading companies to become more agile
- Where you should be applying SOA processes in your company
- The top SOA implementation mistakes to avoid
Click here for more information.
- +
Computerworld Live Podcast #97: The Future of Enterprise Networking 25/07/2008 09:45:36
This week CW Live chats with Mark Thompson, global sales and marketing manager for HP ProCurve, on the future of the enterprise networking. Mark discusses the trends we can expect to see in the near future and how the right infrastructure can ensure your enterprise network is secure. - +
Computerworld Live Podcast #96: Security at the Edge 11/06/2008 09:22:22
CW Live speaks with Amol Mitra, HP ProCurve Director of Marketing for Asia Pacific and Japan. Today's topic: how enterprises are starting to shift away from simply controlling security via server logins, firewalls and moving to more adaptive security frameworks. - +
Data Management Edition #10: Multi-Petascale Systems 02/05/2008 09:12:33
This week we look at sustainability and the development of multicore technologies to build multi-petascale systems. - +
IT Security Edition #11: How to poison the Storm botnet 01/05/2008 08:51:55
This week CW Live presents a case study on how to poison the notorious Storm botnet . Plus we take a look at Cisco's plans for Ironport. - +
IT Security Edition #10: Cyber-battles fought and won 24/04/2008 11:09:47
Vendors bow to end user pressure to improve product security, and we take a look at the latest concepts shaping the cyber-battlefield of the future.
Fortinet November Threatscape Report Shows Calm Before Holiday Storm 2008-12-05 16:00:00+11
Epicor® Cited as an Order Management Solutions Leader by Independent Research Firm 2008-12-05 15:52:00+11
F-Secure: Growth In Internet Crime Calls For Growth In Punishment 2008-12-05 13:00:00+11
International researchers gather in Sydney to preview the clever web 2008-12-05 09:48:00+11
Borderless corporate networks to shift focus to secure content management in Australia in 2009 2008-12-04 16:06:00+11
Business Intelligence and Enterprise Performance Management: Trends for Emerging Businesses
Hyperion surveyed 163 companies to understand BI and EPM requirements, evaluation processes, and extent of adoption. Top areas of current and future investment for emerging businesses include budgeting and planning as well as management reporting solutions. Read on to discover more.












