BUSINESS INTELLIGENCE CONSULTANT JOB DESCRIPTION

A Business Intelligence Consultant translates raw organizational data into decisions stakeholders can act on. Where a Data Analyst interprets existing outputs and a BI Developer builds pipelines, this consultant owns the full advisory chain: scoping what the business actually needs to measure, designing dimensional data models that support those measurements, and governing how dashboards reach the people who depend on them. Engagements routinely span SQL Server Analysis Services, ETL architecture, and executive-facing presentations within a single project. The role demands both the technical fluency to reverse-engineer a broken data model and the consulting presence to run a requirements workshop with a CFO.

As the Business Intelligence Consultant, you are accountable for designing, delivering, and governing end-to-end BI solutions that convert client data into measurable business outcomes across industries including manufacturing, financial services, and professional services. You operate within a project delivery structure, typically reporting to an Analytics Practice Lead or Engagement Manager, and hold direct accountability for solution quality, client satisfaction scores, and on-time delivery across concurrent engagements.

Career Impact: Owning end-to-end BI delivery from dimensional modeling through executive dashboard sign-off builds a credential set that commands premium rates in both consulting and in-house analytics leadership tracks.

Business Impact: The dashboards and governed data models this consultant delivers become the reporting foundation clients rely on for budgeting cycles, supply chain decisions, and C-suite performance reviews, making the work visible and consequential from day one.

Growth Opportunity: Consistent exposure to enterprise architecture reviews, ETL modernization projects, and cloud data warehouse migrations positions a strong performer for a Lead or Principal Consultant title within two to three years.

• Design dimensional data models, including fact and dimension table structures, to support scalable enterprise reporting.
• Elicit and document client reporting requirements through structured workshops with stakeholders ranging from operations managers to CFOs.
• Develop, test, and deploy interactive dashboards and paginated reports that surface KPIs aligned to agreed business outcomes.
• Architect and maintain ETL pipelines that integrate data from multiple source systems into a governed data warehouse or lakehouse environment.
• Lead governance and deployment planning for BI environments, including version control practices, change management procedures, and promotion across development, test, and production environments.
• Review and validate data accuracy across ingested datasets, coordinating with QA and data engineering teams to resolve integrity issues before delivery.
• Mentor junior analysts and reporting consultants on dashboard design standards, SQL best practices, and client communication norms.
• Support pre-sales activities by preparing and delivering solution demonstrations and contributing to scoping documentation for new engagements.

• Bachelor's degree in Computer Science, Information Technology, Engineering, Finance, or a related quantitative field, or equivalent work experience.
• 5 or more years of BI consulting or analytics delivery experience, with direct responsibility for client-facing solution design and deployment.
• Demonstrated proficiency in dimensional modeling concepts, including star schema design, surrogate keys, and data granularity decisions.
• Proven ability to write, optimize, and debug complex SQL queries across relational database platforms.
• Experience designing and delivering ETL processes that move and transform data between source systems and a centralized data warehouse or analytics layer.
• Strong requirement-elicitation skills with demonstrated experience translating ambiguous business problems into structured technical specifications.
• Track record of managing multiple concurrent project deliverables to agreed timelines, budgets, and scope boundaries.
• Excellent verbal and written communication skills, including the ability to present technical architecture decisions to non-technical executive audiences.

• Relevant vendor certification such as Microsoft PL-300, Tableau Desktop Specialist, or an equivalent credentialing program from a recognized analytics platform.
• Hands-on experience deploying or migrating BI workloads onto cloud data platforms such as Azure Synapse, Snowflake, Databricks, or AWS Redshift.
• Exposure to financial, supply chain, or pharmaceutical reporting domains, including familiarity with the KPIs and data structures specific to those verticals.
• Prior experience in a pre-sales or business development capacity, including solution scoping, effort estimation, and proposal contribution.

• Dashboard adoption rate, measured as the percentage of delivered reports actively used within 60 days of go-live.
• On-time delivery rate across concurrent client engagements, tracked against agreed project milestones.
• Data accuracy error rate per deployment cycle, reflecting quality of ETL logic and pre-release validation rigor.
• Client satisfaction score (CSAT) collected at project closure, measuring perceived value of solution and consultant communication.
• Requirement change orders per engagement, indicating precision of initial scoping sessions relative to contracted scope.
• Typical tools: BI platforms (commonly Power BI or Tableau); database platforms (commonly SQL Server, Snowflake, or PostgreSQL); ETL tooling (commonly SSIS or Azure Data Factory).

