BI BUSINESS ANALYST JOB DESCRIPTION

Reviewed BI Business Analyst job descriptions with standardized responsibilities, experience requirements, and salary ranges for enterprise reporting roles.

BI Business Analyst Job Description Template

1. About the Role

A BI Business Analyst translates what the business says it needs into what data systems can actually deliver. Not every organization can articulate that gap clearly. When requirements go undocumented or misaligned, reporting solutions get built around the wrong KPIs, process audits surface problems too late, and user adoption stalls after deployment. This role owns the full chain from elicitation through user acceptance testing, working with Operations Teams, Technical SMEs, and External Vendors to ensure solutions align with stated business objectives and support measurable process improvements.

2. Position Summary

As the BI Business Analyst, you convert stakeholder requirements into structured BI specifications, gap analyses, and acceptance criteria that BI developers and operations teams can execute against with confidence. You operate across business units including Finance, Procurement, and Supply Chain, coordinating with BI Managers, developers, and end users to validate data quality and drive adoption of reporting solutions.

3. Why Join Us

Career Impact: Consistent delivery of documented requirements and validated dashboards for cross-functional stakeholders builds the kind of domain authority that opens pathways to Senior BI Analyst and BI Manager roles.

Business Impact: When process gap analysis is done correctly, the organization avoids building reporting infrastructure around misaligned KPIs - this role directly determines the accuracy of the metrics leadership acts on.

Growth Opportunity: Exposure to Agile backlog management, dimensional modeling, and UAT coordination across multiple business units accelerates a candidate's readiness for architect-level or product owner responsibilities.

4. Key Responsibilities

  • Gather and document business, functional, reporting, and technical requirements using interviews, site visits, workshops, and process analysis to define clear solution scope.
  • Perform process and gap analysis across systems and workflows to identify compatibility risks, improvement opportunities, and requirements misalignment before development begins.
  • Develop artifacts including business requirements documents, functional specifications, process flow diagrams, and source-to-target mappings to communicate solution design to technical teams.
  • Coordinate user acceptance testing, manage feedback cycles with external vendors, and validate that delivered solutions meet defined acceptance criteria.
  • Monitor end-user adoption post-deployment and engage users directly to surface additional process improvement opportunities.
  • Facilitate requirements workshops and stakeholder sessions across Operations, Finance, Procurement, and Supply Chain to align business objectives with BI deliverables.
  • Review and audit business processes on an ongoing basis to identify risks, inefficiencies, and opportunities to re-engineer data collection or reporting workflows.

5. Required Qualifications

  • Bachelor's degree in Computer Science, Business Administration, Information Technology, or a related field, or equivalent work experience.
  • 3 or more years of Business Analyst experience in a BI environment, with demonstrated involvement in requirements elicitation, documentation, and acceptance testing.
  • Proven ability to perform gap analysis and process modeling, translating business problems into structured functional and technical requirements.
  • Experience coordinating user acceptance testing, managing vendor feedback loops, and tracking change requests through to resolution.
  • Solid understanding of dimensional modeling, data warehousing concepts, and ETL principles sufficient to evaluate feasibility of proposed BI solutions.
  • Strong written and verbal communication skills, with the ability to facilitate workshops and present findings to stakeholders at varying levels of technical fluency.
  • Demonstrated ability to manage competing priorities, meet deadlines, and adapt deliverables across agile and structured project environments.

6. Preferred Qualifications

  • Experience in a BI analyst role within financial services, retail, FMCG, or a regulated enterprise environment where reporting accuracy carries compliance implications.
  • Familiarity with OLAP structures, enterprise reporting platforms, or ERP systems such as SAP or Microsoft Dynamics in a requirements or validation capacity.
  • Exposure to agile methodology including SCRUM ceremonies, backlog management, and sprint-based delivery in a cross-functional BI team.
  • Business Analysis certification or ITIL qualification, or demonstrated equivalent through structured project documentation and process audit work.

7. Success Metrics and Environment

  • Requirements traceability coverage, measured as the percentage of delivered features mapped to a documented requirement.
  • UAT defect escape rate, reflecting how many post-go-live issues originated from gaps in the acceptance testing process.
  • Stakeholder sign-off cycle time, measuring days from requirements draft to formal approval across business units.
  • End-user adoption rate at 90 days post-deployment, tracked through login activity and self-service report usage data.
  • Change request resolution rate, capturing the proportion of vendor feedback items closed within the agreed SLA window.
  • Typical tools: BI and Reporting platforms (commonly Power BI or Tableau); project and documentation management (commonly Jira and Confluence).

