BI SPECIALIST JOB DESCRIPTION

A BI Specialist turns raw organizational data into structured, decision-ready reporting that executives and operational teams can act on. The role sits within a data and analytics function, typically reporting to a BI Manager or Analytics Lead, and owns the design, governance, and delivery of dashboards, datasets, and data models that serve cross-functional business units. Data quality failures and ungoverned metrics glossaries cost organizations measurable reporting credibility. This is the role responsible for preventing both.

As the BI Specialist, you translate stakeholder requirements into governed, production-ready BI solutions including certified datasets, dimensional models, and visual reports that support decisions across the enterprise. You work within a data and analytics team, collaborating with data engineers, finance partners, and business unit leads to maintain reporting standards and drive adoption of self-service analytics capabilities.

Career Impact: Owning certified datasets and a metrics glossary within an enterprise data function establishes the kind of domain authority that accelerates progression toward BI Architect or Analytics Lead roles.

Business Impact: The dashboards and governed data models you deliver directly determine whether business units can run operational reviews, track KPIs accurately, and respond to data quality incidents without escalating to engineering.

Growth Opportunity: Hands-on exposure to dimensional modeling, ETL pipeline governance, and self-service BI enablement builds a skill profile that commands strong demand across industries and opens pathways into data engineering and analytics architecture.

• Design and maintain dimensional data models and certified datasets that meet enterprise governance standards.
• Develop visual reports, dashboards, and KPI scorecards for cross-functional business units and executive stakeholders.
• Implement and enforce row-level security, workspace permissions, and data access controls across the reporting environment.
• Collaborate with data engineers to validate new data sources and harden prototype solutions before production deployment.
• Update and maintain the data dictionary and metrics glossary as new sources and business definitions are added.
• Facilitate QA reviews of reports built by business unit developers and govern promotion to shared workspaces.
• Develop and deliver training programs for citizen developers on self-service reporting capabilities and data access protocols.
• Troubleshoot data anomalies, validate result sets, and implement process improvements to maintain reporting accuracy.

• Bachelor's degree in Computer Science, Business, Information Systems, Statistics, or a related field, or equivalent work experience.
• 3 or more years of Business Intelligence experience, with demonstrated delivery of enterprise-scale dashboards and governed data models.
• Proficiency in data modeling concepts including relational and dimensional design, star schemas, and data mart architecture.
• Experience writing complex queries against relational databases for data extraction, transformation, and validation purposes.
• Knowledge of data governance practices including MDM, data quality frameworks, data stewardship, and metrics standardization.
• Ability to gather and translate business requirements into functional BI specifications without losing technical accuracy.
• Strong communication and stakeholder management skills, with the ability to present analytical findings to non-technical audiences.
• Experience working within Agile delivery frameworks including sprint planning, backlog management, and iterative development cycles.

• Microsoft certification in data analytics such as DA-100 or PL-300, or demonstrated equivalent proficiency through portfolio work.
• Experience with ETL pipeline development including data preparation, validation, cleaning, and scheduling for automated refresh workflows.
• Familiarity with multidimensional cube technologies and their compatibility with self-service reporting platforms as input data sources.
• Prior experience enabling self-service analytics adoption across business units through structured training and documentation programs.

• Dashboard adoption rate, measuring the percentage of target business units actively consuming governed reports monthly.
• Data dictionary coverage, tracking the proportion of active datasets with complete and current metadata documentation.
• Report QA pass rate on first review, reflecting the accuracy of models delivered to the governance promotion process.
• Mean time to resolve data anomaly tickets, measuring responsiveness to stakeholder-reported discrepancies in production reports.
• Citizen developer enablement rate, tracking the number of trained users publishing reports to governed workspaces per quarter.
• Typical tools: Self-service BI platforms (commonly Power BI), relational databases (commonly SQL Server), ETL and data prep tools (commonly SSIS or Power Query).

• Base Salary Range: $85,000 to $115,000 per year depending on experience and location.
• Bonus: 5% to 10% annual performance bonus typical for this level.
• Equity: uncommon at individual contributor level, stock purchase plans occasionally offered.
• Health Benefits: medical, dental, and vision coverage standard for full-time roles.
• PTO: 15 to 20 days annually, plus federal holidays.
• Common Perks: Remote or hybrid work options, professional development budget, BI certification reimbursement.

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

