BI Data Analyst

About the role

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.

Responsibilities

• 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, and 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