Please wait while the page is being loaded Skip this advertisement >
Saturday | 6 December, 2008
Hot jobs: BI analyst
Business Intelligence analysis at a glance

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)

Computerworld Buyer's Guide - Vendors Matched to this Article
More about Kaplan, Logical, CPA, Oracle
Computerworld Buyer's Guide - Vendors Matched to this Article
Additional Resources
Executive Guides
Whitepapers
Zones
Zone logoZones provide focussed content from Computerworld and leading technology partners.
Newsletter Subscription
Sign up for our Computerworld newsletters!
RSS Feeds
Market Place

 

Smart SOA World Tour

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.
Whitepaper

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.

Enterprise IT Buyer's Guide
Find Technology Vendors Fast
 
Find vendors by name | Find by category
Sponsored Links