Accommodations are available throughout the hiring process for applicants with disabilities in accordance with the Americans with Disabilities Act and applicable state law. All qualified applicants are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other characteristic protected under federal, state, or local law. Employment in this role is contingent on successful completion of a background check. Candidates must be authorized to work in the United States.

The BI Specialist owns governance and reporting infrastructure for business segments, implementing promoted dataflows, certified datasets, and training programs that enable citizen developers to build and maintain analytics solutions. Working closely with data engineering and business stakeholders, the BI Specialist supports advanced analytics delivery while maintaining the data dictionary, metrics glossary, and workspace utilization across the segment.

Key Responsibilities

• Assist in citizen developer prototype phases and augment required data sources in dataflows.
• Facilitate QA reviews of reporting built by citizen developers and promote their reports.
• Provide work item visibility to business stakeholders and the data and analytics core team via DevOps.
• Document reports with similar datasets to identify opportunities for centralized datasets in support of data governance efforts.
• Update and maintain the data dictionary and metrics glossary as new data sources are added.
• Maintain a catalog of existing shared reports across Power BI, SSRS, and Excel.
• Develop and administer continuous training for citizen developers on dataflows, datasets, and Power BI service functionality.
• Support business partners in advanced analytics and consult with data engineering on new data requirements.
• Develop transition plans for legacy reports to curated dataflows and manage workspace utilization for the business segment.

Required Qualifications

• Bachelor's degree in Business, Computer Science, or a related field, or equivalent work experience.
• 2-5 years of experience in Business Intelligence analysis, data engineering, or technical BSA work.
• Knowledge of data governance, MDM, data quality, and data stewardship practices.
• Knowledge of analytics types including diagnostic, descriptive, predictive, and prescriptive.
• Advanced proficiency in Power BI, including connecting to data sources, writing Power Query, data modeling, and optimizing DAX formulas.
• Experience with project management concepts and process methodologies such as Agile and Scrum.
• Strong communication, facilitation, and stakeholder relationship management skills.

Embedded within the Customer, Strategy and Engagement division, the BI Specialist champions adoption of the enterprise Business Intelligence platform and leads customer behaviour analysis, including factors influencing water consumption, to support data-driven decisions. Working closely with internal and external stakeholders across business groups, the BI Specialist ensures compliance with BI standards and communicates analytics outcomes to executive and board-level audiences.

Core Functions

• Champion the adoption of the enterprise Business Intelligence platform and support users for effective and consistent usage.
• Liaise with other business groups to ensure compliance with BI creation and usage standards and inform the creation of such standards.
• Lead analysis to understand customers and their behaviour, including factors influencing water consumption.
• Maintain effective relationships with internal and external stakeholders to enable access to key data and understand their needs.
• Communicate technical concepts and analytics outcomes to internal and external stakeholders including executive and board papers.
• Manage project initiation, problem analysis, scope definition, and accurate documentation while identifying potential downstream impacts.

Qualifications and Experience

• Bachelor's degree or higher in a relevant discipline such as economics, engineering, statistics, mathematics, science, IT, or business.
• Minimum 5 years of experience in a similar role.
• Proven skills in creating meaningful BI content and visualisations, including data modelling for BI delivery.
• Demonstrated experience working with large data quantities, statistical analysis, predictive modelling, and forecasting.
• High-level proficiency in Power BI, with knowledge of SQL, R, Python, or geospatial packages advantageous.
• Strong problem-solving, critical thinking, written, oral, and interpersonal communication skills.
• Proven ability to plan and organise effectively to manage conflicting priorities and meet deadlines.

Reporting to the data team lead, the BI Specialist collaborates with internal departments to document data requirements and builds meaningful Power BI datasets and dashboards that enable effective business decisions. Partnering with developers and end users, the BI Specialist supports SSRS-to-Power BI migration and drives continuous improvement in visual reporting and BI processes.

Primary Duties

• Collaborate with internal departments to obtain, understand, and document data requirements.
• Build relationships with end users and support them in understanding the context of their data.
• Create and maintain meaningful Power BI datasets and dashboards to enable effective business decisions.
• Maintain and improve visual reports, scorecards, and dashboards using Power BI.
• Help migrate existing SSRS reports to Power BI, query SQL database sources, and provide ad-hoc analyses in Excel.
• Empower developers to produce their own reports and share ideas and recommendations.
• Keep up to date with BI and MI information, processes, and the latest Power BI innovations.

