BUSINESS INTELLIGENCE SPECIALIST JOB DESCRIPTION

Without reliable data delivery, business reviews stall and executive decisions rest on incomplete information. A Business Intelligence Specialist closes that gap by translating raw data from enterprise data warehouses into validated dashboards and self-service analytics that operational teams can act on. This role owns the full pipeline from requirements intake through visualization deployment, sitting within a data or analytics function that services stakeholders across finance, operations, and commercial units. Dimensional modeling standards, ETL process governance, and data quality frameworks define the technical landscape where this work lives.

As the Business Intelligence Specialist, you are accountable for designing, building, and maintaining BI solutions that give business stakeholders timely, accurate visibility into organizational performance. You will operate within a data or analytics team, partnering with both technical developers and non-technical business owners across a matrixed enterprise environment to ensure reporting outputs meet governance standards and drive measurable decisions.

Career Impact: Owning the end-to-end delivery of enterprise dashboards and dimensional data models builds specialized credibility that is in high demand across data engineering and analytics leadership tracks.

Business Impact: The dashboards and self-service analytics tools you produce become the decision layer for finance, operations, and commercial leaders, meaning data gaps or inaccurate metrics directly affect quarterly planning and revenue performance reviews.

Growth Opportunity: Exposure to enterprise data warehouse architecture, ETL frameworks, and data governance positions you for progression into Senior BI roles, Analytics Engineering, or Data Architecture functions.

• Design and develop interactive dashboards and reports that translate complex data into actionable insights for business stakeholders.
• Build and maintain ETL pipelines to ingest, transform, and load data from multiple internal and external sources into the data warehouse.
• Partner with business analysts and cross-functional stakeholders to gather reporting requirements and convert them into technical specifications.
• Validate data integrity across warehouse layers by implementing reconciliation checks and data quality audit processes.
• Develop and maintain dimensional data models, data marts, and metadata structures to support scalable analytics delivery.
• Mentor junior BI staff and train end users on self-service analytics tools to improve adoption and data literacy across the organization.
• Monitor and tune dashboard performance, query execution, and data load jobs to ensure high availability of production BI environments.
• Document technical designs, data flows, and reporting standards to support governance and knowledge transfer.

• Bachelor's degree in Computer Science, Information Systems, Mathematics, Statistics, or equivalent work experience.
• 3 or more years of BI development experience, with demonstrated expertise in dashboard design and data warehouse delivery.
• Proficiency in SQL for querying, data analysis, and data transformation across relational database environments.
• Hands-on experience designing and maintaining dimensional data models, including star and snowflake schemas.
• Demonstrated ability to develop and manage ETL processes for structured and unstructured data sources.
• Strong communication skills with the ability to present data insights clearly to both technical and non-technical audiences.
• Experience gathering and translating business requirements into functional reporting specifications.
• Proven ability to manage multiple concurrent projects and deliver against defined timelines in an enterprise environment.

• Experience with cloud data platforms such as Azure Data Lake, Snowflake, or AWS Redshift in support of enterprise data warehouse migration or modernization.
• Familiarity with data governance frameworks including metadata management, data lineage, and master data management principles.
• Prior exposure to agile delivery methodologies, including sprint planning and backlog management within a BI or analytics team.
• Technical certification in a BI platform or related discipline, such as those offered by Microsoft, SAS, or a recognized analytics body.

• Dashboard adoption rate, measuring the percentage of target business units actively using self-service BI tools.
• Data quality audit pass rate, reflecting the proportion of warehouse jobs that complete without reconciliation failures.
• ETL job success rate, tracking the percentage of automated data loads completing on schedule and without errors.
• Mean time to delivery for new report requests, measuring how quickly requirements move from intake to production release.
• Stakeholder satisfaction score on BI outputs, captured via structured feedback cycles tied to quarterly business reviews.
• Typical tools: BI and visualization platforms (commonly Power BI or Tableau); ETL and data integration tools (commonly Informatica or SSIS).

• Base Salary Range: $80,000 to $115,000 annually, depending on seniority and location
• Bonus: Annual performance bonus of 5 to 10 percent of base salary
• Equity: Stock options or RSUs offered at mid-to-large technology and enterprise firms
• Health Benefits: Medical, dental, and vision coverage; employer contribution varies by organization
• PTO: 15 to 20 days annually, plus standard public holidays
• Common Perks: Remote or hybrid flexibility, professional development budget, certification reimbursement

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

Employment with any organization using this template is contingent upon successful completion of a background check and verification of authorization to work in the United States. All qualified applicants will receive equal consideration for employment without regard to race, color, religion, sex, national origin, age, disability, veteran status, 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.

The Business Intelligence Specialist shapes the end-to-end incentive management operation, leading quarterly incentive calculations, performance management frameworks, and data visualisation to support senior stakeholders and executives. Reporting to sales and finance leadership, this role bridges sales, finance, and HR teams to deliver actionable data insights that enable effective decision-making and drive operational improvements across planning, forecasting, and business review cycles.

Key Responsibilities

• Act as the primary interface between sales, finance, and HR teams to lead daily operations for incentive management.
• Facilitate the quarterly incentive calculation process and associated operational matters.
• Engage sales leaders and the sales community to support the transformation of the incentive calculation process.
• Prepare and articulate data insights and propose recommendations to senior stakeholders and executives to improve daily operations for the sales incentive management team.
• Identify, validate, and analyse data from multiple sources to provide actionable insights and recommendations to enable effective decision-making.
• Design, structure, and operate a performance management framework to facilitate the distribution and tracking of sales and revenue performance.
• Visualise data analytics to help stakeholders understand insights and enable the business to act on them.
• Apply broad knowledge of business operations to contribute to annual and quarterly planning sessions, monthly business reviews, and other key cadences.
• Conduct modelling, forecasting, and scenario analysis to support business decisions for the designated area, particularly in sales performance management.
• Contribute to the delivery of performance improvement planning and activities, including supporting the design, development, and deployment of business improvement solutions.