8. Compensation and Benefits (US Market Benchmark)

  • Base Salary Range: $80,000 to $105,000 per year, depending on seniority and location.
  • Bonus: Annual performance bonus of 5 to 10 percent of base salary.
  • Equity: Uncommon at this level; offered at select technology-forward employers.
  • Health Benefits: Medical, dental, and vision coverage standard; employer contribution varies.
  • PTO: 15 to 20 days annually, plus federal holidays.
  • Common Perks: Remote or hybrid flexibility, professional development budget, and reimbursement for BA or BI certification.


Figures are estimates based on general US market benchmarks and may be outdated. Adjust based on location, company size, and seniority level.

9. EEO and Legal

Work authorization in the United States is required for all applicants. All qualified candidates will be considered without regard to race, color, religion, sex, national origin, disability, age, sexual orientation, gender identity, or any other characteristic protected under applicable federal, state, or local law. Reasonable accommodations are available to individuals with disabilities throughout the hiring process upon request. Final offers are contingent on the successful completion of a background check consistent with role requirements and applicable law.

BI Business Analyst Job Description Example

1. BI Business Analyst (Business Process Intelligence)

The BI Business Analyst owns end-to-end requirements gathering and process gap analysis, using interviews, site visits, surveys, and workshops to align solutions with business objectives. Working with Stakeholders, Operations Teams, Technical SMEs, and External Vendors, this role enables measurable improvements in productivity, cost reduction, and customer service.


Key Responsibilities

  • Develop sustainable, repeatable and quantifiable business process improvements.
  • Gather, analyze, and document business, functional, reporting and technical requirements using techniques such as interviews, site visits, surveys, document analysis, workshops, and process analysis.
  • Work with Business Stakeholders, Operations Teams, Technical SMEs, External Vendors and Leadership to ensure that the solution provided align with the business requirements and business objectives.
  • Perform process and gap analysis to ensure compatibility and interoperability of processes and systems.
  • Support the user acceptance testing and facilitate the feedback to External Vendor as part of the iterative solution development process.
  • Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems, and other post-implementation support.
  • Perform continued evaluations of end user adoption and work with end users to identify opportunities for business process improvements.


Required Qualifications

  • A Bachelor's degree in Computer Science, Business Administration or completion of a Post-secondary Diploma in Computer Science.
  • A minimum of 2 years related work experience in systems analyst, business analyst, design, application development and/or technical
  • Proven ability to lead a business team through a process and systems change.
  • Experience supporting the business in the creation and change of business data, including creation of metrics highlighting completion and quality of data in business processes.
  • Excellent knowledge of Power BI, including automation of reporting using specialist tools.
  • Must be extremely proficient in Excel.

2. BI Business Analyst (BI Requirements and Reporting)

Embedded within a Business Intelligence function, the BI Business Analyst analyzes the business environment across past, present, and future states to document KPIs, data flows, and interface layouts that meet relevant business objectives. Working closely with the BI Manager and BI Developers, this role shapes solutions within available tool constraints and supports end-users through facilitated sessions and training input.


Core Functions

  • Analyze the business environment related to the past, present and future.
  • Investigate and define requirements for business processes and the documentation thereof.
  • Formulate strategies and guidelines to improve the business environment.
  • Analyze existing business processes to determine problems, risks and opportunities for improvement.
  • Facilitate the implementation of new and enhanced processes, review processes on an ongoing basis, and conduct process audits.
  • Work closely with the business, BI Manager and BI Developers to design and implement the best possible solution within the limits of the tools available.
  • Conduct system and user acceptance testing and provide input to Quality Assurance.
  • Render support to and facilitate sessions with end-users, and provide input for user training.


Qualifications and Experience

  • Minimum of B degree or equivalent in Computer Science, Informatics, or IT.
  • Business Analysis diploma required, BI Business analysis qualification advantageous, and ITIL qualification advantageous.
  • 5 years Business Analyst and Requirement Analysis experience in a BI environment.
  • Solid experience in elicitation, documentation, testing and project management.
  • Good general understanding of the relevant industry and a solid understanding of business processes.
  • Experience with OLAP and Enterprise Reporting tools/systems like Tableau and Power BI, along with proven experience in agile methodology (SCRUM).
  • Well-developed analytical and problem-solving skills with strong coordination and planning skills.