Skills and Qualifications

• Minimum 18 months of relevant experience in a similar Power BI role.
• Microsoft certifications in DA-100 or PL-300 are advantageous.
• Experience designing, creating, and maintaining Power BI analytics, with familiarity in DAX.
• Experience gathering data from SQL, SSAS models, REST API web data, or similar sources.
• Knowledge of relational databases, multi-dimensional database design, Power Query, Power Platform, Power Automate, SSRS, SSAS, SSIS, and ETL processes is advantageous.
• Strong analytical and inquisitive mindset with the ability to translate data into informative reports and visuals.
• Excellent communication skills, strong time management, and exceptional attention to detail.

Sitting at the intersection of cloud-based analytics and user experience design, the Power BI Specialist designs, implements, and maintains interactive reports and dashboards across a broad range of analytical use cases on Microsoft Azure Analytics Synapse and Power BI. Operating across project managers, customers, and engineering teams, the Power BI Specialist identifies technical and business improvements that optimize performance and shape engineering culture.

Duties

• Design, implement, and maintain cloud-based interactive reports and dashboards for a broad range of analytical use cases.
• Design and implement analytics frontends with strong UX and deep analytical foundations.
• Identify technical and business improvements, craft solutions, and implement changes.
• Work with project managers, customers, and team members to determine implementation effort and identify risks and opportunities.
• Optimize report and dashboard performance and actively help shape engineering culture.

Experience and Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, or equivalent.
• 3 or more years of hands-on experience with modern BI tools and cloud-based analytical platforms including Microsoft Azure Analytics Synapse and Power BI.
• Expert skills in DAX queries and structuring information into meaningful reports and dashboards.
• Knowledge of Agile prototyping, data warehouse lifecycle, and ticketing systems such as Jira.
• Strong data analysis skills, high attention to detail, and the ability to manage complexity and multitask.
• High customer orientation with the ability to communicate directly with customers at various seniority levels.
• Fluent in English, with a proactive and entrepreneurial attitude.

A key member of the cross-functional quality and engineering team, the BI Specialist links legacy and current data sources including Oracle, MS Access, SQL Server, and Power BI to streamline data analysis and reporting for manufacturing process and field reliability tools. Collaborating across stakeholders in IT, engineering, and operations, the BI Specialist validates data accuracy, recommends code improvements, and ensures quality data reporting remains intact through IT system changes.

Functions

• Link current and legacy data sources including Oracle, MS Access, SQL Server, and Power BI to streamline data analysis and reporting.
• Identify opportunities for improvement on data sources and provide change proposals to management.
• Maintain manufacturing process and field reliability reporting tools and provide data for operational reviews and product failure investigations.
• Partner with cross-functional stakeholders to implement improvements and validate queries and reports for data completeness and accuracy.
• Recommend improvements to code to better identify and action signals from product reliability data.
• Ensure changes to IT systems address the impact on quality data reporting.

Education and Experience

• Bachelor's degree in Engineering, Computer Science, Business Intelligence, Data Analytics, Statistics, or a related field.
• 2-5 years of experience in programming, test engineering, business intelligence, or manufacturing quality roles.
• 2 or more years of experience with C#, VBA, Python, and MS Access programming.
• 2 or more years of experience using Power BI, Tableau, or a similar data visualization tool.
• Proficiency in working with large-scale datasets and fluency in SQL or MS Access for querying data.
• Knowledge of MS Excel advanced functionality and project management skills including problem solving and root cause analysis.
• Excellent analytical skills, strong written and oral communication skills, and the ability to manage multiple tasks in a high-pressure environment.

Accurate, well-governed reporting environments depend on the BI Specialist, who designs and manages data sources, security, and metadata while providing technical expertise on data storage structures, data mining, and master data management processes. Based within the IT team, the BI Specialist advises the Manager BI, supports data integrity initiatives, and trains end users on newly developed dashboards and analytical tools.

Accountabilities

• Align with business stakeholders on reporting, management information, and related requirements.
• Support and advise the Manager BI and contribute to the annual IT business plan.
• Design and manage the reporting environment including data sources, security, and metadata.
• Provide technical expertise on data storage structures, data mining, and data cleansing, and design the master data management process.
• Support data integrity and normalization initiatives and troubleshoot the reporting database environment.
• Assess, test, and implement new or upgraded software and assist with strategic decisions on system development.
• Develop dashboards, analysis tools, and train and support end users on new reports and capabilities.

