Business Intelligence Business Analyst Job Description
Business intelligence business analyst
provides technical expertise in Business Intelligence (BI) and Data Warehouse (DWH) projects, system integration and software development work.
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:
Create both a short term (6-12 months) and medium term (12- 24 month) Analytics Plan, plus longer-term (3+ years) roadmap
Participate in projects related to business intelligence, analytics and reporting specific to US Retail distribution
Be involved with the digital transformation of the bank – in particular working with IT to ensure that CAF establish database structures that are future proofed supporting our needs for analytics
Design and implement combined Spotfire and R-based dashboards with an informative yet intuitive combination of analytics to allow end user to extract necessary information and identify critical business issues quickly
Maintain and update developed analytics with business-side requests, provide suggestions on metric improvements and additions
Translate recommendations into action plans in collaboration with senior management, marketing, engineering / development, finance, and others
Performqualitative and quantitative market research using third-party syndicatemeasurements, , comScore, Nielsen, eMarketer
Synthesize data
Perform analyses and produce meaningful insights and recommendations to improve player acquisition, retention and monetization
Design and maintain dashboards that capture the metrics needed to monitor the game performance
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:
Analytics
Ability to utilize Business Intelligence tools and best practices
Accounting
BI and Data Warehouse environments and best practices
BI and data warehouse concepts and terminology
Business Analysis techniques and methodologies
Business systems and customer base
Computer applications
Data management
Experience in developing test data
Desired experience for business intelligence business analyst includes:
Very strong SAS coding and SQL skills are critical
Provide insight on the impacts of data requests (new/change/deletion ) from an end-to-end process prospective and also a systems and data integrity perspective
A BA/BS in a business or technical field
4 year degree or above in Computer Science or other Information Technology related degree
SQL Server SSIS and SSRS preferred
SAP Business Objects and/or dashboard building experience preferred
Business Intelligence Business Analyst Examples
1
Business Intelligence Business Analyst Job Description
Job Description Example
Our growing company is hiring for a business intelligence business analyst. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for business intelligence business analyst
- 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
Qualifications for business intelligence business analyst
- 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
2
Business Intelligence Business Analyst Job Description
Job Description Example
Our company is looking for a business intelligence business analyst. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for business intelligence business analyst
- 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
Qualifications for business intelligence business analyst
- 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
3
Business Intelligence Business Analyst Job Description
Job Description Example
Our growing company is looking for a business intelligence business analyst. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for business intelligence business analyst
- 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
Qualifications for business intelligence business analyst
- 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
4
Business Intelligence Business Analyst Job Description
Job Description Example
Our company is growing rapidly and is looking for a business intelligence business analyst. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for business intelligence business analyst
- 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
Qualifications for business intelligence business analyst
- 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
5
Business Intelligence Business Analyst Job Description
Job Description Example
Our company is looking for a business intelligence business analyst. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for business intelligence business analyst
- 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
Qualifications for business intelligence business analyst
- 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