• Base Salary Range: $95,000 to $135,000 annually, depending on seniority and location
• Bonus: 8 to 15% annual performance bonus tied to utilization and client satisfaction
• Equity: Rare at consulting firms; equity or profit-sharing offered at select boutique practices
• Health Benefits: Medical, dental, and vision coverage; employer contribution rates vary by firm
• PTO: 15 to 20 days annually, plus standard federal holidays; some firms offer flexible PTO
• Common Perks: Certification reimbursement, travel expense coverage, remote or hybrid work options for non-client-site weeks

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

Background checks, including verification of employment history and education credentials, are a standard condition of hire for all positions. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability, veteran status, 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 application and employment process upon request. Candidates must be authorized to work in the United States without requiring employer-sponsored visa support.

The Business Intelligence Consultant owns the end-to-end design of scalable data models and governance frameworks for BI solutions, cleaning and integrating data from multiple sources to support advanced analytics. Working within cross-functional analytics delivery teams, the role shapes data warehouse architecture and builds rich dashboards and visualisations that make complex data accessible to stakeholders at all levels.

Key Responsibilities

• Design and build scalable data models to support advanced analytics capabilities.
• Clean, transform, and integrate data from multiple sources based on business requirements.
• Lead or contribute to large-scale end-to-end data analytics delivery projects.
• Shape governance and deployment approaches for data warehouse and BI solutions across organisations.
• Make large or complex data more accessible and understandable to users.
• Create charts, graphs, histograms, geographical maps, and other visual models to illustrate patterns in large data volumes.
• Build rich graphical dashboards and reports to deliver information in a useful and visually appealing format.

Required Qualifications

• Bachelor's degree in a relevant field, or a Master's degree, or equivalent experience totalling at least seven years.
• Microsoft Power BI Data Analyst certification (Exam DA-100 or Exam PL-300).
• Minimum five years of analytics experience with a Bachelor's degree, or minimum three years with a Master's degree.
• Strong experience as a BI developer using the Microsoft BI stack, particularly Power BI.
• Expert knowledge of DAX and Power Query.
• Strong understanding of dimensional modelling concepts, including facts versus dimensions, surrogate keys, and data granularity.
• Working experience with SQL, including writing and debugging queries.
• Strong experience delivering end-to-end BI solutions and driving data-led change within a business.
• Effective data storytelling skills with the ability to communicate findings to a wide audience.
• Excellent communication and presentation skills with confidence engaging stakeholders at all levels.
• Ability to establish and maintain collaborative relationships with stakeholders and senior leads.

Embedded within a client-facing consulting practice, the Business Intelligence Consultant delivers BI and CPM software implementations, managing customer expectations and ensuring solutions meet agreed schedules and budgets. Working closely with client teams to extract requirements, the role builds and maintains BI platforms while supervising consultants and managing project budgets to drive successful outcomes.

Core Functions

• Deploy and configure BI and CPM software, including related work in Microsoft SQL Server services and Microsoft Office.
• Manage customer expectations and ensure solutions are delivered on agreed schedules and within budget.
• Maintain and enhance client implementations of BI software.
• Work with client teams to extract and distil requirements that define the delivered BI or CPM solution.
• Design and deliver solution documentation as required.
• Supervise and support consultants on managed projects.
• Manage project budgets and outcomes, ensuring all participants are appropriately informed on progress and outlook.

Qualifications & Experience

• CPA or equivalent accounting qualification preferred.
• Minimum five years of experience in a consulting role.
• Minimum two years of experience in an operational management or accounting role.
• Minimum two years of experience supervising small teams.
• Development experience with OLAP and multi-dimensional systems, including Microsoft SQL Server Analysis Services, Oracle Hyperion Essbase, or TM1.
• Experience with Microsoft SQL Server.
• Ability to design and create business solutions for reporting and budgeting.
• Project management skills with demonstrated ability to solve business problems using Excel, database, or OLAP tools.
• Professional, courteous, and committed to delivering high-quality customer support.