Background and Experience

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

As the BI Specialist, this role develops self-serve data and reports in MicroStrategy, ensuring the validity and integrity of household and campaign reporting processes for Bell Residential Services, Mobility, and across Bell. The data and analytics team relies on this work to deliver timely, accurate solutions to business and marketing stakeholders while maintaining deep subject matter expertise on household marketing tools and technology infrastructure.

Areas of Ownership

• Develop self-serve data and reports in MicroStrategy.
• Communicate with business and marketing stakeholders to gather and assess requirements.
• Design and propose suitable solutions to business needs in collaboration with the team.
• Ensure the validity and integrity of household and campaign reporting processes.
• Respond promptly to ad-hoc requests from team members across business units.
• Investigate data and process anomalies and propose and implement solutions.
• Act as a subject matter expert on household marketing support with deep knowledge of tools and technology infrastructure.

Professional Experience

• Bachelor's degree in Computer Science, Mathematics, or equivalent from a recognized institution.
• Minimum 5 years of experience developing cubes and reports in MicroStrategy.
• Minimum 3 years of experience with Oracle, Unix, and NCR-Teradata, and EDW environments.
• Solid experience with SAS and PL/SQL programming and campaign tools such as Unica Campaign or IBM EMM.
• Advanced knowledge of MS Office including Excel, PowerPoint, and Word, and web programming including HTML, Java, ASP, and .NET.
• Knowledge of the telecommunications business is an asset.
• Highly rigorous with data accuracy, able to work independently, manage multiple projects simultaneously, and meet deadlines.

BI Specialist develops and implements Business Intelligence solutions within Agile teams, building interactive Power BI dashboards and automated data pipelines that support finance and business units across the organization. The work directly supports data warehousing governance, resource management, and the accelerated adoption of Power BI through coaching and training programs delivered to finance teams and business units.

Key Responsibilities

• Develop and implement BI solutions within Agile teams.
• Work with finance and business teams to gather and analyze requirements and deliver effective solutions.
• Provide business application analysis and data modelling design to collect, standardize, maintain, monitor, and audit business data.
• Create interactive dashboards and reports using Power BI and other BI tools.
• Develop and maintain processes for automated data pipelines using business intelligence reporting tools.
• Provide coaching and training support for finance teams and business units for faster adoption of Power BI reports.
• Support acceptance, governance, resource management, and performance of BI and data warehousing applications.

Required Qualifications

• 3 or more years of Business Intelligence experience, including 1 or more years developing enterprise-scale reports and dashboards in Power BI.
• Working knowledge of logical and physical data modeling concepts including relational and dimensional modeling.
• Hands-on experience in data visualization, dashboard design, and report development.
• Hands-on experience with relational databases, SQL, and DAX scripting and tuning.
• Understanding of data integration including data mining, preparation, validation, and cleaning.
• Basic knowledge of multidimensional cubes such as SSAS and their compatibility with Power BI.
• Experience with SAP BW and SharePoint as data sources, and Agile experience, are a plus.

The BI Specialist delivers multi-dimensional database models, data marts, data warehousing, and reporting solutions aligned with the BI strategy and roadmap, representing the data and analytics team to stakeholders across the business. Working closely with initiative owners, internal business units, and IT partners, the BI Specialist builds effective business relationships and responds to incidents and service requests to keep analytics operations running.

Core Functions

• Deliver BI solutions including multi-dimensional database models, data marts, data warehousing, data transformations, data analytics, and reporting solutions according to business requirements.
• Create innovative BI solutions through the practical application of the latest industry trends.
• Support requirements definition and delivery of programs and initiatives aligned with the BI strategy and roadmap.
• Understand stakeholder business needs and ensure appropriate solutions are delivered.
• Represent the data and analytics team to stakeholders through effective communication and collaboration.
• Respond to incidents and service requests and progress projects and solutions.

Qualifications and Experience

• Minimum 5 years of experience in Business Intelligence and data warehousing with exposure to corporate and enterprise systems.
• 5 or more years of hands-on Microsoft SQL Server developer experience including SSRS, SSIS, SSAS, and Power BI.
• Extensive SQL development skills and a solid understanding of key BI trends.
• Proven success in building and maintaining effective business relationships and understanding business needs.
• Strong negotiation, communication, and stakeholder influencing skills.

