Lead Business Intelligence Engineer

corpfollettexternal; Westchester (IL); On-site; USD 120,000 - 160,000; Full time

Job summary

Follett Higher Education is seeking a Lead Business Intelligence Engineer to design and implement scalable analytics solutions across the organization. You will partner with enterprise stakeholders to translate requirements into data-driven analytics, dashboards, and semantic layers that support critical decision-making.

The role requires strong ETL, data modeling, and communication skills, with experience in Agile environments and cloud platforms such as Azure and Google Cloud.

Qualifications

• Bachelor's degree or equivalent in a related field
• 7+ years designing and implementing end-to-end data analytics solutions
• Experience designing semantic layers for BI/Analytics
• Strong ETL and data pipeline expertise
• Experience developing actionable reports and dashboards
• Strong analytical and problem-solving skills
• Excellent communication and collaboration with stakeholders
• Experience with Agile methodologies
• Cloud experience (Azure and Google Cloud) a plus
• Experience in retail or education industries a plus

Responsibilities

• Design and implement end-to-end analytics solutions for the enterprise
• Build and maintain relationships with business users and IT leadership to capture requirements
• Create data dictionaries, mappings, and functional/technical documentation
• Perform data analysis and profiling to identify quality issues and coordinate with data owners to resolve them
• Stay current with industry trends and evaluate new technologies for potential use
• Support project planning, estimate development efforts, and manage timelines and resources

Skills

BI design & architecture

Data analytics

ETL pipelines

Dashboards & reports

Analytical problem solving

Communication skills

Agile methodologies

Cloud platforms (Azure, GCP)

Independent & collaborative work

Education

Bachelor's degree or equivalent

Tools

Azure Data Factory

Azure Data Lake Storage

Azure Databricks

SQL Server

SSIS

SSAS

SSRS

Power BI

Google Cloud Platform

Job description

Position Overview

Follett Higher Education is a leading educational service provider and omnichannel retailer, providing students, faculty, staff, parents, and fans with the course materials, learning tools, and retail services needed to successfully support the collegiate journey. Follett Higher Education supports over 6 million students through its 1,100 physical and 1,750 eCommerce campus stores across North America.

The Lead Business Intelligence Engineer is responsible for designing and implementing data analytics solutions that enable the organization to make data-driven decisions. This role works closely with enterprise stakeholders to identify requirements and then designs solutions that meet their needs.

Responsibilities

• Develop and implement end-to-end scalable and maintainable solutions using technologies such as Azure Data Factory, Azure Data Lake Storage, Azure Databricks, SQL Server, SSIS, SSAS, SSRS, and Power BI.
• Develop and maintain relationships with key stakeholders, including business users and IT leadership, to understand their requirements and design solutions that meet their needs.
• Develop data dictionaries, mapping, functional design, and other technical documentation.
• Perform data analysis and profiling to identify data quality issues and work with data owners to resolve them.
• Stay current with industry trends and emerging technologies and evaluate their potential use in the organization.
• Participate in project planning, including estimating development efforts and managing project timelines and resources.

• Bachelor's degree in a related field or equivalent.
• 7+ years of experience designing and implementing end-to-end data analytics solutions.
• Experience designing and implementing semantic layers for Business Intelligence and Analytics consumption.
• Strong understanding of ETL processes and data pipelines, and experience developing them.
• Experience developing actionable reports and dashboards.
• Strong analytical and problem-solving skills, with the ability to analyze complex data sets or business requirements and translate them into tangible solutions.
• Excellent communication and interpersonal skills, with the ability to work collaboratively with business stakeholders and technical teams.
• Experience in project management and Agile methodologies.
• Ability to work independently and as part of a team in a fast-paced, dynamic environment.
• Experience with cloud computing platforms, such as Azure and Google Cloud Platform.
• Data Analytics, Business Intelligence, and Cloud certifications are a plus.
• Experience working in the retail and education industries is a plus.