Required Qualifications

• Bachelor's degree in Business Administration, Finance and Accounting, Human Resources, or a related discipline.
• Extensive experience in sales operations, human resources, remuneration, finance, or business analysis in B2B firms, preferably in telecommunications or technology companies.
• Experience in data transformation and manipulation, business intelligence, and data visualisation.
• Strong analytical skills with a commitment to accuracy and attention to detail.
• Strong senior stakeholder management skills.
• High level of fluency and presentation skills in English.
• Good communication and interpersonal skills in handling employee enquiries.
• Knowledge of Alteryx, Power BI, or Tableau is an advantage.

Embedded within the analytics and data team, the Business Intelligence Specialist owns the design and delivery of flexible, scalable BI solutions and a self-service analytics ecosystem built on tools including Alteryx, Alation, and Tableau. Working closely with business users and the analytics product development team, this role ensures data quality and integrity while empowering teams to extract maximum value from performance reviews and business insights.

Core Functions

• Design flexible and scalable BI solutions based on requirements gathered and experience.
• Automate regular reporting to improve performance visibility and aid data-driven decision-making.
• Ensure data quality and integrity by working with the analytics product development team.
• Establish, develop, and maintain a self-service analytics tools ecosystem, including Alteryx, Alation, and Tableau.
• Support and train users through the onboarding and upskilling journey of using data and tools.
• Empower teams to use the self-service analytics environment to maximise value from performance reviews and business insights.

Qualifications & Experience

• University degree or higher in a quantitative discipline, or equivalent relevant experience.
• Experience developing robust, scalable, and actionable data products.
• Expertise in MI/BI systems and databases, including Hadoop, Teradata, and other SQL or NoSQL technologies.
• Strong knowledge and experience using business intelligence and visualisation tools, including Tableau.
• Experience developing ETL frameworks and processes for automation using tools such as Alteryx.
• Experience with Python and APIs for data wrangling and building ETL pipelines is desirable.
• Good understanding of the full data lifecycle and enterprise concerns around data platforms, including governance, quality, and metadata.
• Experience creating outputs for both technical and non-technical audiences.
• Excellent written and verbal communication skills.
• Methodical and analytical approach with strong problem-solving skills.

Reporting to the data and technology leadership, the Business Intelligence Specialist delivers interactive dashboards, reports, and core datasets that enable internal stakeholders to use and understand data more efficiently across multiple global teams. Partnering with cross-functional business units on high-visibility projects, this role manages BI projects and working teams while developing user-friendly training materials and providing technical support.

Primary Duties

• Create visually appealing and interactive dashboards and reports that support business decision-making.
• Contribute to process and solution design to enable internal stakeholders to use and understand data more efficiently.
• Collaborate with various internal stakeholders across multiple global teams on high-visibility projects.
• Support the development of core datasets across various data sources, ensuring reporting requirements are met, including reconciliation and validation of data.
• Manage and oversee BI projects and working teams.
• Document processes and procedures and develop user-friendly training materials.
• Provide technical support and user training sessions.

Skills & Qualifications

• Diploma or degree in a relevant field, or equivalent related experience.
• Minimum 2 years of hands-on experience in BI tools such as Power BI or equivalent.
• Solid experience developing visualisation reports and dashboards using BI tools, with the ability to interpret data from a business perspective and drive analytics solutions.
• Advanced working knowledge of Microsoft Excel, PowerPoint, and Word.
• Proven experience in learning new data tools quickly and executing in those tools.
• Ability to initiate and drive projects, analyse large datasets for actionable insights, and communicate findings effectively to internal stakeholders.
• Ability to communicate effectively with both financial and non-financial audiences.
• Ability to explain complex system and accounting issues to non-technical users.
• Strong focus on the overall business picture and broader team goals.

Sitting at the intersection of data engineering and business reporting, the Business Intelligence Specialist delivers accurate, timely reports and dashboards by analysing report requests, designing data models, and integrating data from multiple systems using SAP Analytics Cloud. Operating across business units and reporting teams, this role ensures continuity of commissioned reporting services and builds analytical solutions grounded in SQL, statistics, and engineering principles to support data-driven decision-making.

Duties

• Analyse report requests according to business needs, propose appropriate reporting model solutions, and implement adaptation, development, and visualisation studies on the relevant platform accurately and promptly.
• Ensure the continuity of the commissioned reporting service.
• Conduct new data modelling or carry out development and maintenance operations on existing models.
• Provide problem-solving support in relation to the assigned reporting tools.
• Apply all incoming report requests to the reporting system.
• Produce reports by integrating data from different systems.

Education & Experience

• Bachelor's degree in Engineering, Statistics, or Mathematics.
• Minimum 4 years of experience in business intelligence and reporting.
• Proficient in SQL and experienced in visual reporting.
• Experience with SAP Analytics Cloud is required; experience with big data, data warehousing, data mining, and data analysis technologies is preferred.
• Capable of requirements analysis, modelling, and documentation for reporting.
• Advanced proficiency in English.
• Strong problem-solving and analytical thinking skills.
• Strong communication skills with the ability to work effectively in a team.
• Proficient in office applications, with a strong level of Excel knowledge.

