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