BI Data Analyst

deploy; Birmingham (AL); On-site; USD 80,000 - 110,000; Full time

Job summary

deploy is seeking a BI Data Analyst for an on-site role in Birmingham, Alabama. The candidate will design and develop BI data models and visualizations to support data-driven decision-making, partnering with stakeholders to deliver proactive, value-added analytics.

The role involves building dashboards, performing variance analysis, and developing executive-level reports. Strong SQL, Python or R skills and experience with BI tools are required to deliver robust insights across the organization.

Qualifications

• Typically requires a bachelor's degree in information systems and 3–5 years of related work experience or equivalent.

Responsibilities

• Designs and develops BI data models and visualizations.
• Builds should-cost models for categories using commodity indices, labor, transport and overheads.
• Monitors raw material and input costs; supports supplier price increase logic.
• Maintains the Procurement Gains Tracker with savings, cost avoidance and rebates by wave and category.
• Creates strategic fact packs with market sizing, supplier concentration, pricing benchmarks and share of wallet.
• Performs variance analysis to identify margin leakage, supplier underperformance or pricing gaps.
• Develops executive dashboards and reports for reviews and transformation updates.
• Responsible for end-to-end BI data set design, data models, reports, dashboards and visualizations.

Skills

Advanced SQL

Python

Excel

VBA

Data visualization

Analytical thinking

Education

Bachelor's degree in information systems

Tools

QVD files

ERP systems

Relational databases

Job description

DEPLOY has been retained by a leading industrial parts distributor for an on site role in Birmingham, Alabama. We are looking for a BI Data Analyst.

SUMMARY:

The Business Intelligence Data Analyst designs and develops software-based data modeling and visualizations with Business Intelligence (BI) tools.

This role utilizes various analytical and programming skills to develop BI solutions and supports leadership by designing proactive, value-added data models to provide insight into data driven decision-making

JOB DUTIES:

Builds should-cost models for key categories based on commodity indices, labor, transportation, and overheads.

Monitors raw material and input costs (e.g., steel, rubber, oil) and supports supplier price increase challenge logic.

Manages the Procurement Gains Tracker, ensuring accurate documentation and alignment of savings, cost avoidance, and rebate realization by wave and by category.

Supports Category Managers in building strategic fact packs including market sizing, supplier concentration, pricing benchmarks, and share of wallet.

Conducts variance analysis to identify margin leakage, supplier underperformance, or pricing gaps.

Builds executive-level dashboards and bridges for category reviews and transformation updates.

Responsible for end-to-end design and maintenance of BI tool data sets, data models, reports, dashboards and visualizations in support of all department functions.

Designs, develops and optimizes data models for the business unit and other departments.

Routinely meets with various stakeholders to understand their data needs. Develops solutions and processes to fulfill requirements. This typically includes BI dashboards, Python programs, or Excel/VBA reports.

Enhances business insights and decision making with robust, intuitive data visualizations.

Leverages transactional data from enterprise resource planning (ERP) applications to extract, transform and model into reporting and analytics solutions.

Coordinates incremental creation and structure of QVD files from disparate data sources.

Identifies the most impactful layout and presentation of key performance metrics in easy to use self-service dashboards.

Partners with the IT team to develop security standards for BI applications and usage of QVD files containing sensitive financial information.

Partners and develops relationships with cross-functional leaders to improve processes and documentation, and recommends changes that lead to the adoption of world class processes.

Proactively seeks out opportunities to increase business knowledge and create visibility within the organization.

Generates new ideas to streamline processes and collaborates with other departments to create operational efficiencies.

Establishes and implements best practices for data modeling & visualization. Ensures data accuracy.

EDUCATION & EXPERIENCE:

Typically requires a bachelor's degree in information systems and three (3) to five (5) years of related work experience or an equivalent combination.

KNOWLEDGE, SKILLS, ABILITIES:

• Proficient with Microsoft Office Suite.
• Advanced SQL and experience with a variety of relational databases.
• Strong analytical skills and the ability to propose positive business solutions.
• Reliability, organization and attention to detail.
• Excellent written and oral communication, including presentation skills.
• Knowledge of database design techniques and advanced SQL skills required.
• Proficiency in Python, R, or other statistics platform preferred.
• Professional presence with excellent interpersonal skills, including the ability to interact with management at corporate and department levels.
• Forward-thinking in implementing tools and techniques to improve analytics, driving better business decisions. Self-motivated and able to independently manage multiple responsibilities concurrently
• Ability to collaborate within a team, managing team dynamics and relationships.
• Strong partnership skills, across all levels of management, with ability to influence and challenge decisions and processes.
• Driver of results, developer and influencer of peers.

LICENSES & CERTIFICATIONS:

BI tool certification preferred.