Business Intelligence Analysts
15-2051.01
Produce financial and market intelligence by querying data repositories and generating periodic reports. Devise methods for identifying data patterns and trends in available information sources.
Sample of reported job titles: Business Intelligence Analyst, Competitive Intelligence Analyst, Data Analyst, Market Intelligence Analyst, Market Intelligence Consultant, Strategic Business and Technology Intelligence Consultant, Strategist
Occupation-Specific Information
Tasks
- Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
- Synthesize current business intelligence or trend data to support recommendations for action.
- Maintain library of model documents, templates, or other reusable knowledge assets.
- Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs.
- Manage timely flow of business intelligence information to users.
- Collect business intelligence data from available industry reports, public information, field reports, or purchased sources.
- Analyze competitive market strategies through analysis of related product, market, or share trends.
- Maintain or update business intelligence tools, databases, dashboards, systems, or methods.
- Identify or monitor current and potential customers, using business intelligence tools.
- Disseminate information regarding tools, reports, or metadata enhancements.
- Provide technical support for existing reports, dashboards, or other tools.
- Identify and analyze industry or geographic trends with business strategy implications.
- Communicate with customers, competitors, suppliers, professional organizations, or others to stay abreast of industry or business trends.
- Create or review technical design documentation to ensure the accurate development of reporting solutions.
- Analyze technology trends to identify markets for future product development or to improve sales of existing products.
- Conduct or coordinate tests to ensure that intelligence is consistent with defined needs.
- Document specifications for business intelligence or information technology reports, dashboards, or other outputs.
Technology Skills
- Access software - Citrix cloud computing software
- Accounting software - Fund accounting software; Tax software
-
Analytical or scientific software -
IBM SPSS Statistics π₯; Minitab; Rogue Wave Software IMSL Numerical Libraries; SAS
; StataCorp Stata; The MathWorks MATLAB π₯
- Application server software - GitHub π₯; Oracle WebLogic Server; Red Hat WildFly
- Backup or archival software - Veritas NetBackup
-
Business intelligence and data analysis software -
Alteryx software π₯; Apache Spark π₯; IBM Cognos Impromptu; Microsoft Power BI ; MicroStrategy; Oracle Business Intelligence Enterprise Edition; Qlik Tech QlikView; Tableau
- Cloud-based data access and sharing software - Microsoft SharePoint π₯
- Cloud-based management software - IBM WebSphere; Splunk Enterprise π₯
- Communications server software - IBM Domino
- Computer aided design CAD software - PTC Creo Parametric
- Content workflow software - Atlassian JIRA π₯
- Customer relationship management CRM software - Blackbaud The Raiser's Edge; Oracle Eloqua; Oracle Siebel Marketing Resource Management; Salesforce software π₯
- Data base management system software - Amazon DynamoDB π₯; Apache Cassandra π₯; Apache Hadoop π₯; Apache Hive π₯; Apache Pig; Apache Solr; Elasticsearch π₯; MongoDB π₯; MySQL π₯; NoSQL π₯; Oracle PL/SQL π₯; Relational database management software; Teradata Database π₯
- Data base reporting software - Actuate Eclipse BIRT; Information Builders WebFOCUS; Microsoft Proclarity; Microsoft SQL Server Reporting Services SSRS π₯; Panorama NovaView; Reporting software; SAP Crystal Reports; SiSense Prism
-
Data base user interface and query software -
Airtable; Amazon Elastic Compute Cloud EC2 π₯; Amazon Redshift π₯; Amazon Web Services AWS software π₯; Database software; FileMaker Pro; IBM DB2 π₯; Microsoft Access ; Microsoft SQL Server π₯; Oracle Database π₯; Oracle Essbase; Oracle JDBC; Structured query language SQL ; Transact-SQL π₯
- Data mining software - Data warehouse software; Google Analytics π₯; Informatica Data Explorer; SAP NetWeaver BW
- Desktop communications software - Eko; Skype
- Desktop publishing software - Microsoft Publisher
- Development environment software - Adobe ActionScript; Apache Ant; Apache Kafka π₯; Business Objects Data Integrator; C π₯; Common business oriented language COBOL; Eclipse IDE π₯; Go π₯; Integrated development environment IDE software; Microsoft .NET Framework π₯; Microsoft Azure software π₯; Microsoft PowerShell π₯; Microsoft Visual Basic π₯; Microsoft Visual Basic for Applications VBA π₯; Microsoft Visual Basic Scripting Edition VBScript; Microsoft Visual Studio π₯; Ruby π₯
- Document management software - Adobe Acrobat π₯
- Electronic mail software - IBM Notes; Microsoft Exchange; Microsoft Outlook π₯
- Enterprise application integration software - Extensible markup language XML π₯; IBM InfoSphere DataStage; Microsoft SQL Server Integration Services SSIS π₯; SAP BusinessObjects Data Integrator
-
Enterprise resource planning ERP software -
Enterprise resource planning ERP software; Microsoft Dynamics π₯; Microsoft Dynamics GP; NetSuite ERP; Oracle Fusion Applications; Oracle Hyperion; Oracle JD Edwards EnterpriseOne; Oracle PeopleSoft π₯; Oracle PeopleSoft Financials; SAP Business Objects; SAP software
- Enterprise system management software - IBM Power Systems software
- File versioning software - Git π₯
- Financial analysis software - Delphi Technology; IBM Unica Enterprise; Oracle E-Business Suite Financials
- Geographic information system - ESRI ArcGIS software π₯; Geographic information system GIS software
- Graphical user interface development software - Salesforce Visualforce
- Human resources software - Human resource management software HRMS; Oracle Taleo
- Information retrieval or search software - LexisNexis
- Medical software - Epic Systems π₯; Healthcare common procedure coding system HCPCS; Medical condition coding software; Medical procedure coding software; MEDITECH software π₯
- Metadata management software - Data modeling software; Informatica software π₯; Quest Erwin Data Modeler
- Network monitoring software - Nagios; Wireshark
- Network security and virtual private network VPN equipment software - Virtual private networking VPN software
-
Object or component oriented development software -
Advanced business application programming ABAP; Apache Groovy; C# π₯; C++ π₯; jQuery π₯; Jupyter Notebook; Microsoft ActiveX; Oracle Java π₯; Perl π₯; Python ; R ; Scala π₯; Swift π₯
- Object oriented data base management software - Hibernate ORM π₯; PostgreSQL π₯
-
Office suite software -
Microsoft Office software
- Operating system software - Bash π₯; Hewlett Packard HP-UX; Job control language JCL; KornShell; Linux π₯; Microsoft Windows Server π₯; Oracle Solaris; Red Hat Enterprise Linux; Shell script π₯; Ubuntu; UNIX π₯; UNIX Shell π₯
- Portal server software - Apache HTTP Server
-
Presentation software -
Google Slides; Microsoft PowerPoint
- Process mapping and design software - Microsoft Visio π₯
- Program testing software - Hewlett Packard LoadRunner
- Project management software - Atlassian Confluence π₯; Microsoft Project π₯; Oracle Primavera Enterprise Project Portfolio Management π₯
- Requirements analysis and system architecture software - Unified modeling language UML
- Sales and marketing software - Google Ads; Marketo Marketing Automation π₯
-
Spreadsheet software -
Microsoft Excel
- Transaction security and virus protection software - McAfee; NortonLifeLock cybersecurity software
- Transaction server software - Customer information control system CICS
- Video creation and editing software - YouTube
- Web page creation and editing software - Adobe Dreamweaver; Facebook π₯; Google Sites
- Web platform development software - AJAX π₯; Apache Struts; Apache Tomcat π₯; Django π₯; Drupal π₯; Dynamic hypertext markup language DHTML; Enterprise JavaBeans; Ext JS; Extensible hypertext markup language XHTML; Hypertext markup language HTML π₯; JavaScript π₯; JavaScript Object Notation JSON π₯; Microsoft Active Server Pages ASP π₯; Microsoft ASP.NET π₯; Oracle JavaServer Pages JSP π₯; PHP π₯; Ruby on Rails π₯
- Word processing software - Google Docs π₯; Microsoft Word π₯
Occupational Requirements
Work Activities
- Getting Information - Observing, receiving, and otherwise obtaining information from all relevant sources.
- Monitoring Processes, Materials, or Surroundings - Monitoring and reviewing information from materials, events, or the environment, to detect or assess problems.
- Identifying Objects, Actions, and Events - Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
- Inspecting Equipment, Structures, or Materials - Inspecting equipment, structures, or materials to identify the cause of errors or other problems or defects.
- Estimating the Quantifiable Characteristics of Products, Events, or Information - Estimating sizes, distances, and quantities; or determining time, costs, resources, or materials needed to perform a work activity.
- Judging the Qualities of Objects, Services, or People - Assessing the value, importance, or quality of things or people.
- Processing Information - Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
- Evaluating Information to Determine Compliance with Standards - Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.
- Analyzing Data or Information - Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
- Making Decisions and Solving Problems - Analyzing information and evaluating results to choose the best solution and solve problems.
- Thinking Creatively - Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
- Updating and Using Relevant Knowledge - Keeping up-to-date technically and applying new knowledge to your job.
- Developing Objectives and Strategies - Establishing long-range objectives and specifying the strategies and actions to achieve them.
- Scheduling Work and Activities - Scheduling events, programs, and activities, as well as the work of others.
- Organizing, Planning, and Prioritizing Work - Developing specific goals and plans to prioritize, organize, and accomplish your work.
- Performing General Physical Activities - Performing physical activities that require considerable use of your arms and legs and moving your whole body, such as climbing, lifting, balancing, walking, stooping, and handling materials.
- Handling and Moving Objects - Using hands and arms in handling, installing, positioning, and moving materials, and manipulating things.
- Controlling Machines and Processes - Using either control mechanisms or direct physical activity to operate machines or processes (not including computers or vehicles).
- Operating Vehicles, Mechanized Devices, or Equipment - Running, maneuvering, navigating, or driving vehicles or mechanized equipment, such as forklifts, passenger vehicles, aircraft, or watercraft.
- Working with Computers - Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
- Drafting, Laying Out, and Specifying Technical Devices, Parts, and Equipment - Providing documentation, detailed instructions, drawings, or specifications to tell others about how devices, parts, equipment, or structures are to be fabricated, constructed, assembled, modified, maintained, or used.
- Repairing and Maintaining Mechanical Equipment - Servicing, repairing, adjusting, and testing machines, devices, moving parts, and equipment that operate primarily on the basis of mechanical (not electronic) principles.
- Repairing and Maintaining Electronic Equipment - Servicing, repairing, calibrating, regulating, fine-tuning, or testing machines, devices, and equipment that operate primarily on the basis of electrical or electronic (not mechanical) principles.
- Documenting/Recording Information - Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form.
- Interpreting the Meaning of Information for Others - Translating or explaining what information means and how it can be used.
- Communicating with Supervisors, Peers, or Subordinates - Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
- Communicating with People Outside the Organization - Communicating with people outside the organization, representing the organization to customers, the public, government, and other external sources. This information can be exchanged in person, in writing, or by telephone or e-mail.
- Establishing and Maintaining Interpersonal Relationships - Developing constructive and cooperative working relationships with others, and maintaining them over time.
- Assisting and Caring for Others - Providing personal assistance, medical attention, emotional support, or other personal care to others such as coworkers, customers, or patients.
- Selling or Influencing Others - Convincing others to buy merchandise/goods or to otherwise change their minds or actions.
- Resolving Conflicts and Negotiating with Others - Handling complaints, settling disputes, and resolving grievances and conflicts, or otherwise negotiating with others.
- Performing for or Working Directly with the Public - Performing for people or dealing directly with the public. This includes serving customers in restaurants and stores, and receiving clients or guests.
- Coordinating the Work and Activities of Others - Getting members of a group to work together to accomplish tasks.
- Developing and Building Teams - Encouraging and building mutual trust, respect, and cooperation among team members.
- Training and Teaching Others - Identifying the educational needs of others, developing formal educational or training programs or classes, and teaching or instructing others.
- Guiding, Directing, and Motivating Subordinates - Providing guidance and direction to subordinates, including setting performance standards and monitoring performance.
- Coaching and Developing Others - Identifying the developmental needs of others and coaching, mentoring, or otherwise helping others to improve their knowledge or skills.
- Providing Consultation and Advice to Others - Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.
- Performing Administrative Activities - Performing day-to-day administrative tasks such as maintaining information files and processing paperwork.
- Staffing Organizational Units - Recruiting, interviewing, selecting, hiring, and promoting employees in an organization.
- Monitoring and Controlling Resources - Monitoring and controlling resources and overseeing the spending of money.
Detailed Work Activities
- Prepare analytical reports.
- Analyze market or customer related data.
- Develop models of information or communications systems.
- Create databases to store electronic data.
- Develop information communication procedures.
- Update computer database information.
- Report information to managers or other personnel.
- Provide technical support for software maintenance or use.
- Update knowledge about emerging industry or technology trends.
- Document technical specifications or requirements.
- Collect data about customer needs.
- Document operational procedures.