A key member of the data and analytics team, the Business Intelligence Specialist builds interactive Power BI reports and dashboards by enhancing existing solutions, creating new SQL queries, and ingesting data into the data lake via API. Collaborating across divisions and countries with stakeholders from varied backgrounds, this role delivers data-driven insights that support proactive, independent decision-making in a multicultural global environment.

Accountabilities

• Consult with relevant stakeholders to define goals.
• Research, develop, and implement data-gathering methods.
• Analyse and synthesise data.
• Enhance current Power BI reports and create new reports.
• Assist in creating new SQL queries and help ingest new data into the data lake via API where possible.

Requirements

• Minimum 2–3 years of experience working with Power BI.
• Ability to create fact tables and interactive reports.
• Experience in creating Power BI dashboards.
• Experience with SQL queries.
• Experience in API development in any language.
• Good communication skills with people from different divisions and countries.
• Ability to work independently and find solutions proactively.
• Comfortable working in a multicultural and global environment.

Actionable visualisations and data-driven conclusions across global life sciences operations depend on the Business Intelligence Specialist, who leads full-cycle solution delivery, from project scoping and development to testing and production release, using QlikView and QlikSense within agreed timelines. Serving as a digital enablement team partner, this role trains users, manages a clear project backlog, and shares best practices to build capability across workstreams.

Role Responsibilities

• Manage demands from life sciences businesses globally across all stages of solution delivery, including project scoping, development, unit and user testing, and production release.
• Develop impactful dashboards using supported business intelligence tools, primarily QlikView and QlikSense, within agreed timelines.
• Maintain and enhance existing BI solutions to improve actionable visualisations and enable the business to reach actionable conclusions.
• Independently translate stakeholder requirements into actionable development and project plans.
• Train users on existing tools and best practices within the digital realm across various workstreams.
• Partner with IT teams and centres of excellence to source and validate data to be fed into BI solutions.
• Proactively manage current projects with defined development tasks and maintain a clear backlog of development projects.
• Share best practices within the digital enablement team.
• Develop within the Qlik framework identified as best practice to streamline releases.

Technical Qualifications

• Bachelor's degree.
• Minimum 2–3 years of experience in data and analytics.
• Knowledge of BI and data mining tools, including QlikView, QlikSense, and SQL.
• Knowledge of ERP systems, including Oracle and SAP.
• Proficiency in Microsoft Excel, including pivot tables, VLOOKUP formulas, and macros, and in Microsoft Office applications including Word and PowerPoint.
• Excellent written and verbal communication skills with the ability to interact effectively with stakeholders at different levels.
• Ability to independently arrive at solutions with limited direction.
• Detail-oriented with a commitment to delivering results.
• Ability to manage multiple priorities and deliver on tight timelines.

As the Business Intelligence Specialist, this role builds a suite of Tableau dashboards, mines data using SQL, and leads the development of standardised business reporting that maintains a single source of truth for company-wide metrics and enables self-service insight delivery. The data team relies on this work to communicate data-driven insights, gather requirements, and support stakeholders at all levels as a subject matter expert.

Job Functions

• Create standardised business reporting to identify exceptions that enable quick course correction.
• Maintain a single source of truth for company-wide metrics and ensure consistent and standard metric definitions across all reports.
• Design, build, and maintain a suite of Tableau dashboards to track key performance metrics and enable self-service data discovery.
• Mine data independently using SQL to translate business needs into creative visualisations.
• Collaborate with internal stakeholders at all levels to develop and define business questions.
• Communicate data-driven insights and recommendations to key stakeholders.
• Gather requirements and manage reporting design, deployment, and continuous improvement.
• Support peers and stakeholders as a subject matter expert through troubleshooting and analysis of results.
• Assist with Tableau training for internal users to enable self-service.

Education & Experience

• Bachelor's degree in Computer Science, Data Science, Statistics, Economics, Mathematics, or a similar quantitative discipline.
• Minimum 2 years of experience in business intelligence, data engineering, data analysis, or data visualisation.
• Minimum 2 years of experience with Tableau Desktop and Tableau Server.
• Advanced proficiency in SQL and other tools for pulling and analysing data.
• Advanced experience working with large and complex datasets.
• Highly skilled in data visualisation with experience analysing data to solve a wide variety of business problems.
• Experience with Python is an advantage.
• Comprehensive knowledge of Microsoft Office applications, including Word, Excel, and PowerPoint.
• Experience analysing data to create visualisations that drive strategic direction.
• Ability to work independently to solve loosely defined problems.
• Strong communication skills with the ability to build strong relationships with colleagues and stakeholders.

Business Intelligence Specialist owns the design and management of the reporting environment, including data sources, security, and metadata, while providing technical expertise on data storage structures, data mining, and master data management to align business stakeholders on management information requirements. The work directly supports data integrity, normalisation, and the continuous improvement of BI and analytics capabilities across commercial operations in a preferably international environment.

What You'll Do

• Align with business stakeholders on reporting, management information, and related requirements.
• Contribute to the annual IT business plan and related initiatives.
• Provide technical expertise on data storage structures, data mining, and data cleansing.
• Design and manage the master data management process.
• Manage and design the reporting environment, including data sources, security, and metadata, and align with IT colleagues on data and related processes.
• Support initiatives for data integrity and normalisation.
• Troubleshoot the reporting database environment and reports.
• Assess, test, and implement new or upgraded software and assist with strategic decisions on new or further development of current systems.
• Participate in projects and develop dashboards, analysis tools, and other outputs.
• Evaluate changes and updates to production systems.
• Train and support end users on new reports, dashboards, and other capabilities.

Background & Experience