Reporting to programme leadership, the Business Intelligence Consultant leads change management and drives adoption of reporting and analytics across teams, gathering and maintaining reporting specifications and building reports in line with established standards. Partnering with data warehouse and development teams, the role ensures BI analysts follow best practices while communicating reporting status and resolving issues before they reach clients.

Primary Duties

• Mentor and train team members on reporting and analytics practices.
• Lead change management and drive adoption of reporting and analytics within programme teams.
• Gather, verify, and maintain reporting specifications from team members.
• Build and distribute reports in accordance with established standards, adapting to client needs.
• Partner with team members to identify and resolve potential issues in reporting and analytics before delivery to clients.
• Define data requirements and work alongside the data warehouse and development team to ensure accuracy.
• Conduct research and development of statistical projections, forecasts, and correlation analyses.
• Use reporting technologies to define metrics, develop actionable recommendations, and identify process improvement opportunities.
• Ensure BI analysts build analytics in a repeatable manner and in line with best practices.
• Maintain compliance with reporting and data policies and procedures.
• Communicate reporting status and inform stakeholders of issues promptly.

Education & Experience

• Bachelor's degree in business, computer science, engineering, finance, economics, or a related field.
• Minimum three years of reporting and analytics experience.
• Minimum four years of experience using Microsoft Excel, with proficiency in data sorting, merging, VLOOKUP formulas, pivot tables, and macros.
• Experience with BI tools such as Spotfire, Business Objects, Domo, Tableau, or Cognos preferred.
• Experience with VMS tools such as Fieldglass or IQNavigator, and/or ATS tools such as BrassRing or Taleo preferred.
• Experience mentoring or training team members preferred.
• Prior RPO, MSP, or staffing industry experience preferred.
• Proficient with Microsoft Office products, including Word, advanced Excel, PowerPoint, and Outlook.
• Strong attention to detail and problem-solving skills with the ability to present data to internal and external clients.
• Strong verbal and written communication skills with the ability to establish and maintain effective working relationships.
• Ability to manage deadlines, remain comfortable with ambiguity, and adapt effectively to change.

Sitting at the intersection of business analysis and technical consulting, the Business Intelligence Consultant leads the development of SQL-based dashboards, reports, and analytics using SSRS and other BI tools while eliciting and documenting client requirements and managing cross-functional project work. Operating across client organisations, the role delivers product expertise through pre-sales activities and drives continuous improvement of implementation methodology and best practice documentation.

Duties

• Elicit and document client requirements and maintain customer reporting documentation.
• Extract and transform customer data into standard templates.
• Develop SQL-based dashboards, reports, and analytics using Excel, SSRS, and other BI tools.
• Provide product expertise and maintain a knowledge base of implementation and design best practices.
• Analyse and troubleshoot customer issues.
• Conduct pre-sales activities, including reporting demonstrations to prospective and existing customers.
• Manage cross-functional project work and continually improve implementation methodology.
• Create white papers and best practice documents.

Skills & Qualifications

• Bachelor's degree with seven to ten years of experience in a business or technical consulting role.
• Minimum three years of project management experience, including requirements identification, project planning, and on-time delivery within scope.
• Practical experience with Microsoft SQL Server and Analysis Services.
• Advanced Microsoft Excel skills, including complex formulas, macros, and sophisticated formatting.
• Strong business analysis experience, including requirements elicitation and analysis.
• Some working knowledge of generally accepted accounting principles and financial statement preparation.
• Working knowledge of operations and business reporting requirements.
• Excellent verbal and written communication skills, including presentation skills and the ability to listen and understand others.
• Strong analytical and problem-solving skills with superior organisational and decision-making ability to manage multiple concurrent projects.
• Ability to interact effectively with senior-level executives, including CFOs and VPs.

A key member of the BI and analytics team, the Business Intelligence Consultant leads design sessions and builds end-to-end analytical solutions encompassing scorecards, KPIs, dashboards, and financial and supply chain performance reporting. Collaborating across business partner groups, the role transforms requirements into prototypes, trains business users on dashboard applications, and provides subject matter expertise across the full analytics solution lifecycle.