Reporting to the data platform lead, the BI Specialist develops effective data storage concepts, data architecture, and ETL programs across DWH, Big Data, and SQL or NoSQL environments to power business analytics and self-service reporting. Partnering with technical and business staff, the BI Specialist enables advanced analytics and data mining while training teams on database systems in a fast-paced Agile setting.

Primary Duties

• Design and develop effective data storage concepts and data architecture.
• Perform data modelling across DWH, Big Data, and SQL or NoSQL environments and lead data storytelling.
• Develop and program ETL concepts and create reports for business analytics and ad-hoc reporting.
• Enable self-service reporting and perform advanced analytics and data mining.
• Train and educate staff in the use of database systems.

Skills and Qualifications

• 3-5 years of experience in a comparable role.
• Degree in Computer Science, Computer Engineering, or a comparable field.
• Profound knowledge of database structure systems, preferably Power BI, and data mining.
• Experience thriving in an Agile environment with strong organizational and analytical skills.
• Strong interpersonal skills and experience in stakeholder management and project management.
• Fluent in English, with prior experience in dynamic and fast-paced environments such as start-ups or digital units.

Sitting at the intersection of customer experience analytics and Agile delivery, the BI Specialist produces insightful analysis from large datasets and communicates actionable recommendations that drive CX results for external and internal clients. Operating across internationally distributed teams, the BI Specialist promotes data-driven culture and influences adoption of Agile methodologies through creative problem solving and structured analytical thinking.

Duties

• Create insightful analysis from large datasets with minimum guidance.
• Communicate recommendations to drive CX results.
• Help design customer service product solutions for external and internal clients.
• Influence teams toward Agile methodologies.
• Inspire a more data-driven culture.

Experience and Qualifications

• Experience in BI, Strategic Planning, Consulting, or a start-up environment.
• Proficiency in SQL, with Python desired and experience with Tableau.
• Creative problem-solving and analytical thinking skills with excellent communication and organizational skills.
• Fluency in English for constant interactions with international teammates.
• Strong agility to balance speed with a structured and concise execution approach.

A key member of the BI development team, the BI Specialist builds and maintains Power BI solutions including calculated tables, custom visuals, and embedded analytics, alongside SSRS custom reports spanning tabular, drilldown, and parameterized formats. Collaborating across business and technical audiences, the BI Specialist implements row-level security, manages Power BI admin environments, and integrates reports into external applications via API automation.

Accountabilities

• Develop and maintain Power BI solutions including calculated tables, calculated columns, measures, and custom visuals.
• Design and develop custom reports including tabular, matrix, ad-hoc, drilldown, parameterized, and conditional reports using SSRS.
• Connect to multiple data sources, import data, and transform data for BI purposes.
• Implement row-level security on data and manage Power BI instances and environments within the Power BI admin centre.
• Create dashboards, KPIs, and interactive visuals including geographic data using Power BI Service.
• Integrate Power BI reports into other applications using embedded analytics and API automation.
• Develop automated operational reports and dashboards using Power BI, Power BI Report Builder, and SQL Reporting Services.

Background and Experience

• 3 or more years of experience in Business Intelligence including Power BI Desktop, Power BI Service, Power Automate, and Power BI Report Server.
• 3 or more years of experience in SQL or T-SQL, including creating complex custom views and ETL services.
• Experience with the MS BI Stack including MS SQL Server, Dataverse, SSIS, SSAS, and SSRS, and knowledge of Microsoft Azure and SQL data warehouse.
• Proficiency in DAX queries, Power Query, data modeling, and building Analysis Services reporting models.
• Familiarity with JavaScript, CSS, and other JavaScript libraries.
• Strong analytical thinking with the ability to translate data into informative visuals and reports.
• Willingness to learn new technologies and the ability to adapt to fast-changing skills and work.

As the BI Specialist, this role sets standards and processes for dashboard infrastructure and automates Power BI dashboards to minimize ETL work for Private Wealth business partners and executive stakeholders. The analytics team relies on this work to deliver measurement plans, data collection strategies, and statistical insights that uncover revenue growth opportunities and improve customer experience across wealth business lines.

Strategic Responsibilities