• Bachelor's degree in Computer Science or equivalent from an accredited university.
• Demonstrated experience as a BI or data analyst with order-to-sales, procure-to-pay, and equivalent processes in a commercial and preferably international environment.
• Ability to work with stakeholders to discuss opportunities and assess potential risks.
• Experience with SQL databases and the ability to analyse existing tools and provide software solution recommendations.
• Ability to translate business requirements into non-technical terms.
• Understanding and application of metadata standards.

The Business Intelligence Specialist develops and supports end-to-end ETL procedures, data warehouse architecture, and BI solutions, from data model creation and warehouse layer improvements to query monitoring and business analytics reporting. Reporting to business and technology stakeholders, this role collaborates across teams to ensure data integrity and deliver dashboards and reports that address customer needs across a broad range of cross-organisational projects.

Day-to-Day Responsibilities

• Create data models in accordance with requirements and improve and develop existing models.
• Make improvements to the existing data warehouse layer using SQL query language.
• Design and implement ETL procedures for intake of data from both internal and external sources and ensure data is verified and quality-checked.
• Design, develop, test, and monitor ETL processes.
• Carry out monitoring, tuning, and database performance analysis.
• Perform the design and extension of data marts, metadata, and data models.
• Support implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions on data integrity, and communicating functional and technical issues.
• Collaborate with business and technology stakeholders to ensure data warehouse architecture development and utilisation.
• Prepare business analytics reports and dashboards suited to customer needs.

Professional Experience

• Bachelor's degree from a reputable university.
• Master's degree is an additional asset.
• Minimum 5 years of experience in BI and data warehouse systems.
• Effective usage of T-SQL and PL-SQL.
• Hands-on experience with SAP BO, SAP BO Data Services, and Power BI.
• Experience with Microsoft SSIS is an additional asset.
• Understanding of how IT improvements can impact business performance.
• Excellent command of written and spoken English.
• Strong problem-solving and analytical skills with the ability to create solutions from a business perspective.
• Effective communication skills with the ability to manage a variety of cross-organisational projects across a broad range of internal and external teams.
• Proficiency in Microsoft Office applications.

Embedded within the business intelligence and analytics organisation, the Senior Business Intelligence Specialist oversees the full lifecycle of BI solution development, from architecture and design to data mart creation, technology evaluation, and staff mentoring, while producing reports, dashboards, and data assets that drive decision-support applications. Working closely with developers, end users, and internal customers, this role leads small teams, implements best practices, and ensures high levels of customer focus across BI and analytics solutions.

Leadership Responsibilities

• Create solutions that provide accurate and timely information to the organisation.
• Analyse, design, and build reports, dashboards, and other business intelligence components as needed.
• Lead development initiatives that may drive the creation of new data assets or information exchange to support decision-support applications and BI solutions.
• Work closely with staff to identify levels of effort and task dependencies as assigned.
• Provide technical guidance on the creation of database tables, objects, assets, and cubes using accepted methodologies and best practices for dimensional modelling.
• Lead the creation of data marts as needed.
• Train and mentor business intelligence and analytics staff on new technologies, design and development approaches, and established standards and best practices.
• Collaborate with developers on the application of standards and best practices and contribute to the evolution of best practices aimed at improving scalability, performance, and maintainability.
• Oversee and participate in the research and evaluation of new business intelligence, analytics, and data visualisation technologies.
• Determine the best technologies for the environment, considering future direction, risk, consistency, and return on investment.
• Create architecture and design documents to initiate new development efforts based on knowledge of the overall environment or incoming requirements and specifications.
• Review incoming projects to determine whether existing technologies and capabilities can support the needs of the request.
• Support the analysis, design, and development of reports, dashboards, and data sources through consultation, coaching, mentoring, or direct execution as needed.
• Maintain communication with internal and external customers to facilitate analysis and troubleshooting for production issues and to ensure high levels of customer focus relating to BI and analytics solutions.

Qualifications & Experience

• Bachelor's degree in business intelligence, management information systems, mathematics, statistics, analytics, computer and information sciences, or a related field.
• Minimum 4 years of experience in business intelligence or a related discipline, or 7 years of direct experience in business intelligence, data analytics, or statistics instead of a degree.
• Prior experience as a business intelligence developer or data analyst supporting BI, reporting, analytics, or data warehousing projects.
• Familiarity with a broad range of data platforms, including Oracle, SQL Server, MySQL, Hadoop, Netezza, Teradata, Redshift, and Snowflake, and BI tools including IBM Cognos, SAS, R, Qlik, Oracle BI, SQL Server Reporting Services, Power BI, MicroStrategy, and Tableau.
• Hands-on knowledge of data warehousing and business intelligence concepts, including dimensional and relational modelling and warehousing strategies.
• Experience serving as the senior member on BI or analytics projects with responsibility for design and approach decisions.
• Experience researching and implementing new information systems in a business setting, with the ability to quickly learn and apply new technologies.
• Experience leading small teams to deliver business objectives and conducting technical interviews.
• Experience implementing standards, best practices, and protocols that drive consistency and quality throughout the development lifecycle.
• Experience working with end users and customers, preferably including training and demonstrating solution capabilities.
• Master data management, data stewardship, or data governance experience is an advantage.
• Experience with business operations systems in a pharmacy benefit management setting is an advantage.

Reporting to the enterprise data management leadership, the Business Intelligence Specialist advances strategic data initiatives spanning enterprise data warehousing, master data management, data governance, and ETL, designing and implementing conceptual, logical, and physical data models and presenting operational analytics to drive changes in business practices. Partnering with application development teams and senior stakeholders, this role defines overall data warehouse architecture and develops guidelines that ensure coding standards and data quality across the organisation.

Strategic Responsibilities