Functions

• Interact with business partners to understand reporting needs, including critical metrics and KPIs.
• Lead design sessions and write technical architecture and design documents.
• Transform business requirements into prototypes to provide business and data insights.
• Design, develop, test, deploy, and support BI and analytical solutions.
• Train business users on how to utilise dashboard applications.
• Troubleshoot data-related issues with minimal guidance and provide scalable solutions.
• Provide subject matter expertise in analysing, assessing, and building analytical applications.
• Manage technical scope and provide hands-on expert-level assistance.
• Develop application documentation and perform maintenance and support activities.

Requirements

• Tableau certification is a plus.
• Minimum five years of Tableau development experience.
• Experience in end-to-end implementation of BI projects, including scorecards, KPIs, reports, and dashboards.
• Experience in developing BI solutions supporting financial, sales, and supply chain performance reporting.
• Experience in data modelling, data cleansing, and data transformation activities.
• Experience with change management and version control methodologies.
• Understanding of data warehousing methodologies and ETL processing.
• Proficiency in writing and debugging SQL queries.
• Ability to convert business requirements into functional specifications or wireframes.
• Experience with Tableau user and group management, and dashboard optimisation for usability, performance, and standardisation.
• Exposure to other visualisation tools such as Looker.

Accurate and actionable business reporting depends on the Business Intelligence Consultant, who collects and reorganises data from multiple primary and secondary sources, develops trend and prediction reports, and maintains databases while ensuring quality assurance of imported data. Based within a project delivery team, the role creates efficient and reusable code using version control tools such as Git and contributes to knowledge resources and peer review processes.

Accountabilities

• Collect data from multiple primary, secondary, internal, and external sources to generate relevant inputs for analysis.
• Reorganise and filter mined data into a consistent format suitable for analysis.
• Assist in interpreting raw data and compiling outputs on Excel worksheets.
• Assist in the management and maintenance of databases and master data, including creation, updates, and deletions.
• Develop reports that effectively communicate trends, patterns, and predictions using relevant data.
• Create documentation for own work and perform peer review of others' documentation.
• Manage and contribute to project-related documents and knowledge resources.
• Report on the status of assigned tasks and comply with project reporting standards.
• Create efficient and reusable code, following coding best practices and managing changes using a version control tool such as Git or Bitbucket.
• Provide quality assurance of imported data, working with the Quality Assurance Analyst as needed.

Position Requirements

• Basic knowledge of statistical methods, data analysis software, and working with large datasets.
• Proficiency in spreadsheet tools such as Microsoft Excel or Google Sheets.
• Basic knowledge of Tableau or Power BI.
• Proficiency in code version control tools such as Git or Bitbucket.
• Knowledge of operating systems and software platforms.
• Strong critical thinking and attention to detail with the ability to analyse numbers, trends, and data.
• Ability to present findings and translate data into understandable documents.
• Ability to estimate numerical data and work effectively in a team environment.

As the Business Intelligence Consultant, this role manages end-to-end delivery of BI projects from requirement analysis through to technical support, designing reports and data warehouse solutions while defining and driving BI governance and standard methodologies. The broader BI community relies on this work to build intuitive dashboards and data visualisations that drive business decisions, supported by pre-sales participation and comprehensive end-user training.

Day-to-Day Responsibilities

• Manage end-to-end delivery of BI projects, including requirement analysis and translation into technical specifications.
• Design reports, develop data warehouse solutions, and provide technical support using BI products.
• Design and review application data models and customisations using scripting and dashboard visualisations.
• Provide end-user and business partner product training and prepare supporting documentation and training materials.
• Fine-tune reports and dashboards for high performance and higher-volume throughput.
• Define, socialise, and drive BI governance and standard methodologies to support the growing BI community.
• Participate in pre-sales activities on an occasional basis.

Knowledge Skills & Abilities

