BI Business Analyst Job Description
BI Business Analyst Duties & Responsibilities
To write an effective BI business analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included BI business analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
BI Business Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for BI Business Analyst
List any licenses or certifications required by the position: BI, ITIL, PMP, IIBA, BW, SAP, BA, CBAP
Education for BI Business Analyst
Typically a job would require a certain level of education.
Employers hiring for the BI business analyst 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, Education, Information Systems, Engineering, Statistics, Finance, Technical, Economics, Information Technology
Skills for BI Business Analyst
Desired skills for BI business analyst include:
Desired experience for BI business analyst includes:
BI Business Analyst Examples
BI Business Analyst Job Description
- Communicate using a variety of methods such as text, diagrams, prototypes, use cases, or user stories
- Facilitate requirement elicitation sessions including product backlog grooming
- Prioritize the requirements and backlog according to business value
- Negotiate and resolve requirement conflicts
- Work with the Product Owner to represent the customer to the team and answer questions
- Provide estimates for requirements and analysis activities as required
- Perform or assist with user acceptance testing
- Improve project processes or recommend improvements as appropriate
- Serves as a technology thought leader for assigned business functions and advise business partners accordingly
- Develop a strong understanding of business processes in Supply Chain and Demand & Supply areas and gain working knowledge of applications supporting those processes
- Minimum 3 years solid experience as a Business Analyst within Banking and Finance
- Experience in Technology Deployments across a large organisation
- Minimum of three years with working knowledge of SharePoint Technologies
- Ability to design applications from business requirements
- Ability to transform business requirements into functional and then technical requirements
- Experience using SQL Reporting Services (SRS) to create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources
BI Business Analyst Job Description
- Design and create efficient solutions using various BI tools
- Interact with finance headquarters and field locations on system enhancements utilizing new tools & approaches
- Manage work request queue in accordance with team Project Management Office (PMO) policies
- Evaluate, propose and implement new business software tools
- Lead continuing education seminars/classes on areas of technical expertise
- Responsible for web application design and implementation to support core business financial systems
- Assist in the requirements definition, implementation, and adoption of business intelligence tools and analysis
- Integrate disparate business data from multiple data sources into the construction of finance specific data mart/warehouse reporting solutions
- Provide leadership in building out business intelligence analytics best practices across the organization
- Disseminate information, including training, in relationship to tools, and reports
- Proven ability to navigate several projects with different solution teams at once
- 12-15 years working in Information Technology with a thorough understanding of SDLC methodology
- 8-10 years of direct experience in SAP Business Intelligence environment with SAP ECC, APO as transactional sources
- Solid understanding of Data Warehouse methodology, dimensional modeling including Ralph Kimball’s methodology
- Highly Proficient in documenting use cases, requirements and functional specifications
- Ability to quickly translate requirements to prototype and get business buy-in
BI Business Analyst Job Description
- Provide technical support for administering and using Tableau Server and MS PowerBI Gateway
- Create business reports, dashboards and ad-hoc queries within the business reporting environment for review of executives, managers, and other stakeholders
- Provide technical support for existing reports, dashboards, and other tools
- Champion the potential and use of Business Intelligence tools and methods across the organization
- Translate business requirements to system/functional requirements
- User requirements to ensure designed/developed solution meets the needs of the business sponsors
- Provide subject matter, process and technical leadership to the HR user community and BI support team
- Co-ordinate efforts within IT and HR organization to ensure service expectations and objectives are met
- Ensure adequate testing is completed during QA and UAT
- Assist activities to create and conduct training of new BI functionality
- The ability to engage and build strong relationships with clients and senior stakeholders
- Experience with software development of web-based systems
- Agile and BI knowledge HIGHLY preferred
- 7-10 years of work experience in SQL and Business Intelligence Development
- Strong knowledge of business analyst methodology and best practices
- MS SQL Server, MS Visual Studio, SSIS, MS Access/Excel VBA, MS SharePoint, JavaScript
BI Business Analyst Job Description
- Establish successful working and support relationships with cross-functional leaders and staff third party vendors
- Develops understanding of customers' needs and applies it in researching potential solutions
- Participates in preparation of the Business Case, Project Charter, Project Cost Justification, RFI, RFP, Package Selection Recommendation and other project initiation documents
- Work independently with users to define concepts and processes and under direction of project managers
- Analyze user requirements and, based on findings, design BI front-end applications
- Develop reports, graphs, charts and various visualizations using BI tools
- Design, code, test, and document new or modified BI systems, applications, and programs
- Develop the semantic layer, metadata, and report definitions
- Assist in the design of databases and data warehouses
- Participate in the tracking and resolution of data quality issues
- Ability to deal with a large number of stakeholders and strong ability to influence
- Understanding of project management methodologies and frameworks
- Workshop facilitation and execution skills
- Solid functional Business Analysis skills such as gathering requirements, running workshops and stakeholder management
- Robotic Process Automation tools such as Blue Prism/Kapow
- Project management software/tools such as Microsoft Project, Clarizen
BI Business Analyst Job Description
- Work with reporting SBA, ERP solution architects, functional BI solution architects during design & testing phases to ensure that the right challenges and alignment are in place for a smooth delivery on time and on budget
- Management of the interface with vendors to ensure the right resourcing, technical design and delivery is in place with frequent reviews to ensure fit within the global solution architecture/ model
- Accountable for the design standards of the technology being managed (ETL [BODS, Data Stage ] & Meta Data [HANA, DB2 ])
- Work with internal technical Enterprise Architecture team to define the roadmap of the technology including upgrades, harmonization and manage End of Life actions for technologies as required
- Develops time lines, assigns responsibilities, and monitors and summarizes the progress of projects
- Creates and implements communication and/or education plans
- Delivers project results within constraints of budget and resources
- May lead and direct the work of a project team
- Must be able to design data models and entity relationship diagrams (ERDs)
- Able to design and create ETL packages using SSIS or equivalent
- Experience in executing impact assessment activities and remediation execution across a wide range of technology platforms
- Understanding of key finance & accounting concepts including Generally Accepted Accounting Principles (GAAP)
- Knowledge of QuickBase, Monarch a plus
- 3-5 years of professional experience in either a technical (I/T) department or as a liaison between I/T and Finance
- Extensive analytical experience or equivalent business intelligence experience in support of the finance or accounting function
- Minimum 5-7 years of hands on experience as a business analyst on CRM applications