• Design and implement strategic data initiatives, including enterprise data warehousing, master data management, data governance, data quality, metadata management, and data marts.
• Assist with daily information management, and administer and monitor automated and manual data integration and ETL jobs to verify execution and measure performance.
• Build reports to audit and validate data warehouse jobs.
• Maintain all production data warehouse integration projects and work with developers to replicate or resolve technical issues.
• Design and implement the enterprise-wide metadata and information management programme, including development of enterprise conceptual, logical, and physical data models.
• Provide data architecture support to major application development initiatives in an agile environment.
• Implement programme standards and procedures to support data warehouse administration.
• Provide technical advice on data management and design to application development and enterprise architecture project teams, end users, and business stakeholders.
• Develop design and ETL coding of source-dependent extracts, source-independent loads, and post-load processes from source to target systems for operational data stores and dimensional data warehouses.
• Document the enterprise data warehouse technical landscape.
• Design and implement relational, multidimensional, and tabular data models.
• Develop approaches for the proper integration of data and information management.
• Help define the overall data warehouse architecture, including the ETL process, operational data store system, enterprise data warehouse, and data marts.
• Prepare and present operational analytics to senior managers and business stakeholders to drive changes in business practices, metrics, and performance.
• Develop guidelines and standards for in-house coding, ensure vendor code is consistent with those standards, and ensure source code is reliably backed up and versioned.

Minimum Qualifications

• Master's degree in Computer Science, Engineering, Mathematics, Decision Science, Statistics, or a related field.
• Bachelor's degree in Computer Science, Engineering, Mathematics, or Statistics, or a related field is also considered.
• Minimum 8 years of progressively responsible experience in data warehousing and integration, including experience applying data modelling techniques and ETL coding.
• Knowledge of and skill in developing and implementing a corporate data architecture programme with responsibility for enterprise conceptual and logical data modelling, data policies, standards and compliance monitoring, metadata mapping, and data governance.
• Knowledge of and skill in developing and implementing enterprise information strategy, enterprise data warehousing, master data management, and data integration, transformation, analysis, mapping, governance, and quality.
• Knowledge of overall data warehouse architecture and ability to integrate large structured and unstructured datasets in multiple formats, character sets, and delivery methods.
• Knowledge of and skill in working with SQL Server and Oracle data warehouses using near real-time loads and change data capture, with CRM and ERP data using Informatica.
• Knowledge of and skill in working with database management systems, including Oracle and Microsoft SQL, and data warehouse solutions and reporting tools to centrally manage and analyse data from disparate source systems.
• Skill in analysing data and established procedures to apply technology principles and practices and lead others in developing, maintaining, and enhancing the information management programme.
• Ability to communicate technical issues effectively to non-technical audiences.
• Experience developing ETL using industry-leading tools such as Informatica.
• Experience in location intelligence with geographic information systems and spatial data.

Sitting at the intersection of financial reporting and enterprise data management, the Business Intelligence Specialist produces Power BI dashboards, DAX-driven reports, and data quality dashboards that support operational and financial metrics for AJG's internal customers and governance teams. Operating across the Enterprise Data Management Technical Team and business stakeholders, this role develops core report templates, monitors Power BI platform health, and communicates data-driven insights to enable data-driven action across the insurance organisation.

Scope of Work

• Use Power BI to develop reports and dashboards for operational and financial metrics.
• Build core report templates for reuse across the organisation.
• Develop a suite of data quality dashboards for utilisation by the governance team.
• Design, develop, and deploy Power BI scripts and perform detailed analysis.
• Perform DAX queries and functions in Power BI.
• Perform SQL querying when warranted.
• Understand data flows, ETL processes, and their impact on DAX expressions.
• Monitor the health and performance of the Power BI platform.
• Understand business requirements to set functional specifications for reporting applications.
• Create charts and document data with algorithms, parameters, models, and relations explanations.
• Create and maintain documentation, including requirements, design, and user manuals.
• Communicate insights gleaned from data using narrative and visualisations to enable data-driven action.
• Partner with leadership and subject matter experts to determine project requirements.

Education & Experience

• Bachelor's degree in statistics, computer science, business administration, or a related field.
• One to three years of experience with BI tools and systems, such as Power BI, SAP, and Tableau, including creating data-rich dashboards, implementing row-level security in Power BI, writing DAX expressions, and developing custom BI products using scripting languages such as R and Python.
• A minimum of one to three years of experience in a data-specific role with sound knowledge of database management, data modelling, business intelligence, SQL querying, data warehousing, and online analytical processing.
• In-depth understanding of and experience with Microsoft BI stack technologies, including Power Pivot, SSIS, SSRS, and SSAS.
• Firm understanding of dimensional and tabular models that enable efficient analysis in Power BI.
• Knowledge of database fundamentals, including multidimensional and relational database design.
• Knowledge of Azure data management tools, including Azure Data Lake, Azure SQL, and Azure Data Factory, is preferred.
• Knowledge of data privacy restrictions on the use of data.
• Knowledge and practice of design theory.
• Ability to drill down into data and visualise it effectively through charts, reports, and dashboards.
• Understanding of software development architecture and technical aspects.
• Ability to prioritise and manage multiple initiatives simultaneously and work at a fast pace under conflicting deadlines.

A key member of the enterprise data and BI platform team, the Business Intelligence Specialist advances data catalogue operations by supporting the Alation platform, integrating metadata between systems, building API-based scripts, and maintaining Tableau data integrations. Collaborating across cross-functional teams on public cloud migration and existing Hadoop-based workloads, this role ensures system reliability, data confidentiality, and the ongoing enhancement of EDW and BI applications through the full software development lifecycle.

Work Activities