• Bachelor's degree in Information Technology, Computer Science, Accountancy, Finance, or a related field.
• One to two years of experience as a functional consultant, support specialist, or similar role.
• High proficiency in T-SQL with general familiarity with SQL Server, database structures, stored procedures, and SQL views.
• Familiarity with server installation, configuration, and parameter tuning.
• Experience building intuitive and actionable dashboards and data visualisations that drive business decisions.
• Knowledge of BI, ETL, reporting, or virtualisation tools is advantageous.
• Basic knowledge of IT networking and Microsoft Office, including Excel.
• Proficiency in English, both written and verbal; ability to communicate in Mandarin is a distinct advantage.
• Self-motivated and accountable, with the ability to work independently, manage multiple tasks simultaneously, and demonstrate excellent interpersonal and organisational skills.

Business Intelligence Consultant develops and maintains front-end BI solutions in SAP Analytics Cloud, supporting the setup of an overall SAC governance model and collaborating with cross-functional teams to build integrated solutions emphasising quality and consistency. Success in the position means engaging with super users and stakeholders to define and promote BI strategy and governance principles while continuously improving front-end platforms through training activities and ongoing collaboration.

Scope of Work

• Develop, support, and maintain front-end BI solutions in SAP Analytics Cloud (SAC).
• Inspire and support the business in the development of front-end BI solutions.
• Maintain and improve front-end BI platforms.
• Organise and conduct front-end BI training activities.
• Support the setup and development of an overall SAC governance model to position the solution for future reporting and analytics operations.
• Collaborate with cross-functional teams to develop an integrated SAC solution emphasising quality, productivity, and consistency.
• Engage with super users to understand their needs and improve ongoing collaboration.
• Define and promote BI strategy and governance principles with multiple stakeholders.

Background & Experience

• Four or more years of experience in BI, IT, Business Administration, Engineering, or a related field.
• Experience designing and maintaining front-end BI solutions using Microsoft Power BI and SAP Analytics Cloud.
• Architectural, technical, and application knowledge of SAC and Data Warehouse Cloud.
• Experience with SAC integration with SAP and non-SAP systems.
• Data modelling (star schema) and data visualisation skills.
• Strong communication skills with a focused, problem-solving approach and the ability to collaborate effectively with diverse stakeholders.
• Team-oriented and motivated, with the ability to take ownership and drive continuous improvement within a broader organisational context.

The Business Intelligence Consultant develops and delivers BI and data warehousing projects across client engagements, reviewing requirements, designing cost-effective solutions, and preparing client reports and presentations. Working alongside internal and external stakeholders to ensure satisfaction, the role advances BI practice through technical documentation, business development support, and custom test cases that enable early identification of data issues.

Work Activities

• Design, develop, and deliver BI and data warehousing projects and components of larger, complex projects.
• Review and analyse client requirements and problems.
• Design and deliver cost-effective solutions to meet client requirements.
• Manage work streams, assign tasks, and drive them to completion.
• Perform qualitative and quantitative analyses and create custom test cases to enable early identification of data issues.
• Prepare and deliver client reports and presentations.
• Provide regular updates to internal and external stakeholders to ensure satisfaction.
• Assist with business development activities.
• Create technical documentation and user manuals.

Professional Experience

• Bachelor's degree in Information Technology or a related technical discipline.
• Three or more years of experience in a consulting or business analyst role in BI, ETL, or data warehousing.
• Experience with SQL, database platforms such as SQL Server and Oracle, ETL tools such as SSIS and Informatica, and BI tools such as Power BI, Qlik, and Tableau.
• Experience with data warehousing and lakehouse technologies such as Azure Data Factory, Databricks, Snowflake, AWS, or Hadoop is desirable.
• Technical architecture, design, or development experience in analytics, data warehousing, system integration, dashboarding, and report building.
• Solid project management, client influencing, and relationship-building skills.
• Excellent presentation and communication skills with the ability to reverse-engineer existing solutions and propose improvements.
• Ability to work willingly and effectively with others across the organisation to accomplish team goals.

Embedded within a client services practice, the Business Intelligence Consultant develops interactive dashboards and manages multiple large data sources, serving as the ongoing point of contact for clients across onboarding, training, technical support, and report creation. Working closely with internal teams and offshore resources to coordinate data enrichment and quality control, the role oversees security permissions, licence monitoring, and new platform module development.

Performance Expectations