• Set standards and processes for the analytics team to ensure consistency and accuracy in dashboard infrastructure.
• Work with technology partners to set up dashboards linking data warehouses and automate Power BI dashboards to minimize ETL work.
• Investigate and identify data inconsistencies and gaps and communicate effectively with data engineering and business teams.
• Work with internal clients and stakeholders to understand business objectives and translate them into measurement plans and data collection strategies.
• Implement features such as row-level security, bookmarking, and cascading filters and manage user access and permissions across executive dashboards.
• Provide strategic recommendations to lines of business by interpreting data and participating in leadership presentations.
• Uncover opportunities to increase revenue or improve customer experience using statistical approaches across multiple data sources.

Minimum Qualifications

• Degree in Math, Computer Science, Engineering, Statistics, Actuarial Science, or a similar field.
• Master's degree in Data Analytics, MBA, Math, or similar is a nice-to-have.
• 2 or more years of experience using Power BI or a similar BI platform to deliver complex visuals.
• 2 or more years of proven experience working with SQL and large datasets.
• Experience implementing DAX calculations and MDX queries.
• Strong relationship-building skills, a passion for data analysis and trends, and the ability to work independently with a high degree of ownership.
• Strong verbal and written communication skills with the ability to present analytics data to senior management.

BI Specialist refines tabular and multidimensional models following industry best practices and leads Power BI training and support for power users across the organization. Success in the position means designing, developing, and testing Power BI solutions while working with analysts and data engineers to identify source data requirements and evaluate new technology solutions for delivery.

Key Deliverables

• Develop tabular and multidimensional models following industry best practices and design visual reports, dashboards, and KPIs in Power BI.
• Execute projects and lead Power BI training and support for power users.
• Publish and schedule automated refreshes per business requirements.
• Write queries to connect to different data sources and implement row-level security on data.
• Work with analysts and data engineers to identify source data system and business requirements for solution delivery.
• Participate in the investigation and selection of new technology solutions and consult on requirements and prototype building.
• Design, develop, and test Power BI solutions applying best practices in design, development, and data visualizations.

Education and Experience

• Bachelor's degree in Computer Science, Computer Engineering, or equivalent working experience.
• Knowledge of SQL queries, SSRS, and SSIS, with SQL Server experience including writing complex queries, ETL procedures, and database script automation.
• Proficiency in the MS Power BI suite including Power Query, M, and DAX, as well as working knowledge of Power Queries.
• Familiarity with BI technologies such as Microsoft Power BI, SAP BW or Hana, and Oracle BI, with knowledge of SAP BW Connector or SAP Hana advantageous.
• Knowledge of data warehouse design including dimensional modeling and data mining is preferable.
• Result-driven with the ability to handle multiple IT projects in a multicultural environment and adapt quickly to changing priorities.
• Proficient in English.

The BI Specialist delivers visual reports and dashboards using the Microsoft BI stack including SQL Server, SSIS, SSAS, and SSRS as part of a centralized metrics platform serving internal business stakeholders. Based within the data and analytics team, the BI Specialist extracts, transforms, and loads large data volumes, troubleshoots data issues, and conducts performance tuning to maintain accuracy and reliability across all BI outputs.

Day-to-Day Responsibilities

• Leverage the Microsoft BI stack including SQL Server, SSIS, SSAS, and SSRS to build and support solutions as part of the metrics platform.
• Collaborate with internal stakeholders to understand business requirements and deliver visual reports and dashboards using Power BI.
• Extract, transform, and load large volumes of data from internal and external sources to support business requirements.
• Capture, develop, and implement BI systems requirements and follow data standards to resolve data issues.
• Troubleshoot data issues, validate result sets, and recommend and implement process improvements.
• Schedule BI reports and dashboards and conduct performance tuning.

Technical Qualifications

• Degree in Computer Science, Information Technology, Engineering, or a related IT discipline.
• At least 5 years of related experience with past development experience in T-SQL.
• Familiarity with DAX queries and administering Power BI capacity.
• Strong problem-solving skills.
• Ability to work under pressure independently and as part of a team.

Embedded within a cross-functional analytics team, the BI Specialist defines, prototypes, and implements complex analytical solutions that transform transactional data into business insights, leading technical development of BI initiatives in close partnership with initiative owners. Working closely with business and data teams across multiple application systems, the BI Specialist drives efficiency and savings through innovative techniques grounded in industry best practices and Agile delivery.

Operational Focus