• Support the data catalogue application, Alation, as the primary platform.
• Support the integration of metadata between Alation and external systems.
• Support catalogue content uploads in Alation by developing scripts using APIs.
• Support Alation and Tableau data integrations and build dashboards and reports to provide analytical information on catalogue usage.
• Support current data ingestion and compute workloads running on Hadoop.
• Support and enhance the existing data warehouse and BI platform by applying system solutions.
• Support public cloud migration initiatives to migrate existing on-premise EDW and BI applications.
• Apply knowledge of technology and application development methodologies to perform system analysis, testing, debugging, design, and storage.
• Work with cross-functional teams to identify technology modifications that will impact business processes.
• Provide support for all system and service components, including installation, configuration, maintenance, and support.
• Maintain confidentiality about information and data being processed, stored, or accessed.
• Conduct run list reviews, code deployments, and post-deployment validations following the standard software development lifecycle.

Knowledge Skills & Abilities

• Bachelor's degree in computer science, engineering, MIS, or a related field.
• Three to five years of experience in an enterprise data catalogue system such as Alation, or equivalent technologies such as Collibra, IBM Watson, or Alex Solutions.
• Three to five years of experience in big data, EDW, and BI-related technologies.
• Three to five years of experience in ETL and reporting tools such as Tableau, Einstein Analytics, or Business Objects.
• Conceptual and working knowledge of data lineage, data governance, risk and compliance, and API-based catalogue integrations.
• Knowledge of relational database management objects, including tables, schemas, indexes, stored procedures, and macros, as well as database design principles, data administration standards, and information security terminology.
• Deep knowledge of NoSQL databases, SQL, and relational databases.
• Ability to design, develop, test, implement, modify, and maintain BI and data warehousing solutions.
• Experience in scripting languages such as Python, Shell, and PL/SQL.
• Working knowledge of CI/CD tools such as Puppet, Jenkins, Ansible, and Git is a plus.
• Experience working in an agile environment.
• Excellent team player, able to work with virtual and global cross-functional teams at all levels.

Informed country strategy and market-driven decision-making depend on the Business Intelligence Specialist, who produces competitive intelligence databases, channel and competitor landscape analyses, and standardised marketing performance reports that surface actionable opportunities for business leaders. Serving as the analytical backbone of the marketing team, this role leads the annual market report process, automates dashboards and data cubes, and delivers pricing intelligence and ad hoc analysis to support country action plans and head of business development initiatives.

Performance Expectations

• Define and utilise various internal and external sources to provide clear and accurate analysis on topics related to macroeconomics, products, channels, segments, and competition.
• Report on and assess performance compared to market and competitive conditions by writing reports that identify significant trends and make recommendations based on insight and industry knowledge.
• Build a best-in-class competitive intelligence database to provide insight and practical opportunities for business leaders, and identify new primary and secondary data sources to support decision-making and business growth.
• Build and maintain a central channel database covering distributors, electricians, and system integrators.
• Build and maintain a competitive landscape database covering competitors, revenue, employee count, and profitability.
• Lead and facilitate the annual market report process and present results to stakeholders.
• Enhance management decision-making and support the development of country action plans and strategy.
• Increase overall marketing team efficiency and effectiveness through regular, standardised report definition and execution using industry best practices.
• Define, maintain, and monitor marketing performance KPIs and metrics to support all entities.
• Automate dashboards, data cubes, and reports for globally consistent and efficient marketing analysis and delivery.
• Submit regular reporting for the quarterly business review.
• Deliver ad hoc analysis for competitive intelligence.
• Participate in primary market research activities, including survey design, survey implementation, results compilation, and analysis.
• Conduct competitor deep-dive assessments and develop fight-back plans on request.
• Update and develop country strategy with relevant intelligence and insights to support the head of business development.
• Lead specific pricing analysis and intelligence programmes with the country pricing manager.

Position Requirements

• Experience working on tracking and optimisation across all media and marketing activities.
• Understanding of market intelligence, market strategy, competitive intelligence, business analysis, and financial literacy.
• Knowledge of BI tools.
• Understanding of country segment trends and strategies.
• Commercial and financial acumen with strategic thinking and a proven track record of growth momentum.
• Sound qualifications in a business or related discipline.
• Strong analytical and creative skills, with the ability to think outside the box.
• Strong influencing and negotiation skills.
• Intellectual curiosity and the ability to work in an intense, high-pressure environment.

As the Business Intelligence Specialist, this role advances master data strategies across product and material domains by managing data creation, maintenance, and governance processes in alignment with SAP systems and divisional business strategy. The master data team relies on this work to ensure compliance with standards, monitor implementation progress, and represent the division in governance forums that define new data rules and project timelines.

Areas of Ownership

• Work with the global division and business unit team to ensure master data strategies and priorities align with business strategy.
• Operate with a prime focus on the product and materials domain while also covering other master data domains.
• Work with IDEA/IDW systems to help set and implement inward and outward master data strategies.
• Manage master data creation, maintenance, and other operational processes, and oversee the use of master data within the division and business unit.
• Establish relevant instructions, standards, and rules to regulate data management within the division and business unit, and ensure defined processes and metrics for master data are followed.
• Ensure the implementation of new master data standards within the division and business unit, and monitor compliance with master data standards and rules.
• Manage and communicate the status of reporting and progress against implementation plans.
• Work with the team representing the division and business unit in master data governance, with a focus on the product and material domain, including defining new standards, meeting project timelines, supporting implementation strategies, monitoring progress, and handling issues.

Experience & Qualifications

