BI Data Analyst

## BI Data Analyst Apply remote type:
On-Site locations:
Birmingham, AL, USAtime type:
Full time posted on:
Posted Todayjob requisition :
R26
*
* 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.  
• Performs other duties as assigned.
*
* 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.
** COMPANY INFORMATION:
** Motion Industries offers an excellent benefits package which includes options for healthcare coverage, 401(k), tuition, reimbursement, vacation, sick, and holiday pay.
#J-18808-Ljbffr