Business Intelligence Consultant Job Description
Business intelligence consultant
provides first rate analytic support via hands-on Excel work while leveraging other tools as necessary (SQL, SFDC, Google Analytics, Marketing Automation).
Business Intelligence Consultant Duties & Responsibilities
To write an effective business intelligence consultant job description, begin by listing detailed duties, responsibilities and expectations. We have included business intelligence consultant job description templates that you can modify and use.
Sample responsibilities for this position include:
Writes SQL queries required to create data sets required for BI solutions
Basic skills using SQL, ETL and databases in a business environment with large-scale, complex datasets would be an advantage
Participate in architecture and design of Cognos solutions
Primary contributor in the development and architecting of Cognos reporting solutions
Expert problem-solving skills to rapidly create ad-hoc queries to answer complex business questions or identify data issues
Designs, develops and implements complex Extract Transform Load (ETL) processes
Develops semantic layer, including business logic, in specialized BI tools like SSAS
Builds visualizations, including scorecards, reports, and dashboards with BI tools
Identifies current state business process or system inadequacies through analysis
Helps redesign and rebuild existing BI solutions so they are robust and repeatable
Business Intelligence Consultant Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Business Intelligence Consultant
List any licenses or certifications required by the position: BI, ITIL, SAS, PMP, LOMA, UML, SCRUM, AGILE
Education for Business Intelligence Consultant
Typically a job would require a certain level of education.
Employers hiring for the business intelligence consultant job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Business, Statistics, Engineering, Mathematics, Finance, Intelligence, Marketing, Math, MBA
Skills for Business Intelligence Consultant
Desired skills for business intelligence consultant include:
Unix
Verizon Wireline
Excel/Google Sheets
Marketing database architecture and marketing data
PowerPoint
Wireless customer products and services
Cognos
SQL
Data warehousing concepts
Scripting for automation
Desired experience for business intelligence consultant includes:
BBA/BA/BS in Management Information Systems, Computer Information Systems or Information Technology preferred
5 years’ experience in Financial Services, Consumer Retail, or Consumer Products Industries
BW implementation exeperience
Knowledge of BPC and Business objects
Good understanding of SAP ERP environments
Good knowledge of ABAP
Business Intelligence Consultant Examples
1
Business Intelligence Consultant Job Description
Job Description Example
Our company is looking for a business intelligence consultant. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for business intelligence consultant
- Proficient with MS~Office Software (Word, Excel, PowerPoint, Outlook)
- Competent ability to create queries in SQL or other query languages/systems
- Helps improve and streamline processes to improve data accuracy, viability, and value
- Helps migrate existing solutions from QlikView desktop to future BI platform
- Gather and prepare data to support analytics from a variety of data source types including databases, flat files, external sources, as necessary
- Produce written recommendations and insights for key stakeholders that will help shape effective Supply Chain strategies worldwide
- Review business requirements and write technical report specifications
- Validate data results with business analysts, developers, quality assurance engineers and/or customers
- Define, document, and implement an end-to-end BI methodology for a successful delivery process, and ensure adoption
- Design/implement Databases, Data warehouses and BI solutions around high volume enterprise applications
Qualifications for business intelligence consultant
- Demonstrable ownership and follow-through for accountable work products
- Strong knowledge of BW IP
- Strong knowledge of ETL
- Excellent communication skills, work ethic and the ability to work well individually in a global virtual team environment
- Data extraction, transformation and load tools
- Maintain an unambiguous data dictionary with data quality measures and actively monitor data against these measures
2
Business Intelligence Consultant Job Description
Job Description Example
Our company is hiring for a business intelligence consultant. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for business intelligence consultant
- Develop data management strategies to help clients assess and exploit the opportunities available from both internal and external data
- Assess the client’s existing capabilities, identify desired to-be state and develop roadmaps to both deliver rapid business performance improvement, and to sustainably enhance clients data & analytics capabilities
- Advise clients how to set up, develop, run, and improve an effective data management organisation both in-house and as a managed service
- Architect, design and deliver innovative ‘on premise’ and ‘cloud based’ data management & integration solutions, taking into account industry best practices and regulatory frameworks
- Support clients in their choice of technologies, applications and platforms to address their data needs, incl
- Provide mentorship and guidance to colleagues within Analytics internally and on projects
- Participate in the development of strategies, operating models
- Provide ongoing direction, recommendations and manage implementation of the evolution of all current and future analysis
- Report performance on weekly / monthly / quarterly basis to both Marketing and Sales
- Ability to create, execute and manage project management plans for small/medium and corporate accounts with little to no supervision
Qualifications for business intelligence consultant
- Experience developing Business Intelligence Strategy and setting the foundation
- Ability to interact with high level stakeholders
- Bachelor’s degree and 4+ years of Data Warehouse/Business Intelligence, Technical Business Analysis work experience required
- Expert-level proficiency with analytics development using common tools (e.g., Tableau, QlikView, Excel/PowerPivot, Spotfire, Microstrategy)
- Minimum ten (10) years of relevant work experience performing report and analytic development in a corporate data environment or data warehouse structure
- Minimum four (4) years of consulting, Project Management and/or supervisory experience
3
Business Intelligence Consultant Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of business intelligence consultant. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for business intelligence consultant
- Effectively train our business partners from the Senior Management level down in order to achieve successful execution of the client BI strategy
- Fundamental support in helping clients establish and manager their change
- Identify risks to the client achieving their stated business goals and ability to develop a risk mitigation plan
- Serve as a client advocate in driving industry best practices and the evolution of the Business Intelligence and Performance Analytics, courses and administrative services integral to success
- Works with a diverse group of individuals with a common purpose, always thinking about tomorrow in what we deploy today
- Creates complex Reports using data from multiple sources
- Possesses working knowledge of FIS IBS Core systems such as IBS Customer Information, IBS Deposit System, IBS General Ledger, XAA or FIS IBS Loans Systems
- 3-5 years of experience writing reports in Web Intelligence Rich Client 3.1/4.1
- Recruiters can add bullets if needed)
- Demonstrates critical thinking, ability to problem solve, and is results oriented
Qualifications for business intelligence consultant
- Development and maintaining policies and procedures
- Demonstrated experience with ETL/Interface or data manipulation processes for Analytical projects
- Use of relational databases and end-user tools
- Demonstrated leadership experience in managing and prioritizing multiple business requests simultaneously, managing teams in the delivery of business solutions
- Proficient in Database design and modeling in a Datamart / Analytical project environment
- Minimum eight (8) years of experience in project management, business analysis or executive data reporting
4
Business Intelligence Consultant Job Description
Job Description Example
Our innovative and growing company is looking for a business intelligence consultant. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for business intelligence consultant
- Ability to work independently for project completion with little to no supervision
- Competent application of performance improvement principles
- Knowledge of health care trends and industry standards
- None May travel outside Illinois for conferences and occasional local travel
- Consult your partners in Marketing, Sales or Service to find the best analytic solution for their problem to increase efficiency and effectiveness of their function
- Drive the Business Analysis, collaborate with the data architects, apply prototyping and other agile methods to speed up time to value while ensuring sustainability of the solution and adoption in the business
- Share knowledge on globally available solutions with the business or Affiliates and enable them to close gaps with self-service BI while Collaborating and facilitating within the Self-service BI community
- Develop adoption strategies, drive actions and measure adoption lead and manage the organizational change where needed
- Lead functionally international reporting and analytic projects with involvement of near or offshore development teams hands-on support where needed
- Provide strategy and direction around digital trends and industry standards to peers and internal / external teams
Qualifications for business intelligence consultant
- Extensive experience with design and development of ETL or Interface software preferably within the NET/Visual Studio framework or SSIS
- Experience in Provider contracting, benefits, compensation, appraisals, coding or utilization management a plus
- Master's degree in information technology, business administration, health care administration, public health or related field
- Advanced knowledge of BI tools and Dashboard software (Tableau, Business Objects)
- Advanced Microsoft Excel skills required (macros, vlookups, pivot tables)
- Self-motivated with the demonstrated ability to work autonomously with a team
5
Business Intelligence Consultant Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of business intelligence consultant. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for business intelligence consultant
- Work with internal, client & 3rd party agencies to support the definition/clarification of business goals, online objectives & KPIs for the automotive retail network clients, their websites and associated programs
- Identify measurement strategies and metrics to measure online website and advertising performance
- Drive and support holistic performance marketing analysis, pulling and integrating on- and offline data, including behavioral, attitudinal, social, financial, transactional, competitive, call center and other data types
- Guide dashboard creation, organize and present data that supports key stakeholder goals and objectives
- May serve as a project lead or technical lead
- Contribute to practice development initiatives including culture building, internal community involvement, eminence, whitepapers
- Support Data Architect by contributing to DWH and MDM designs
- To assist sales & presales teams in their activities by providing demos / POCs / attending meetings
- Partner with customers on developing requirements for business-focused BI
- Work in a ‘hands-on’ capacity to devise and deliver Guidewire reporting solutions
Qualifications for business intelligence consultant
- Prior experience in professional services consulting or other client-facing role
- Must be eligible to obtain a US government security clearance
- Bachelor’s or higher level degree required
- A willingness to travel to client locations in the DC/VA/MD area
- Engineering background preferred, MBA a plus
- Familiarity with system costing from a project management, service approach AND engineering perspective