• Associate's degree in data management, business administration, marketing, or a related discipline, with five years of data management experience, or a bachelor's degree in a related discipline with three years of data management experience.
• SAP experience is required.
• Strong technical and analytical skills, with proficiency in advanced Excel, Access, Word, PowerPoint, SQL, and associated business tools.
• Knowledge of industry standards such as UNSPSC, IGCC, and ETIM.
• Proven electrical industry experience and product knowledge are preferred.
• Ability to manage multiple projects simultaneously to defined timelines, work independently, and hit tight deadlines.
• Critical thinker with experience problem-solving in a dynamic environment.
• Highly professional, with excellent verbal and written communication skills.
• Collaborative team player with the ability to influence others and convey ideas to expand master data understanding.

Senior Business Intelligence Specialist refines and develops state-of-the-art BI applications and Qlik dashboards, conducting advanced data cleansing, building sophisticated queries, and implementing standardised methodologies for automated BI solutions and self-service environments. Success in the position means ensuring high availability of timely, refreshed tools and reports, advising on data visualisation best practices, and collaborating with business analysts and data specialists to translate complex requirements into clear, actionable analytical interfaces.

Ownership Areas

• Design and develop state-of-the-art BI applications.
• Build sophisticated queries and reports, utilising complex variable creation, multiple queries, and other advanced techniques.
• Assess data quality and data architecture and make recommendations for data workflow management.
• Perform advanced data cleansing and data analysis, and build visualisations that provide a clear and actionable interface solution.
• Assess existing deployments for optimisation and problem-solving.
• Ensure high availability of timely refreshed self-service tools, reports, and dashboards.
• Implement standard methodologies for automated BI solutions and environments.
• Work with business analysts and data specialists to analyse business requirements and develop solutions.
• Produce effective documentation and communicate high-level insights.
• Proactively formulate action plans to resolve data issues or platform problems.
• Advise on how data visualisations can be best leveraged to provide business value.
• Collaborate within the business insights and analytics team on data requirements, including data structure, data flow, dependencies, and data mapping.

Technical Qualifications

• Bachelor's degree in mathematics, computer science, or a related field, or equivalent professional experience in an applicable data insight industry.
• Three or more years of experience in BI development and architecture using tools such as Qlik, SAP Business Objects, Tableau, or MicroStrategy.
• Two or more years of experience in data modelling and analytical environments.
• Previous experience designing, developing, and implementing Qlik dashboards on Qlik Server is required.
• Proficient in data modelling and data warehousing concepts, with working knowledge of databases such as SQL, Oracle, Teradata, MySQL, and Hadoop.
• Experience with ETL, SAS, SQL, and hands-on data cleansing and transformation using a wide variety of structured and unstructured data sources.
• Demonstrated experience working with large, complex data sets using Qlik, Tableau, and Alteryx.
• Experience with performance tuning, optimising code, and real-time monitoring solutions.
• Experience building data files specifically for underlying BI consumption.
• Experience working with customers to identify BI needs and applying technology as a solution for both tactical and strategic problems.
• Strong analytical and problem-solving skills with attention to detail, including the ability to write complex calculations and expressions.

The Business Intelligence Specialist coordinates the design, development, and implementation of technical analytics solutions, including Power BI reports, SQL data models, and custom analytic tools, to support business analytics and reporting in the customer service area. Reporting to the project manager and collaborating with service management leads, business analysts, and onshore and offshore development resources, this role translates business requirements into technical designs within a global matrix organisation.

Key Deliverables

• Collaborate with service management leads, business analysts, and end users to design and implement analytics projects and solutions.
• Review business requirements and translate them into technical design.
• Design and implement technical solutions to support business analytics and reporting in the customer service area.
• Collaborate with team members to develop and maintain suitable solution standards.
• Provide technical and business knowledge support to the team and stakeholders.
• Escalate time, cost, or quality implications to the project manager.
• Adhere to project management office policies, procedures, and methodologies.
• Ensure effective communication of technical requirements.
• Collaborate with onshore and offshore development resources within a global organisation.
• Develop new and innovative custom analytic solutions to meet complex or specific challenges.
• Attend, support, and drive internal meetings conducted in English.

Background & Experience

• Bachelor's degree in computer science or equivalent experience.
• Five years of experience in analytics software development.
• IT consulting or analytics project management experience, including data model design.
• Proficient in SQL Server Management Studio, SQL Server Integration Services, and SQL Server Analysis Services.
• Experience creating reports in Microsoft Power BI using OLAP sources and relational databases.
• Hands-on experience with APIs, web services, and integration challenges and solutions, ideally using MuleSoft or Informatica.
• Experience in business information modelling and analytics system design.
• Able to work both independently and within a team environment, and able to interact with multiple stakeholders in a global matrix organisation.
• Customer service mindset with the ability to act with a sense of urgency.
• Strong attention to detail with the ability to work simultaneously on multiple priorities in a fast-paced environment with limited direct supervision.
• Effective written and verbal communication skills in English.

Embedded within cross-functional agile scrum teams, the Business Intelligence Specialist guides the design, development, and delivery of SAP BW data warehousing solutions and Power BI visualisation dashboards that centralise and standardise business data for finance teams and business units. Working closely with finance and business teams to gather requirements and develop effective data models, this role provides coaching on SAP BW and Power BI adoption while maintaining automated data processes across integrated SAP module environments.

Key Responsibilities

• Work with finance and business teams to gather and analyse requirements and develop effective solutions based on available options.
• Provide business application analysis and data modelling design to collect, standardise, maintain, monitor, and audit business data for an effective centralised data warehouse.
• Create interactive dashboards and reports through Power BI and other BI tools.
• Support acceptance, governance, resource management, and performance of BI and data warehousing applications.
• Develop and maintain automated data processes, and use various BI reporting tools to create dashboards.
• Provide coaching and training support for finance teams and business units to drive faster adoption of SAP BW and Power BI reports.
• Work in cross-functional agile scrum teams to deliver visualisation dashboards.

