Weekend Excel Vba Jobs in Alabama (NOW HIRING)

Job Summary:
Motion Industries is seeking a Business Intelligence Data Analyst who will design and develop software-based data modeling and visualizations using BI tools. The role involves building data models, conducting variance analysis, and enhancing decision-making through robust data visualizations.
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.
Qualifications:
Required:
• Typically requires a bachelor's degree in information systems and three (3) to five (5) years of related work experience or an equivalent combination.
• 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.
Preferred:
• Proficiency in Python, R, or other statistics platform
• BI tool certification
Company:
Motion serves the industrial marketplace with MRO (maintenance, repair, and operation) replacement parts and services through a network of over 600 locations across North America. Founded in 1931, the company is headquartered in Port Arthur, USA, with a team of 5001-10000 employees. The company is currently Late Stage.