BI Data Analyst

Genuine Parts Company•Birmingham, AL

About The Position

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.

Requirements

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

Nice To Haves

Proficiency in Python, R, or other statistics platform preferred
BI tool certification preferred

Responsibilities

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
Performs other duties as assigned