Education & Experience

• Bachelor's degree in analytics, engineering, IT, computer science, or a related field.
• At least three years of experience as an SAP BW techno-functional consultant with expertise in FICO.
• Expertise in the design, development, configuration, migration, testing, and implementation of SAP BW data warehousing solutions.
• Hands-on experience designing and building data flows using info objects, info cubes, aggregates, datastore objects, multi-providers, info sets, transformations, DTPs, and data sources.
• In-depth understanding of dependencies and integration with SAP modules, including FI, CO, MM, and SD.
• Knowledge of start routines, update routines, and end routines, with excellent ABAP coding skills.
• Experience developing SAP BEx queries on Power BI and Tableau, and expertise in developing process chains, scheduling, and housekeeping methods.
• Proficient in performance tuning, BEx query development, and open hubs, with strong expertise in error handling and resolution.
• Understanding of data integration practices, including data mining, data preparation, validation, and cleaning, as well as familiarity with complex data structures.

Reporting to the growth team leadership, the Business Intelligence Specialist elevates data-centric thinking across the business by developing Power BI reports that align data from multiple sources into high-value reporting and by interpreting trends and insights for business leaders. Partnering with other business reporting functions to ensure consistency and streamline data processes, this role identifies opportunities for innovation, provides user training, and promotes a curious, high-performing team culture.

Key Responsibilities

• Develop Power BI reports to meet the needs of the growth team by aligning data from multiple sources into high-value, informative reporting.
• Proactively engage with business leaders and groups to understand their needs and foster data-centric thinking.
• Inform business leaders of trends and insights by interpreting data and explaining its implications.
• Stay informed of the latest Power BI software developments to leverage maximum value.
• Collaborate with other business reporting functions to ensure consistency and streamline data processes and reporting.
• Provide training and user support to promote self-service and understanding.
• Contribute to a progressive way of working and a high-performing team.
• Identify opportunities for improvement and challenge the status quo to drive innovation.
• Promote a curious mindset and facilitate the introduction of new concepts and technologies.

Required Qualifications

• Strong analytical skills, including data analysis, and good business acumen.
• Ability to interpret data into insights to support better decision-making.
• Ability to support internal and external business reporting with high quality and attention to detail.
• Ability to identify opportunities for innovation and efficiency within data gathering and reporting.
• Ability to work with a broad range of stakeholders to frame and implement key initiatives to support data-driven insights.
• Excellent communication skills, with the ability to engage at all levels of the business.
• Understanding of sales and operations business processes is an advantage.

Sitting at the intersection of HR operations and business intelligence, the Business Intelligence Specialist creates automated BI processes, self-service dashboards, and Power BI reporting solutions that increase efficiency across the end-to-end recruitment process. Operating across HR, performance management, and cross-functional stakeholder groups in a bilingual English and Spanish environment, this role monitors data quality, develops practical validation methods, and delivers reports and analyses that support data-driven recruitment decisions.

Core Responsibilities

• Enhance, develop, maintain, and deliver reports and analyses.
• Proactively seek to automate and improve internal BI processes, and leverage reporting to increase the efficiency of the overall recruitment process.
• Work with colleagues and stakeholders to identify opportunities for automating and consolidating reports into user-friendly, self-service dashboards.
• Monitor data quality and identify key data integrity issues in collaboration with the performance manager.
• Develop practical data validation methods that improve the overall quality of data.
• Develop a thorough understanding of the end-to-end recruitment process and how these processes translate into systems and reports.

Skills & Qualifications

• Five or more years of experience developing reports and analyses in a data analyst, BI analyst, or similar role.
• Five or more years of experience using Excel to aggregate large datasets, utilising complex formulas and pivot techniques, including INDEX, MATCH, arrays, small, compound IFs, and macros.
• Two or more years of experience with Power Query.
• One or more years of experience with data querying tools such as MS SQL, Oracle SQL, OBIEE, or Business Objects.
• Three or more years of experience with Power BI.
• Demonstrable experience working with relational databases.
• Experience working in an HR environment, including with applicant tracking systems such as Taleo.
• Experience in a customer service or consulting environment.
• Bilingual in English and Spanish.

A key member of the divisional BI and pricing team, the Business Intelligence Specialist executes visual analytical models, interactive Tableau and Power BI dashboards, and monthly, quarterly, and annual performance reports that support pricing goals and business metrics. Collaborating across the division with senior stakeholders and the pricing manager, this role provides ad hoc analysis and actionable insights that drive tactical and operational pricing decisions.

Key Responsibilities

• Design, develop, and build visual analytical models to identify trends, drill down using various measures, and tell a story using data.
• Develop and run required system reports, analyse and compile data, and report on the progress and performance of systems and tracked business activities.
• Create interactive dashboards and reports through Tableau and Power BI, working with large sets of complex data to derive meaningful insights.
• Support the division in achieving pricing goals and business metrics.
• Provide ad hoc analysis to support the business with actionable insights for tactical and operational pricing actions.
• Deliver monthly, quarterly, and annual reports and analysis on time, and regularly monitor, analyse, and report on performance and insights for stakeholders.

Education & Experience

• Bachelor's degree in engineering with a master's degree in business administration with a marketing specialisation from a reputable institution.
• Five or more years of BI experience, preferably in Tableau or Power BI.
• Experience working as a BI developer in a large, multicultural environment.
• Tableau Certified Developer certification is preferred.
• Excellent written, verbal, and analytical skills.
• Prior experience in B2B and channel sales is highly desirable.