• Serve as an ongoing point of contact for clients, covering onboarding, training, technical support, and report creation and distribution.
• Manage multiple large data sources and streamline data enrichment procedures and analytics via interactive dashboards.
• Collect, parse, and analyse data from client systems and coordinate data enrichment and quality control with internal teams and offshore resources.
• Manage security permissions for external and internal clients, including monitoring licences and assigning rights.
• Implement product updates, features, and enhancements to new and existing modules.
• Support the creation of new platform modules and other practice development initiatives.

Experience & Qualifications

• Bachelor's degree in a quantitative or analytical field.
• One or more years of relevant internship or work experience preferred.
• Extensive experience with Microsoft Excel and at least one leading BI tool such as Power BI, QlikView, or Tableau.
• Knowledge and experience with relational databases and SQL, including familiarity with ETL processes and data modelling.
• Start-to-finish system development lifecycle experience.
• Industry experience in financial services, high tech, or legal sectors.
• Demonstrated organisational and project management skills with the ability to balance multiple client engagements and deliverables.
• Proven analytical and quantitative skills with the ability to analyse, organise, and create design documentation from large datasets.
• Experience leveraging APIs and third-party data.

Reporting to application and client stakeholders, the Business Intelligence Consultant develops, supports, and maintains ETL solutions, reports, and BI applications for clients, working closely with application owners to gather requirements and deliver accurate estimates across all environments. Partnering with onshore clients and functional teams across onshore and offshore resources, the role ensures application availability and follows best practices in incident response, change requests, and environmental changes.

Role Responsibilities

• Develop, support, and maintain ETL solutions, reports, and other BI applications for clients.
• Work with clients to understand their business needs and deliver value through a range of BI tools.
• Follow best practices in application delivery, including responding to incidents, change requests, and environmental changes.
• Ensure application availability and render production support when required.
• Work closely with application owners to gather requirements and deliver results.
• Provide accurate estimates and test and deploy solutions across all environments.
• Develop and maintain system documentation.
• Communicate with onshore clients to gather requirements.

Technical Qualifications

• Minimum one year of experience with Power BI development.
• Experience with SSAS (multidimensional and tabular cube), SSRS, and SSIS.
• Knowledge and experience developing ETL models for data warehousing.
• Good knowledge of MS SQL.
• Knowledge of QlikView and QlikSense.
• Strong analytical and data-tracing skills.
• Good communication skills and client-facing skills, including verbal communication, demonstrations, and training delivery.
• Ability to work with functional teams across onshore and offshore resources.
• Ability to demonstrate a clear approach to methodology and functional capabilities.
• Flexibility to work in a process-oriented environment and follow a European time and calendar.

Sitting at the intersection of functional consulting and technical SAP BI support, the Business Intelligence Consultant supports implementation, testing, and cutover activities while liaising with regional BI representatives to align on tasks and priorities. Operating across Finance, Retail, and Supply Chain business structures, the role refines knowledge transfer processes and delivers content and documentation to regional BI support members in a Japanese-language business environment.

Job Functions

• Understand the project scope and ensure activities are on schedule and coordinated.
• Support implementation, testing, and cutover phase activities.
• Report issues and translate them into actionable solutions.
• Liaise with regional BI representatives to align on tasks and priorities.
• Provide knowledge transfer to regional BI support members, sharing content and documentation as deliverables.

Minimum Qualifications

• Experience in luxury or retail business is a plus.
• Hands-on experience in SAP BI support as a member or consultant.
• Understanding of SAP BW end-to-end data flows, including extraction, transformation, and reporting.
• Functional and technical BI background.
• Strong knowledge of business structures across Finance, Retail, and Supply Chain.
• Business-level proficiency in Japanese and English.
• Skilled in business process analysis.
• Current residence in Japan required.

A key member of the Commercial Analytics leadership team, the Business Intelligence Consultant independently manages end-to-end analytics solution lifecycles and leads national and international BI projects, developing solutions aligned to IT infrastructure and profitability requirements. Collaborating across business stakeholder groups, the role evaluates emerging technologies, optimises existing processes, and generates insights at a global level to support strategic business directions and goals.

Strategic Responsibilities