3. Sr. BI Business Analyst (Enterprise Dashboard and Data Quality)

Reporting to IT and Business tool leadership, the Sr. BI Business Analyst delivers enterprise dashboard solutions and Power BI adoption programs through coaching, training, and data quality monitoring. Partnering with stakeholders, business users, and Application Teams, this role advances data visualization best practices and ensures delivered products meet project charter success criteria.


Primary Duties

  • Enable business partners to leverage Business Intelligence tools for their analytical needs and design and build enterprise dashboard solutions.
  • Support Power BI adoption through coaching and training to help clients select the best tool for the job while aligning with IT and Business tool standards.
  • Develop and monitor data quality metrics and ensure business data and reporting needs are met.
  • Provide consultative leadership to business partners at all levels of the organization.
  • Partner with stakeholders, business users and Application Teams to analyze, identify, prioritize and document business requirements, context diagrams, process modeling, use cases, user stories and storyboards using appropriate data visualization best practices.
  • Perform, evaluate, and communicate thorough quality assurance at every stage of system development.
  • Develop user test cases that map to functional requirements and lead and evaluate the success of user acceptance testing.
  • Ensure the delivered product materially meets the success criteria as stated in the project charter and work with the business to evaluate impacts and determine resolution paths where gaps exist.
  • Persuade internal and external stakeholders of the benefits of new technology or strategies.


Skills and Qualifications

  • Bachelor's degree in Computer Science or related field.
  • 5 or more years of proven experience in an analytics and systems development capacity.
  • 3 or more years of experience building and creating data models, dashboards and reports with Business Intelligence tools such as Power BI.
  • Strong technology and analytical skills related to Power BI, Data Modeling, Warehousing, SQL, and ETL Processing, with the ability to understand and work with complex data structures.
  • Familiarity with SAP, QAD or Solomon ERP landscape is a plus, and some experience with QlikView or Tableau is a plus.
  • Excellent oral and written communication, interpersonal and consultative skills with the ability to facilitate requirements gathering, process documentation, and translate data into actionable insights.
  • High proficiency with MS productivity toolset.

4. Senior BI Business Analyst (Financial Services BI)

Sitting at the intersection of business strategy and data intelligence, the Senior BI Business Analyst transforms management requests into structured requirements, prototypes, and homologation plans that promote efficiency across departments. Operating across Finance, IT, and cross-functional stakeholder groups, this role drives BI demand prioritization and ensures master data accuracy through process re-engineering recommendations.


Accountabilities

  • Assess the business case behind requests and the ROI for implementation, providing inputs into the prioritization process of all BI demands.
  • Drive collection of detailed requirements across departments to define, test, elicit and deliver technical and functional requirements to BI developers.
  • Create and implement precise management plans for every project focusing on risk monitoring and transparent communication at all levels.
  • Support the development process by interpreting and clarifying business requirements and processes while keeping target goals in focus.
  • Prepare final project documentation describing the main functionalities built and the logic used.
  • Assess current processes and systems and provide recommendations to re-engineer processes that improve efficiency of collecting and exploiting data, ensuring real-time correlation of master data and increased accuracy.
  • Ensure accurate knowledge sharing with team members and stakeholders around BI tools, data and reports.


Experience and Qualifications

  • Bachelor's or Master's degree in Finance, IT or Computer Science.
  • 3 to 5 years of experience in Business Analysis, preferably specialized in the Business Intelligence area.
  • Sound business knowledge and familiarity with concepts and processes in the financial services and investment industry.
  • Previous experience in the implementation of IT solutions and processes with transversal organizational impact.
  • Proficient in MS Office, with previous experience in Microsoft Power Platform (Power BI, Power Apps, Power Automate) considered a plus.
  • Experience working with complex databases, data models, data warehouses and reporting and dashboards is preferred.
  • Excellent communication and documentation skills with a team player attitude and pro-activity in day-to-day activities.

5. IT BI Business Analyst (Automotive Financial Sector)

