Lead Business Intelligence Engineer

Follett Corporation; Westchester (IL); On-site; USD 40,000 - 141,700; Full time

Job summary

Follett Higher Education is a leading provider of educational services and omnichannel retail solutions. The Lead Business Intelligence Engineer will design and implement data analytics solutions to enable data-driven decisions, working closely with stakeholders to understand requirements and deliver scalable BI capabilities.

Responsibilities include building end-to-end data pipelines, developing semantic layers, and creating dashboards and reports.

Qualifications

• Bachelor's degree or equivalent.
• 7+ years designing and implementing end-to-end data analytics solutions.
• Experience designing semantic layers for BI/Analytics consumption.
• Strong ETL/data pipelines experience.
• Experience developing actionable reports and dashboards.
• Strong analytical and problem-solving skills; translate data to solutions.
• Excellent communication and collaboration with business and technical teams.
• Experience in project management and Agile methodologies.
• Cloud experience (Azure and Google Cloud) a plus.

Responsibilities

• Design and implement end-to-end scalable analytics solutions (Azure, SQL Server, Power BI).
• Build and maintain stakeholder relationships to capture requirements.
• Create data dictionaries, mappings, and functional designs.
• Profile data to identify quality issues and coordinate resolution.
• Stay current with industry trends and evaluate new technologies.
• Assist in project planning, estimating efforts, and timelines.

Skills

Data analytics

Stakeholder communication

Problem solving

Team collaboration

Agile methodologies

Education

Bachelor's degree

Tools

Azure Data Factory

Azure Data Lake Storage

Azure Databricks

SQL Server

SSIS

SSAS

SSRS

Power BI

Google Cloud Platform

Job description

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.

Requirements

• 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.

Pay Range

$40,000.00 - $141,700.00 / year

Pay Transparency

The annual salary/hourly rate range has been established based on the role, experience, skill set, and location. The exact starting salary/hourly rate within the range will depend on the role and the local market. This position may be eligible to participate in one of the Company’s incentive plans. The amount of any incentive payment varies and is subject to the terms and conditions of the applicable incentive plan.

We offer a comprehensive benefits package which includes medical, dental, vision, disability, wellness programs, 401(k) plan, flex spending, paid holidays, and paid time off. Eligibility for benefits is governed by the applicable policies and plan documents.

Equal Opportunity Employer. This company considers candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.

Follett Higher Education is a drug-free workplace environment.