Business Analyst - BI

  • location: Rolling Meadows, IL
  • type: Temp to Perm
  • salary: $50 - $59.70 per hour

job description

Business Analyst - BI

job summary:
Our client, a fortune 500, world class insurance organization is looking for a Sr. Business Analyst. The ideal candidate with have background in Business Intellignce blended with insurance related projects.

location: Rolling Meadows, Illinois
job type: Contract
salary: $50.00 - 59.70 per hour
work hours: 8am to 4pm
education: Bachelors
Business Intelligence Business Analyst (BIBA) - Techno-functional role. Involved in gathering BI requirements from stakeholders, analysis of BI requirements, translating functional requirements to technical requirements, conducting pre UAT's ( user acceptance testing) and setup UAT. Additionally may also create reports, understand trends and patterns and share with management, however this is not the core responsibility. Is part of the BI Team with both domain and technical knowledge.

Hard Skills:

1. Business Acumen

A fundamental skill for the BI BA is the ability to understand and converse in the business domain specific to the particular industry and organization they are analyzing. The BI BA needs a solid foundation of knowledge of the industry as well as the organization's business model, strategy and objectives, its key issues and its competitors. Strong business acumen helps the BI BA as they follow a top-down approach translating the organization's strategy into Key Performance Indicators (KPIs), measures and metrics. This may be done for executive, management or operational levels to support strategic, tactical or day-to-day decision-making.

2. Data Analysis And Modelling

Ability to understand data and information and convert this into insights. The BI BA must be able to think conceptually, using high-level data models to conceptually map the real world of the organization. They also need a firm understanding of how data moves from operational source systems across the organization, through the various transformation processes, to where it is ultimately used by decision-makers.

3. BI-Specific Software And Analytics Programs

Employers typically seek super-user level skills in Microsoft (MS) Office applications, specifically advanced Excel for analyzing and pivoting data, the ability to use Visio for data modeling and possibly also knowing SharePoint to build custom input lists. MS Access skills are less in demand, possibly only needed on specific projects where a client department may already be using this.

Proficiency in a query language, such as Microsoft SQL, is highly sought after by employers. The capability to see and analyze data helps with the much-needed hands-on and data-focused nature of BI analysis. It helps understand the format, grain and structure of the data and moves analysis from intangible to tangible, real-life examples.

Additionally, BI BAs working in the analytics space must know how to use Commercial off the Shelf (COTS) BI and analytics software applications. (i.e.; SSRS, PowerBI)

4. BI Methodology And BI Journey

The traditional BA must understand the Systems Development Lifecycle (SDLC). Similarly, the BI BA must know both the BI methodology and BI journey for their particular department and organization.

In terms of BI methodology, the BI BA must specifically know: how requirements flow through BI development processes; key handover points, who the BI team members are and how to collaborate with them and; governance and maintenance processes required in operations after project conclusion.

The BI journey entails understanding the overall organizational approach to BI in terms of how the organization intends to move from maturity to maturity level, the technological platform and tools it plans to use to do this and what organizational structure it sees of use in getting there.


5. Big Picture AND Detail Oriented

Paradoxically both of these skills are required. Often the BI BA is working in the minutia - the finest grain of data - and needs to understand this in all its subtle details. These may entail where it is sourced from, what are the transformation rules, who uses it, who owns it, etc. At the same time, they need to understand the organization's vision, how this translates into the various strategic, tactical and operational level objectives and then how to translate the objectives into KPIs, metrics and measures that link to detailed data elements.

6. Ability To Navigate Politics

BI solutions typically cross a number of functional areas and departments, where key stakeholders may have their own agendas for a particular BI solution or may be fearful of or unwilling to share information. While the common mantra in business cases for BI solutions is "a single version of the truth", the BI BA needs to be able to navigate politics such as turf wars between departments and key stakeholders and inability to define key business and data terminology.

7. High Tolerance For Ambiguity And Ability To Create Structure

BI scope and requirements are notoriously ill-defined upfront, emerging as further information comes to light through analysis. Additionally, data quality and structure are also not usually known upfront. The BI BA needs the soft skills to confidently manage through the fog, creating stability and structure for themselves, their BI team members and their business stakeholders as they proceed.

  • Experience level: Experienced
  • Minimum 7 years of experience
  • Education: Bachelors (required)
  • Business Analysis
  • SQL
  • Business Intelligence

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

get jobs in your inbox.

sign up

related jobs

    Business Analyst - BI

  • location: Rolling Meadows, IL
  • job type: Contract
  • salary: $50 - $59.70 per hour
  • date posted: 6/16/2021

    Business Analyst - BI

  • location: Rolling Meadows, IL
  • job type: Contract
  • salary: $50 - $59.70 per hour
  • date posted: 6/18/2021