A key member of the architecture and solution delivery network, the IT BI Business Analyst elicits and translates non-technical requirements into technical business requirements using interviews, workshops, surveys, and workflow analysis. Collaborating across senior management, business users, and external vendors, this role enables BI applications with long-term value by reconciling multi-source information and overseeing Change Request tracking.


Duties

  • Partner with stakeholders, process specialists, and users to elicit and document business requirements, and translate non-technical requirements into technical business requirements.
  • Elicit requirements using interviews, document analysis, workshops, surveys, site visits, use cases, and workflow analysis to define and document business requirements for new metrics and reports.
  • Use current knowledge of business and technology to recommend system solutions and process improvements.
  • Support prototyping by creating reports to validate business requirements, and assist users with the creation of requirements, platform access, service now tickets or ad hoc reports.
  • Partner with business users to plan, conduct, and get approval on user acceptance testing.
  • Critically evaluate information gathered from multiple sources, reconcile conflicts, and work with customers to uncover unmet business needs.
  • Interface directly with senior management where required and take a hands-on approach to project work with adaptability in style and activities.
  • Make synergy with architecture and solution delivery teams to enable BI applications that have long-term value.
  • Keep oversight and control of Change Requests impacting BI solutions to understand business requirements and track and update their status.


Technical Qualifications

  • Bachelor's degree in Administration, IT or related fields required.
  • 3 or more years of experience managing data, analytics and being involved in business IT projects.
  • Experience in the Automotive Financial sector is desirable.
  • Prior Business Intelligence or Decision Management System experience, including experience documenting use cases and process mapping.
  • Experience with Cognos Report Studio or other end-user reporting tools, and experience with DevOps or other requirements management tools.
  • Knowledge of system requirements definition processes and modeling methods and tools.
  • Outstanding written and verbal communication skills with proven ability to quickly learn new applications, processes, and procedures.
  • Fluent in English, Portuguese is a plus.
  • Availability to travel internationally for business purposes.

6. BI Business Analyst (FMCG Big Data)

Precise capture of business problems and solution feasibility assessment depend on the BI Business Analyst, who translates functional and non-functional requirements into documented process models, specifications, diagrams, and charts across the full project lifecycle. Based within a cross-functional team serving FMCG operations, this role guides vendor interactions and ensures business requirements and use cases are fully addressed by software suppliers and developers.


Job Functions

  • Precisely capture business problems, value drivers, and functional and non-functional requirements, including usability, data, reporting and supportability considerations.
  • Translate business requirements into functionality and assess the risks, feasibility, opportunities, and business impacts of various solution options.
  • Create clear documentation with process models, specifications, diagrams, and charts to communicate requirements and proposals, and keep them updated to align with the solution over the project lifecycle.
  • Interact with software suppliers, designers and developers to understand software limitations and ensure that business requirements and use cases are handled.
  • Understand and stay abreast of relevant architectures and technologies related to specific business areas, research potential solutions and innovative ideas, and guide and manage interactions with technology vendors.


Position Requirements

  • B.S. or M.S. in Operations Research, Computer Science, Statistics, Business Analytics, Econometrics, or Mathematics.
  • Overall experience of 5 or more years preferred, with BI and Big Data project experience within the FMCG industry highly preferred.
  • Strong understanding of system engineering, process analysis and modeling, and experience analyzing the alignment between business requirements and system capabilities.
  • Excellent verbal and written communication and interpersonal skills with the ability to effectively communicate with both business and technical teams.
  • Proficient with Microsoft Office with the ability to communicate in clear diagrams and graphs.
  • Highly analytical, resourceful, team oriented, with the ability to work independently under time constraints and deal with ambiguity in a fast-paced environment.
  • Fluent in English, verbal and written.

7. Sr. BI Business Analyst (Finance and Supply Chain)

As the Sr. BI Business Analyst, this role gathers and translates requirements from Finance, Procurement, and Supply Chain teams into comprehensive functional and technical designs, coordinating with the ETO Shared Services Team for end-to-end solution delivery. The Finance and BI function relies on this work to validate central database integrity, automate manual reporting processes, and build scalable solutions using PowerBI and SQL.


