Business Intelligence Lead

Job Title: Business Intelligence Lead

FLSA Status: Exempt

Department: Information Technology

Reports to: Manager, Business Analysts

GENERAL DESCRIPTION / PURPOSE:
This position will build and maintain reporting & insights systems that support business requirements. The ideal candidate has a strong background in identifying solutions amidst large and complex data sets and the ability to transform insights into strategic opportunities. The role will be charged with centralizing, analyzing, and translating essential business data into actionable insights. The successful candidate will be deft at open-ended problem solving, data analysis, and interpreting results into easily digestible formats – particularly through well-organized dashboards and automated reports.

The BI Lead position requires strong data hands-on skills and experience as well as establishing close business relationships and stakeholders across the operations, manufacturing, sales and marketing organizations.

ESSENTIAL JOB FUNCTIONS:
Lead the efforts of the BI team by defining direction and applying best practices and tools.

Design, develop and maintain the reporting infrastructure using the various reporting stacks including SQL, WebFocus, and Tableau.

Lead the efforts for platform documentation, version controlling, and production releases.

Utilizes understanding of multiple data structures and sources to design, develop and implement decision support solutions, including data visualization, business intelligence, or data collection.

Conducts research and analysis of business situations to contextualize and summarize data for end users.

Examining key business data by identifying, cleaning, and providing analysis and insights.

Validating data fidelity and creating data where none currently exists.

Building dashboards, tools, and other data models to help visualize or monitor progress in areas like performance marketing, sales, ETF trading volume, and/or website engagement.

Providing ongoing data mining efforts to identify trends and areas for improvement.

Generating insights and presenting findings to senior management using data visualization and presentation programs to suggest business recommendations.

Supporting ad hoc analyses and reports needed for business decisions, planning, and execution.

Project Management

Provide expertise to create project charter, scope, and requirements, initiate, plan, execute.

Direct and coordinate activities of project personnel to ensure project progresses on schedule and budget.

Review status reports prepared by project personnel and modify schedules or plans as required.

BEHAVIORAL COMPETENCIES:
Action Oriented

Courageous Decision Making

Facilitating Change

Passion for Results

Planning and Organizing

Problem Solving

REQUIRED QUALIFICATIONS:
Education:
Bachelor’s Degree in math, data science, or related quantitative field

Experience:
5+ years working in a business analytics role

Advanced expertise in SQL, SSIS, SSRS, and SSAS (multi-dimensional and tabular)

2+ years Project Management activities (create scope, requirements, define tasks)

• Or equivalent combination of education and experience

PREFERRED QUALIFICATIONS:
Experience:
IFS ERP Experience

WebFocus Experience

Tableau Experience

WORKING CONDITIONS:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the role. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Office deskwork, requiring sitting, walking, using phone & computer.
May lift up to 30 lbs. occasionally.
Occasional travel, possibly including international .
Can tolerate variable and sometimes challenging conditions during visits or inspections of company equipment in a railroad environment.
#LI-KK1
#LI-HYBRID