• Define, prototype, and implement complex analytical solutions to transform transactional data into meaningful business insights.
• Lead the technical development of complex BI initiatives and maintain constant communication and partnership with the initiative owner.
• Develop dashboards using industry-leading techniques and best practices from the BI community.
• Seek innovative and new techniques that drive increased efficiency and savings through effective utilization of data.
• Ensure analytical solutions are based on data that is defined, documented, and consistent with business rules.

Knowledge Skills and Abilities

• 5 or more years of BI, business, or data analytics experience in an enterprise environment across multiple application systems and business functions.
• Experience with BI tools such as Tableau, query databases such as SQL Server, and ETL tools such as Alteryx.
• Demonstrated success in data analysis, drawing conclusions, and suggesting improvements.
• Additional experience with analytical tools such as SPSS, SAS, R, or Python is desired.
• Experience with Agile methodologies and frameworks is a plus.

Reporting to the BI lead, the BI Specialist develops automated visual reports, KPI scorecards, and operational extracts using Power BI and other reporting tools while setting and maintaining BI standards across the organization. Partnering with finance and business teams, the BI Specialist translates functional requirements into reporting applications backed by a deep foundation in SQL, DAX, and data warehousing on platforms including Microsoft Azure and PolyBase.

Role Responsibilities

• Develop automated visual reports, dashboards, and KPI scorecards using Power BI and other reporting tools.
• Publish and schedule Power BI reports per business requirements.
• Develop operational reports such as project management and financial system extracts.
• Create and maintain BI standards within the organization.
• Understand business requirements to set functional specifications for reporting applications and manage design methodology and project documentation.

Experience and Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, or equivalent experience.
• 5 or more years of experience in analytics, data preparation, data gateway, and data warehousing projects.
• Minimum 3-4 years of experience with a self-service BI framework, preferably Power BI, Tableau, or Qlik.
• Experience in SQL, DAX, and M languages with deep understanding of relational and multidimensional database design.
• Expertise in secondary tools such as Microsoft Azure, SQL data warehouse, PolyBase, and Visual Studio.
• Skills in JavaScript, CSS, and other JavaScript libraries.

A key member of the pricing and commercial analytics team, the BI Specialist designs and builds visual analytical models in Tableau or Power BI to identify trends and deliver actionable pricing insights for tactical and operational decision-making. Collaborating across B2B and channel sales stakeholders, the BI Specialist delivers monthly, quarterly, and annual performance reports while crunching large, complex datasets to support business goals and pricing metrics.

Job Functions

• Design, develop, and build visual analytical models to identify trends, drill down using various measures, and weave a story using data.
• Develop and run required system reports, analyze and compile data, and report on progress and performance of systems and business activities.
• Create interactive dashboards and reports using Tableau or Power BI, crunching large and complex datasets to derive meaningful insights.
• Provide ad-hoc analysis to support the business with actionable insights for tactical and operational pricing actions.
• Deliver monthly, quarterly, and annual reports on time and regularly monitor and report performance insights to stakeholders.

Education and Experience

• Bachelor's degree in Engineering with a Master's in Business Administration (MBA - Marketing) from a reputable institution.
• 5 or more years of BI experience, preferably in Tableau or Power BI, with Tableau Certified Developer certification preferred.
• Experience as a BI developer in a large multi-cultural environment, preferably with a background in B2B and channel sales.
• Excellent written, verbal, and analytical skills.
• Fluency in English and knowledge of other languages.

BI Specialist turns data into actionable product insights, building dashboards and dynamic visualizations to monitor KPIs and highlight trends and user behaviour across key BI and analytics topic domains. The work directly supports product decision-making and competitive advantage, requiring fluency in SQL, Python analytics libraries, and cloud data tools, preferably on Azure, with hands-on proficiency in modern BI platforms such as Power BI.

What You'll Do

• Turn data into actionable insights about users to drive key product decisions.
• Create dynamic visualizations to highlight trends and user behaviour.
• Build dashboards and reports to monitor product KPIs.
• Organize and prioritize tasks of the BI and analytics roadmap.
• Hold responsibility for key BI and analytics topic domains and grow these as a competitive advantage.

Position Requirements

• 4-5 years of experience in the role.
• Solid experience with modern BI tools, preferably Power BI, product analytics, and data visualization tools.
• Fluency in SQL and Python data analytics libraries.
• Knowledge of at least one major cloud provider's data tools and architecture, preferably Azure, and knowledge of Microsoft T-SQL and SQL Server.
• Strong communication skills with a hands-on, highly self-driven attitude.