Areas of Ownership

  • Gather requirements from the business, articulate business needs, translate them into comprehensive functional and technical design.
  • Coordinate with ETO Shared Services Team to deliver the solution.
  • Support Finance, Procurement and Supply Chain teams to capture requirements for business relevant metrics in AIG Data mart.
  • Validate data in the central database by identifying any gaps with original source data and investigating the root cause.
  • Work with divisional teams to understand the processes used to generate current reports and support IT to automate these processes.
  • Partner closely with technical and business teams to complete requirements gathering, testing and successful delivery.


Background and Experience

  • Minimum Bachelor's degree required.
  • Minimum 7 years of experience as a finance analyst or business analyst, with experience in Finance preferred.
  • Experience working with large datasets and completing data validations in a short period of time.
  • Experience with Finance reporting and CRM tools such as Salesforce and ERP tools such as SAP.
  • Experience with Business Intelligence and Analytics platforms, with PowerBI preferred, and solid grasp of relational SQL databases.
  • Experience with agile development methodologies and tools such as Jira and Atlassian suite.
  • Good communication and project management skills with a track record of building alignment and partnerships across an organization.

8. Power BI Business Analyst (MS Power Platform Reporting)

Power BI Business Analyst develops analytical reporting dashboards using MS Power Platform tools and leads automation of manual data mining and analysis processes across the organization. The work directly supports Data Warehouse configuration, business intelligence infrastructure growth, and stakeholder partnership programs that tie key metrics to measurable process improvements.


What You'll Do

  • Develop analytical reporting dashboards using MS Power Platform tools including PowerQueries and Power BI.
  • Help drive the analysis needed to support key metrics and non-value-added process reductions.
  • Promote and develop reporting tools using modern technology with end-users.
  • Support the implementation of business solutions by building relationships and partnerships with key stakeholders, identifying business needs, determining and carrying out necessary processes and practices, and monitoring progress and results.
  • Collaborate closely with applications and BI development teams in Data Warehouse configurations.
  • Automate and improve current manual processes for data mining and analysis throughout the company.
  • Participate as a key member in growing the company's business intelligence reporting infrastructure.
  • Perform special projects to improve process efficiency and performance.


Education and Experience

  • Bachelor's degree in Computer Sciences, Information Systems or a related field required.
  • 4 or more years of Business Analytics experience.
  • ERP experience required, with involvement in ERP or CRM implementations a plus.
  • Proficient data mining and analysis skills along with an understanding of ETL and ELT processes, and experience with MS Power Platform products including PowerPivot, Power BI, and SQL Databases.
  • Heavy proficiency in Power BI dashboard data modeling, working knowledge of Data Warehouse design, ETL integrations, SQL Coding and MS Azure SQL stack tools.
  • Strong data mining and data analysis skill sets with the ability to analyze and synthesize business requirements.
  • Ability to manage competing priorities with excellent organizational skills and the ability to thrive in a team environment.

9. BI Business Analyst (Data Visualization and Testing)

The BI Business Analyst owns reporting requirements documentation and end-to-end data test management, using SQL to investigate data sources and developing conceptual BI solution designs for financial services and retail environments. Working with internal and external stakeholders, this role delivers functional designs, user training, and stakeholder relationship management aligned with the latest data tools and methodologies.


Role Responsibilitie

  • Gather and document reporting requirements for the respective business areas.
  • Investigate data sources and query the data using SQL.
  • Document Functional Requirements to the source system and Source to Target mapping for new solutions.
  • Develop conceptual BI solution design, functional designs, and provide recommendations on the presentation of information.
  • Train and support users, create test cases and plans, and manage the data test process including unit, system integration, functional and user acceptance testing.
  • Manage effective internal and external stakeholder relationships and keep abreast of the latest market developments with regards to Data tools and methodologies.


Knowledge Skills and Abilities

  • 3-year Degree or Diploma in Information Technology or related fields - essential.
  • Data analysis experience with experience in financial services or retail advantageous.
  • Proficient in SQL for data analysis - essential.
  • Knowledge of Dimensional Modelling and Data Warehousing.
  • Experience in working with data visualization tools such as Cognos or Power BI for Proof of Concepts.
  • MS Office proficiency required.
  • Strong communication and facilitation skills with attention to detail and the ability to collaborate with developers and business users.

10. Data and BI Business Analyst (Finance and Real Assets)

