Business Intelligence Business Analyst Job Description
Business Intelligence Business Analyst Duties & Responsibilities
To write an effective business intelligence business analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included business intelligence business analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
Business Intelligence Business Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Business Intelligence Business Analyst
List any licenses or certifications required by the position: PMP, BI, SQL, CAPM, ITIL, MCSE, MCDBA, SAP, SQA, MCP
Education for Business Intelligence Business Analyst
Typically a job would require a certain level of education.
Employers hiring for the business intelligence 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, Finance, Statistics, Mathematics, Engineering, Information Systems, Technical, Education, Economics
Skills for Business Intelligence Business Analyst
Desired skills for business intelligence business analyst include:
Desired experience for business intelligence business analyst includes:
Business Intelligence Business Analyst Examples
Business Intelligence Business Analyst Job Description
- Perform high level data quality analysis on existing data sources and provide support in issuing a set of recommendations on how to solve these issues
- Identify business requirements for information that can be mapped to levels of data and systems of record
- Define visuals and mapping of KPIs to visualization type (graphs, charts, widgets, dashboards ) for BI presentation layer PoC (Proof of concept)
- Testing of BI presentation layer PoC
- Support in presenting the BI presentation layer solution to end users
- End User training requirements identification and training approach definition
- Provide daily reporting platform support (SSRS and Business Objects)
- Enforce standards and implement best practices and procedures
- Develop reporting solutions to fit business needs
- Monitor business intelligence tools, methods or systems for process and data validation
- Must have strong knowledge of MS Word, MS PowerPoint, MS Access, MS Excel
- Data integrations experience (SSIS / T-SQL)
- Proven ability to work with MS SQL Stack
- Fluency in English and an ability to communicate clearly at both business and technical levels
- Ability to analyse and define a problem, evaluate alternatives, find a solution, understand how and when to make a choice
- Ability to manage project documentation (technical and management) and data (or information) requirements
Business Intelligence Business Analyst Job Description
- Perform all other essential duties as needed
- Manage creation of targeted marketing lists for all sales tactics used by the small business team (direct mail, telemarketing, door to door )
- In collaboration with others, develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality
- Lead the Functional testing efforts and support users during User Acceptance Testing
- Support the business post live as required
- Develop graphs, reports, and presentations of Analysis results
- Perform advanced statistical analyses for projects and reports
- Working with business stakeholders to gather requirements and ensure result validity
- Gathering, understanding and critically evaluating information and reporting requirements from multiple sources to ensure alignment with the center’s strategic goals and to decompose high-level information into details
- Serving as the liaison between internal and external customers and subject matter experts (SMEs)/EDW team
- Experience with Hadoop and/or Tableau will be advantageous
- Experience using the Microstrategy or some reporting toolsets for solving business problems
- Must have a good understanding of Retail business with 2+ year experience
- Demonstrated ability to analyze complex business problems and provide BI solutions
- Must be a sincere, collaborative team member who, when needed, places the overall success of their organization and team ahead of their own professional priorities
- BA/BS with strong academic record, ideally in Economics, a quantitative social science, Mathematics, Statistics, Computer Science, Physics
Business Intelligence Business Analyst Job Description
- May lead the implementation of tactical plans in support of strategic initiatives
- Receives objectives and determines approach to achieving objectives
- Supports the formalization and establishment of CRM Business Processes
- Makes decisions but may not have final authority for all aspects of resource commitment
- Accountable for the achievement of operational goals
- Integrates customer/client needs and concerns with business issues
- Serves as an advocate for customer/business partner
- Serves as a liaison on specific projects with other work areas
- Create and maintain an expansion of metrics system from current functions to further developed views
- Prepare ad-hoc request reporting
- DW/ ETL background and experience
- Proficiency in MS Office, MSBI, SQL, VBA
- Ability to write moderate to complex SQL queries and the ability to tune SQL queries for performance
- At least 3 years experience in test strategy/plan definition, scenario, and script development
- Experience with SQL Databases, Tableau and/or other Reporting BI tools are required
- Functional Capability
Business Intelligence Business Analyst Job Description
- Present data to business users to help them make informed decisions
- Become experts in the areas of the business to be analyzed
- Translate business questions into reporting/analytical requirements
- Collaborate to define process changes where data needs to be captured
- Interface with user members of the business and IT to design data solutions
- Organize, consolidate, maintain, and work to prune and replace legacy reports
- Provide ongoing support of any reporting and analytic needs
- Standardize Business Intelligence solutions
- Monitor and modify the Business Intelligence systems in a Data Warehouse environment providing analytical solutions and administration
- Lead or significantly contribute in problem solving and root cause analysis activities
- Must be able to use advanced data access, business intelligence, visualization and extraction tools and methods, , SAS, SQL, SPSS, R, Tableau, Salesforce
- Understanding relational database design and administration
- Experience cleaning raw data, automating it so it can be used ongoing for reporting purposes
- Bachelor’s degree in IT, or related field with 1-3 years of experience in Business intelligence roles
- Proficiency in SQL required with knowledge of database concepts
- Experience in front-end Business Intelligence tools a plus
Business Intelligence Business Analyst Job Description
- Determines the most effective ways of retrieving data from multiple systems
- Utilizes SQL, Crystal Reports, and Qlik to pull and load accurate data and creates reports, and builds interactive visuals
- Reviews report requests, determine needs, communicate questions, provides suggestions, writes and executes programs to provide information to the Advancement team
- Conducts data clean-up projects, audits, and validity testing to ensure continued accuracy and completeness of data
- Provides process documentation, system training, and support to colleagues through- out Advancement
- Expert knowledge of Excel and other database management systems is necessary
- High level of expertise in Excel and/or Access
- Knowledge of Word, Visio, SQL
- Must be a flexible, team player
- Advanced knowledge of Business Intelligence software platforms, , Microstrategy is highly preferred
- Experience managing primary research projects, selecting & working with research agencies is desired
- Medical device or health care background is a plus