Business Intelligence Developer / Architect Career

Information Technology

 
Information Technology Careers | Business Intelligence Developer / Architect

Business Intelligence Developer / Architect

Career Area: Information Technology

Occupation Group: Business Intelligence

Salary

Percentile wages tell how much a certain percentage of an overall population in a geographic area or within a given industry or field makes. The percentile wage estimate is the value of a wage below which a certain percent of workers fall.

An example would be the 25th percentile, 25 percent of workers employed in that occupation earn less and 75 percent earn more than the estimated wage value. At the 75th percentile, 75 percent of workers employed in that occupation earn less and 25 percent earn more than the estimated wage value.

A typical Business Intelligence Developer / Architect earns the following wages (national and state):

State

The average salary in North Carolina for those pursuing this career is $98,614

*The salaries depicted here are representative of the range of salaries posted in job listings over the past year. Living wage in North Carolina is $30,000.

National

The average salary in the United States for those pursuing this career is $99,086

*The salaries depicted here are representative of the range of salaries posted in job listings over the past year. Living wage in North Carolina is $30,000.

What Does a Professional in this Career Do?

Develops and builds technology systems that support business intelligence for a company. Identifies software needed for business intelligence analysts; sets up systems for collecting data on business operations, customers or sales.

Employment Trends

The job demand and job growth statistics shown here were derived from job posts over the past year. Expected job growth projections are extrapolated from year-over-year job post listing history.

Job demand and job growth is expected at the following rates:

Growth
North Carolina1469+37.9%
Nationwide27707+30.7%

Skills

A professional in this position typically utilizes the following skills in the course of everyday work in this exciting and challenging field:

Baseline Skills

The following are baseline skills every Business Intelligence Developer / Architect is expected to have in order to experience success in this field:

  • Communication Skills: The ability to convey information to another effectively and efficiently.
  • Teamwork / Collaboration: Experience working in collaborative efforts with a team to achieve a common goal or to complete a task in the most effective and efficient way.
  • Problem Solving: Problem solving consists of using generic or ad hoc methods, in an orderly manner, for finding solutions to problems.
  • Troubleshooting: Troubleshooting or dpanneuring is a form of problem solving, often applied to repair failed products or processes on a machine or a system.
  • Writing: Experience expressing business messages effectively in written form. This may include planning drafting and revising as necessary.

Specialized Skills

These skills are specific to working in this career:

  • SQL: SQL ( ESS-kew-EL or SEE-kwl, Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
  • Business Intelligence: Business Intelligence (BI) comprises the set of strategies, processes, applications, data, technologies and technical architectures which are used by enterprises to support the collection, data analysis, presentation and dissemination of business information.
  • Data Warehousing: In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence.
  • Microsoft Power BI: Working experience of Microsoft Power BI. Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.
  • Extraction Transformation and Loading (ETL): In computing, Extract, Transform, Load (ETL) refers to a process in database usage and especially in data warehousing.

Distinguishing Skills

Any Business Intelligence Developer / Architect that possesses the following skills will stand out against the competition:

  • Big Data: Big data is a term for data sets that are so large or complex that traditional data processing application software is inadequate to deal with them.
  • Performance tuning: Working experience of Performance tuning, which is the improvement of system performance. Typically in computer systems, the motivation for such activity is called a performance problem, which can be either real or anticipated. Most systems will respond to increased load with some degree of decreasing performance. A system's ability to accept higher load is called scalability, and modifying a system to handle a higher load is synonymous to performance tuning.
  • Microsoft SQL: Microsoft SQL Server is a relational database management system developed by Microsoft.
  • Database Design: Working experience organizing data according to specific database models. Determining what data must be stored and how the data elements interrelate.
  • Data Architecture: In information technology, data architecture is composed of models, policies, rules or standards that govern which data is collected, and how it is stored, arranged, integrated, and put to use in data systems and in organizations.

Salary Boosting Skills

A professional who wishes to excel in this career path may consider developing the following highly valued skills:

  • SAP HANA: Working experience of SAP HANA, which is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as a database server is to store and retrieve data as requested by the applications.

Education

This career typically requires the following level of education. The numbers presented in the pie charts below were derived from actual job posts over the past year. Not all job postings list education requirements.

.
Education Level%
Bachelor's Degree76%
Master's Degree14%
Doctoral Degree1%

Experience

This position typically requires the following level of experience. The numbers presented in the pie charts below were derived from actual job posts over the past year. Not all job postings list experience requirements.

Experience Required%
0 to 2 years14%
3 to 5 years54%
6 to 8 years20%

Many of the programs offered through NC State are designed for working professionals who need additional credentials to enhance existing work experience.

Students who do not have the expected level of experience may wish to look into internship and employment opportunities.

Common Job Titles

It is possible to find work in this field in positions commonly listed as the following job titles:

  • Bi Developer
  • Business Intelligence Developer
  • Azure Architect
  • Power Bi Developer
  • Devops Architect

Similar Occupations

If you are interested in exploring similar occupations, you may want to research the following job titles:

Not sure where to start?

Get personalized program recommendations with Career Insight.

Go to Career Insight