Embedded within a cross-functional technology team, the Data and BI Business Analyst refines structured system analysis, effort estimations, and interface mappings while supporting Product Owners in breaking down and prioritizing the backlog. Working closely with development, test teams, and business departments across the finance and real assets industry, this role improves quality assurance and implements methodologies and best practices across the full development lifecycle.


Day-to-Day Responsibilities

  • Analyze and document business requirements, change requests and business processes.
  • Perform structured system analysis and effort estimations.
  • Support business departments in the definition of new IT requirements and change requests, and support Product Owners in structuring and breaking down the backlog.
  • Facilitate requirements workshops and elaborate detailed mappings for interfaces.
  • Improve quality assurance of solutions throughout the entire development process, define test approaches, and support system and user acceptance tests.
  • Define and implement methodologies and best practices, and engage in cross-department business analysis initiatives.
  • Support development and test teams during implementation.


Professional Experience

  • At least 5 years of experience working in a Business Analyst or similar role.
  • Experience in requirements engineering and translating these into technical requirements.
  • Experience with the Atlassian Suite especially Confluence and Jira, and experience in SQL and Database Management Tools.
  • Work experience in the finance and/or real assets industry.
  • Basic knowledge of Microsoft Azure with Office 365 and the Power Platform, Snowflake, BI Tools such as Power BI or Tableau, and any programming language is considered a plus.
  • Very good analytical thinking and conceptual skills with strong communication and diplomatic negotiation skills.
  • Fluent in English and German.

11. BI Business Analyst (Digital Wagering and Gaming)

Reporting to senior management and cross-functional leadership, the BI Business Analyst produces iterative technical solutions from business needs by conducting design thinking sessions, KPI development, and product backlog management in the digital wagering space. Collaborating across internal stakeholders, same-department teams, and external parties, this role builds and maintains a strong BI documentation repository and develops expertise in digital wagering data.


Operational Focus

  • Conduct design thinking sessions, market research, data analysis, business analysis, use case and KPI development with business stakeholders.
  • Work collaboratively with business partners to review requirements and architect appropriate solutions.
  • Establish effective working relationships with internal stakeholders, same department teams, senior management, and external parties.
  • Translate business needs into technical solutions with an iterative approach and manage the product backlog prioritization and release management.
  • Build and maintain a strong documentation repository for all BI related works.
  • Become an expert in digital wagering data and information.


Required Qualifications

  • 2 to 4 years of experience in a BSA role with strong background in Data BI and Visualization, Insights and Analytics, and Power BI.
  • Casino and/or Sportsbook industry experience is a strong plus.
  • Ability to use and model in Excel and SQL, with experience in reporting and visualization tools such as Power BI, Tableau, and SSRS a plus.
  • Experience in using project management and documentation tools such as JIRA and Confluence is a plus.
  • Demonstrated knowledge in business process diagramming tools and methods.
  • Excellent verbal and written communication skills with the ability to interact professionally with a diverse group including executives, managers, and subject matter experts.
  • The ability to think creatively and problem solve is critical.

12. BI Business Analyst (Power BI Client Consulting)

The BI Business Analyst develops meaningful Power BI reports end-to-end for clients, from initial requirements documentation through data modeling, DAX measures, and final publishing and maintenance. Working closely with clients across organizations, this role guides decision-making by transforming raw data into valuable information and defining the right process indicators to support business operations.


Key Deliverables

  • Understand client needs and guide them in the building of meaningful reports.
  • Explain to clients what is technically possible and what brings value to their decision and reporting process.
  • Go beyond the numbers to understand business processes and play a true consulting role.
  • Collect the right data, clean it, transform it, build a data model connecting various data sources, and create visuals and measures.
  • Support customers in the design and maintenance of reports using Power BI from initial requirements documentation through to publishing of final reports and ongoing maintenance.
  • Work autonomously and in a team while continuously self-learning new tools and methods.


Minimum Qualifications

  • Solid knowledge of Power BI including Power Query and DAX.
  • Willingness to deepen expertise further.
  • Excellent self-organization skills and analytical mindset.
  • Fluent in English and Dutch or French.
  • Able to be a real team player with positive vibes.

13. BI Business Analyst (Tableau and Data Pipeline)