• Develop analytics solutions, including system configuration, design, and documentation aligned to functionality, IT infrastructure, and profitability requirements.
• Provide professional client consultation to optimise existing processes and conceptualise analytics solutions within national and international project environments.
• Evaluate new technologies for functionality and cost-benefit alignment with required business outcomes.
• Manage the end-to-end analytics solution lifecycle.
• Lead analytics projects in national and international environments, ensuring adherence to agreed project goals, budgets, and timelines, including directing internal and external providers.
• Engage with business stakeholders to understand business directions and goals and translate them into appropriate analytics needs.

Qualifications & Experience

• Bachelor's degree or higher in a relevant field.
• Extensive experience designing and implementing complex enterprise BI solutions with ETL and integration across multiple enterprise applications such as CRM and SAP, as well as unstructured data sources.
• Proficiency in BI and analytics tools with strong experience in cloud technology and architecture, including AWS and Azure.
• Good knowledge and experience in MS SQL and JavaScript.
• Experience in data preparation, data virtualisation, and data visualisation is a plus.
• Good knowledge of systems integration across the BI landscape.
• DevOps and Agile experience, with preference for experience leading agile teams.
• Strong communication and presentation skills with the ability to build rapport across multiple functions and levels.
• Fluency in English across reading, writing, listening, and speaking.

Sustainable enterprise analytics depends on the Business Intelligence Consultant, who takes technical leadership on design and development projects, assessing current application architecture and defining target architecture, strategic roadmaps, and integration opportunities with little or no supervision. Serving as a coach and mentor to colleagues, the role engages across technology and business functions to develop scalable, consensus-based enterprise solutions and supports future professional services engagements through analysis of client requirements and technology trends.

Leadership Responsibilities

• Develop and maintain relationships with architecture and business stakeholders and project managers.
• Assess current application architecture and define target application architecture, strategic roadmap, and legacy application replacement priorities.
• Approve application architecture processes and templates to ensure alignment with target enterprise architecture and integration opportunities.
• Coach and mentor colleagues on application architecture.
• Work with colleagues in technology and business roles to develop scalable, adaptable, consensus-based enterprise solutions.
• Enhance application integration to reduce costs, improve efficiency, and support application retirement targets.
• Support the development of future professional services engagements based on analysis of client requirements and technology trends.

Skills & Qualifications

• Bachelor's degree or higher in a relevant field.
• Very good experience with BI and data analytics technologies such as Tableau, Power BI, and MicroStrategy.
• In-depth knowledge of architecture frameworks and methodologies.
• Good understanding of applying integration domain experience to the design of business solutions.
• Broad knowledge of technology developments and trends with a proactive analytical and problem-solving approach.
• Strong communication skills with the demonstrated ability to engage effectively across multiple functions and levels.
• Fluency in Spanish and English required.

As the Business Intelligence Consultant, this role develops custom reports and automated reporting scripts for internal departments and external clients, consulting with end users to improve ERP-related processes and delivering application training across SAP Business One environments. The technology and operations team depends on this work to validate and implement new modules, resolve application functionality issues, and maintain technology resources through effective troubleshooting and master data migration.

Operational Focus

• Develop custom reports and deliverables for internal departments and the external client base.
• Design automated reporting scripts and schedules to deliver reports to targeted audiences.
• Consult with end users to understand and improve ERP-related processes.
• Validate, test, and implement new modules and features within the application.
• Analyse and resolve issues regarding application functionality.
• Develop and deliver application training for end users.
• Migrate master data between different data sources.
• Assist the technology department with maintenance and troubleshooting of technology resources.

Education & Experience

• Bachelor's degree in Computer Science, Computer Information Systems, Information Management, or a related field.
• SAP Business One certification.
• Minimum five years of BI reporting development experience using BI modelling, reporting, and data management tools.
• Strong understanding of SQL Server (2014 and later), including scripting and query creation.
• Ability to create complex reports using Crystal Reports from multiple data sources.
• Experience with SAP Business One ERP applications, integration tools, and third-party add-ons, including developing, testing, and implementing macros for business processes.
• Understanding of ERP modules related to finance, sales, purchasing, inventory, and production.
• Understanding of MS Windows Server, Active Directory, Group Policy, and Terminal Server.
• Experience working with warehouse management systems and mobile computers.
• Excellent presentation and communication skills with the ability to consult effectively with department managers and leaders.

