Business Analyst / Data Analyst Job Description
Business Analyst / Data Analyst Duties & Responsibilities
To write an effective business analyst / data analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included business analyst / data analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
Business Analyst / Data Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Business Analyst / Data Analyst
List any licenses or certifications required by the position: PMI, ITIL, CBAP, PMP, SQL, AWS, MS, SSL, MA, MBA
Education for Business Analyst / Data Analyst
Typically a job would require a certain level of education.
Employers hiring for the business analyst / data analyst job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Collage Degree in Business, Computer Science, Finance, Education, Statistics, Mathematics, Engineering, Technical, Economics, MBA
Skills for Business Analyst / Data Analyst
Desired skills for business analyst / data analyst include:
Desired experience for business analyst / data analyst includes:
Business Analyst / Data Analyst Examples
Business Analyst / Data Analyst Job Description
- Coordinate support activities with other Services and Operations teams including IT, Business Service Management and External Partners
 - Act as the first point of escalation for data & reporting related issues, provide analytical support handling complex support issues
 - Track issues with reports, including defects in object logic, schema logic, data quality problems and process errors
 - Determines measures, baselines, tolerances and normal variability for indicators
 - Utilize tools for monitoring quality of data and assists in development of corrective action plans when issues are discovered
 - Support creation of Data Warehouse and other analytical tools
 - Responsible for participating and contributing in cross functional projects
 - Analyze resource allocation in project time tracking system, maintaining 100% headcount accuracy, including forecasted resource ramp
 - Weekly reconciliation for team headcount data
 - Weekly reconciliation of project updates to project time tracking system for resources impacted
 
- Demonstrated quantitative/technical abilities with OLAP and query tools
 - Understanding of Investment Management Business, Mutual Funds, Managed Accounts, and/or Separate Accounts preferred
 - Validate data results and ensure accuracy of reported information engaging with data suppliers in IT and within the trade management lifecycle
 - A minimum of 3 years experience in data analytics and business analysis
 - Previous experience with client reference data
 - The ability to analyse a complex set of data and present the analysis in a comprehensive but succinct way
 
Business Analyst / Data Analyst Job Description
- Develop analysis and reporting tools to support leaders' accurate and timely assessment of productivity opportunities in the method that best supports the business
 - Define end to end processes (customer centric) for key functional capabilities
 - Plan and execute User Acceptance Testing for each release
 - Responsible for process definition and documentation for key customer use cases
 - Assist each of the Technical Account Managers in defining and documentation of specific
 - Customer stories
 - Documentation
 - Processes
 - Test cases
 - Provide as additional set of resources to help with testing customer specific use cases
 
- Proficiency in the use of Excel, Access and other business intelligence tools
 - Able to write and run queries
 - Self-starter, quick learner and able to work independently under general supervision
 - Influencing skills/ability
 - Receive guidance from senior managers and team leads on departmental issues
 - Strong understanding of SQL and relational database technology
 
Business Analyst / Data Analyst Job Description
- Design, analyze, and redesign query formulas to generate accurate reporting of key performance indicators
 - Generate automated reports by enhancing or re-engineering reporting for the appropriate audience
 - Data analysis, investigations, and trouble-shooting with supply chain participants
 - Work as part of a team to manage ETL processes for daily data extractions for sales reporting from supply chain participants
 - Mentor/provide guidance to team members as they resolve assigned cases
 - Have expert knowledge of SQL and stored procedures
 - Develop SQL and stored procedures to satisfy customer immediate needs
 - To do PDCA for overall company performance and goals
 - Coordinate all the departments and parties to improve the business process
 - Monitors operating expenses, identifies variances of plan, assist in preparation of budget, and forecast according to prescribed guidelines
 
- Minimum 1 year experience with Tableau
 - Minimum 3 -5 year experience with ETL, DBA
 - Bachelors of Science required in engineering, statistical sciences, or computer science required
 - Minimum of 2 years of health care experience required
 - A minimum of 2 year hands on experience with Microsoft SQL 2000 or 2005 and 1 year experience with use of data warehousing tools such as Cognos, Crystal Reports, Microsoft Access and design experience highly desirable
 - Efficient and deadline conscious
 
Business Analyst / Data Analyst Job Description
- Interpreting data, analyzing results using the appropriate data analysis tools and techniques and providing ongoing catalog of reports as assigned by the manager
 - Oversees or performs maintenance and development of databases for collecting data and reporting purposes
 - Maintain and extend system components once they are established in production
 - Knowledge of the UK retail market then this will be considered advantageous
 - Excellent oral and written communication skills including the ability to tailor content depending on audience coupled with ability to explain complexity with ease and fluidity
 - Ability to engage successfully with diverse groups including executives, managers and subject matter experts in order to successfully elicit requirements
 - Aptitude for solving unstructured problems
 - Able to assimilate data from various sources and to design, construct and execute complex analyses that support in solving business problems
 - Experience of facilitating workshops and chairing meetings
 - Able to work independently and deliver to timescales and plans
 
- Minimum 2 years of experience with relational databases (SQL Server, MySQL, ) and the development and optimization of Stored Procedures for efficient processing large volumes of data
 - Experience with database analysis and BI tools such as Access, QlikView or SQL reports
 - Technical expertise regarding data models, database design development, data mining and data visualization techniques
 - Proven planning, leadership, teamwork and communication skills
 - Analytical self-starter who appreciates working independently part of a team
 - Eye for detail, accuracy and creativity
 
Business Analyst / Data Analyst Job Description
- Provide business and data analysis to determine trends, exceptions, proactive alerts, and make recommendations to the project team and business community
 - To be tenacious and gregarious
 - Build and provide routine reports such as auditor reports, customer reports and sales reports
 - Troubleshoot data issues, validate result sets, and recommend process improvements
 - Perform all duties and work projects as assigned by supervisor or analysts
 - Provide backup support within the team when requested
 - Drive the requirements gathering phases of projects to ensure that high quality requirements are developed in a timely fashion
 - Document business requirements, evaluate alternative solutions and recommend the best designs for the business
 - Model investment banking products and processes in functional design documentation
 - Build Traceability Matrix that assists in writing system and user acceptance test plans
 
- Advanced working knowledge of data mining using SQL, Excel
 - The candidate needs to have basic SQL skills, and medium-level Excel skills
 - Proficient in Adobe Analytics, Excel, SQL and Business Intelligence tools such as MS-SQL, Tableau and Kibana, usage of PM software, such as Trello or others
 - Familiarity with Process Engineering Processes
 - Familiar with outputs from DMAIC process studies
 - Demonstrated ability to translate business processes to applicable requirement types (functional, technical)