Embedded within a global hi-tech BI team, the BI Business Analyst executes end-to-end BI project delivery with full accountability for scope, data quality, and usability, building Tableau reports and dashboards while partnering with data engineers on data models and pipeline processes. Working closely with data analysts across business areas including HR and Finance, this role supports self-service visualization best practices and maintains IT BI services within SLA.


Activities

  • Engage with business stakeholders to explore business processes, gather requirements, and design data products.
  • Work with data engineers to design data models and data pipeline processes.
  • Develop reports and dashboards using Tableau.
  • Manage end-to-end BI projects with full delivery accountability covering on-time and on-scope delivery, data quality and integrity, and usability.
  • Maintain and support IT BI-related issues within service level SLA.
  • Support data analysts from different business areas in data manipulation and visualization self-service best practices.


Experience and Qualifications

  • BA in Industrial Engineering or Economics.
  • 2 to 3 years of hands-on experience using Tableau or similar - required.
  • Advanced SQL skills using Snowflake or similar - required.
  • Experience in data modeling, ETL and data pipeline design, and analytic dashboard design.
  • Deep understanding of business processes including HR and Finance, and experience in BI in global hi-tech companies preferred.
  • Excellent interpersonal skills with a proven ability to collaborate with others in a global team.
  • Highly motivated and self-driven with the ability to manage multiple tasks.
  • English at a high standard.

14. BI Business Analyst (Financial Services and Regulatory Reporting)

Sitting at the intersection of financial services operations and Business Intelligence delivery, the BI Business Analyst creates user requirements for data warehouse, ETL, self-service reporting, and regulatory solutions while planning work using Agile methodology. Operating across stockbroking, compliance, and back-office teams, this role guides the business toward BI self-service and develops ad-hoc reports for complex requests that existing solutions cannot address.


Scope of Work

  • Analyze challenges, engage with stakeholders, and gain an understanding of the company's business applications and trading platforms.
  • Create user requirements for Business Intelligence solutions including data warehouse, ETL, self-service reporting, and back office statements and regulatory requirements.
  • Plan using Agile methodology, break requirements into stories and tasks, and provide estimates.
  • Contribute to BI Wiki documentation, run knowledge transfer sessions, and provide sprint showcases.
  • Develop ad-hoc reports for urgent and complex requests where existing solutions cannot be used.
  • Guide and advise the business towards BI self-service where appropriate to maximize efficiency while being mindful of associated risks and best practices.


Technical Qualifications

  • Experience in Financial Services of stockbroking, preferably within ISA, SIPPS, or Investment accounts.
  • Experience in Derivative and CFD products is desirable.
  • Experience in gathering requirements for reporting solutions including Accounting, Regulatory reporting, and Transaction Reporting such as MiFID and EMIR.
  • Hands-on SQL experience and understanding of data modeling, data warehouse and ETL principles.
  • Experience in MI reporting including Performance Management, Sales and KPIs is desirable.
  • Strong analytical and problem-solving skills with the ability to challenge convention and identify and propose improvements.

15. BI Business Analyst (Banking Data and DWH Reporting)

A key member of the banking reporting team, the BI Business Analyst analyzes and defines correlations across high-volume datasets, writes clear functional specifications, and produces user guides and test scenarios for allocated projects. Collaborating across inter and intra-department stakeholders, this role delivers SQL-driven insights and reporting tool outputs that support accurate banking product measurement and data modeling governance.


Performance Expectations

  • Analyze, understand, and define a high set of data and the existing correlations between data.
  • Analyze and evaluate business requirements and their impact on the reporting area.
  • Write clear and concise functional specifications for any allocated project.
  • Write and perform test scenarios for any allocated project.
  • Offer user support linked to developed functionalities and reports.
  • Write user guides and user information messages and documents.


Skills and Qualifications

  • Very good knowledge of specific banking products, banking domains and reporting banking area.
  • Proficient in conceptual and physical data modeling concepts and principles, and DWH knowledge concepts and methodology.
  • Technical skills in SQL, with experience in SAS Enterprise Guide as a plus.
  • Knowledge of reporting tools such as Tableau, Cognos, and QlikView.
  • Project management capabilities including task prioritization and project status and alert communication.
  • Strong analytical and problem-solving attitude with excellent communication skills and orientation towards inter and intra-department collaboration.

16. BI Business Analyst (Microsoft Dynamics Reporting)