Business Intelligence Consultant oversees the end-to-end supply chain technology suite for BI, reporting, analytics, and RPA, translating business requirements into solutions while managing vendors and contractors in accordance with service-level agreements. The work directly supports cross-functional teams through requirements gathering, training, and system demonstrations, ensuring complete, accurate, and timely data integration across logistics and supply chain operations.

Key Deliverables

• Support IT strategy for the end-to-end supply chain technology suite relating to BI, reporting, analytics, and RPA.
• Work closely with cross-functional teams to ensure complete, accurate, and timely data integration and mapping for all reporting needs.
• Partner with users and business stakeholders to conduct requirements gathering and prioritisation.
• Translate business requirements for product and technical team review and assist in solution design.
• Manage vendors and contractors in accordance with service-level agreements.
• Provide training and system demonstrations to users, stakeholders, and management.
• Review new trends in BI, reporting, analytics, and RPA to drive innovative solutions.

Required Qualifications

• Degree in Information Technology, Computer Science, Information Systems, Supply Chain, Logistics, or an equivalent field.
• Five to seven years of experience developing, implementing, supporting, and maintaining BI reporting, analytics, and RPA solutions.
• Strong background in both Information Technology and supply chain operations, including solid understanding of warehouse operations and processes.
• Strong project management experience.
• Prior experience in project management of mid-to-large-scale projects and vendor management, including SLA oversight.
• Meticulous attention to detail with strong analytical problem-solving skills.
• Excellent communication and presentation skills with the ability to work independently and as part of a cross-functional team.

The Business Intelligence Consultant creates and maintains interactive custom visuals, dashboards, and charts using Tableau while designing physical database objects and performing ETL on data from multiple sources into Tableau applications. Working within a data warehousing and BI infrastructure team, the role executes detailed source system analysis, monitors data warehouse components, and ensures quality coding aligned to both business and technical specifications.

Areas of Ownership

• Work with platform APIs and develop interactive custom visuals, including dashboards and charts.
• Design, create, and tune physical database objects such as tables, views, and indexes to support logical and dimensional models.
• Perform detailed analysis of source systems and source data and model that data.
• Interpret written business requirements and technical specification documents.
• Perform ETL on data from multiple sources into Tableau applications.
• Ensure the Tableau server continues to run and operate efficiently.
• Create and maintain technical design documentation and perform quality coding to business and technical specifications.
• Cover the integration of reporting dashboards into other applications.
• Monitor components that make up the data warehouse and BI infrastructure.

Technical Qualifications

• Four or more years of experience with Tableau.
• Experience with Power BI (required) and Qlik (preferred).
• Experience with initial design, setup, and data loading of BI platforms.
• Experience building management and operational reports.
• Experience with PostgreSQL, MySQL, and Cassandra.
• Experience with industry-standard data security and data access principles.
• Written and spoken English proficiency.

Embedded within an innovative analytics team, the Business Intelligence Consultant coordinates data analysis, develops and modifies data structures and models, and implements new data analysis methodologies while defining requirements and providing simplified explanations to stakeholders. Working closely with the IT department to implement new models, the role builds policies and procedures for data collection and analysis and performs data profiling to identify anomalies, primarily within a manufacturing industry context.

Core Responsibilities

• Develop, analyse, and modify processes, data structures, and models.
• Define requirements and provide simplified explanations to stakeholders.
• Develop policies and procedures for the collection and analysis of data.
• Implement new data analysis methodologies.
• Coordinate with the IT department to implement new models.
• Perform data profiling to identify anomalies.

Qualifications & Experience

• Minimum five years of experience in a BI role, preferably in the manufacturing industry.
• Minimum three years of experience in a supervisory capacity within BI or data analysis.
• Familiarity with data collection software and protocols, and experience integrating new software and programmes into data services.
• Excellent analytical and forecasting ability with strong written and verbal communication skills.
• Ability to understand and find appropriate applications for data and analysis results.
• Ability to prioritise multiple concurrent projects effectively.