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)