As the BI Business Analyst, this role delivers reporting and analytic solutions built on Microsoft Dynamics AX and D365, overseeing day-to-day infrastructure operations, data governance, and project timelines and budgets from end to end. The reporting infrastructure team relies on this work to maintain SSRS, SSAS, and Power BI solutions and provide level-of-effort estimates that guide the vetting process for new initiatives.


Key Responsibilities

  • Deliver reporting and analytic solutions and provide knowledge of data and reporting infrastructure.
  • Manage data administration and governance, and design, test, document, and train reporting solutions.
  • Manage projects to ensure timelines.
  • Budgets are met, and provide level of effort estimates during the vetting process.
  • Oversee day-to-day operations, maintenance, and support of reporting infrastructure.


Qualifications and Experience

  • Bachelor's degree in Computer Science, MIS, Computer Engineering, or equivalent technical degree.
  • 2 to 5 years of experience with Microsoft Dynamics AX and D365.
  • Knowledge of Microsoft Dynamics reporting tools including SSRS, SSAS, and Power BI, and familiarity with all AX and D365 functional modules.
  • Experience with additional platforms such as Salesforce and Magento is desired, and working knowledge of SQL and integration platforms including Mulesoft is a plus.
  • Microsoft certifications preferred.
  • Ability to work independently, prioritize and solve problems proactively with the ability to work systematically and logically to analyze situations, resolve problems, identify root causes, and anticipate risks.
  • Clear and effective communication skills with a team player and customer-focused mindset.

17. BI Business Analyst (MVP Development and Agile Delivery)

The BI Business Analyst leads client needs documentation and MVP-based solution design, collecting and structuring customer change and development requests for timely delivery from requirements through to completion. Working with cross-functional business and technology stakeholders, this role coordinates Agile-mode delivery using Power BI, DAX, and SQL to implement simple and value-added solutions.


Core Responsibilities

  • Understand and document client business needs and analyze data to propose solutions.
  • Create versions of sketches to visualize the development using the concept of MVP (Minimum Viable Product).
  • Collect, analyze and structure customer change
  • Development requests and implement simple, value-added and timely solutions.
  • Coordinate the steps from requirements to delivery.


Background and Experience

  • Bachelor's degree in Computer Science, Information Systems, Marketing, Business Management, Business Analysis, Finance or related field.
  • Minimum of 2 years of experience as an IT Business Analyst, with 1 to 3 years of experience in a BI role including MS Power BI.
  • Experience with MS Power BI including DAX, Power BI Paginated Report, and Power BI Service Premium, along with experience in SQL and MDX as an asset.
  • Ability to understand customer needs, perform critical thinking, and conduct data analysis.
  • Functional level of English required.
  • Ability to adapt to changes, work in Agile mode, and collaborate effectively in a team environment.

18. BI Business Analyst (Investment and Insurance Reporting)

Embedded within a finance and investment reporting function, the BI Business Analyst advances analytic, regulatory, and operational dashboard delivery by translating reporting requirements into functional and technical solutions using Power BI, Tableau, Python, or R. Working closely with global reporting stakeholders and business units in insurance asset management, this role leads continuous improvement of reporting processes and provides end user training for global requirements.


Day-to-Day Responsibilities

  • Deliver analytic, regulatory, and operational reports and dashboards through BI.
  • Analyze reporting and analytic requirements to translate them into functional and technical solutions.
  • Support and lead the implementation of new initiatives and projects.
  • Drive continuous improvement of existing reporting processes and services.
  • Provide end user training for global reporting requirements.


Professional Experience

  • BSc or MSc in Finance or a STEM-related field.
  • 3 or more years of experience in business intelligence or relevant work in financial reporting.
  • Understanding of investment products, financial markets, and reporting processes, with experience working with SAP or other accounting systems.
  • Experience in insurance asset management including accounting and controlling is a plus.
  • Proven experience with databases and interfaces as well as analysis tools such as Power BI, Tableau, Python, or R.
  • Fluency in English and knowledge of other languages.

Editorial Process and Content Quality

This content is developed by the Lamwork Editorial Team using structured analysis of real-world job data, skill requirements, and hiring patterns.

Research framework by Lam Nguyen, Founder & Editorial Lead.

Reviewed by Thanh Huyen, Managing Editor.

Learn more about our editorial standards.