Business Intelligence Data Analyst
On-Site Role
Compensation: $70,000 - $75,000

ABOUT THE ROLE

Our client is seeking a Business Intelligence Data Analyst to design and develop software-based data models and visualizations using Business Intelligence (BI) tools. In this role, you will leverage analytical and programming skills to create end-to-end BI solutions that support departmental functions and drive data-driven decision-making. You will collaborate with stakeholders to understand data needs, develop and optimize data models, and ensure the accuracy, security, and usability of BI datasets, reports, dashboards, and visualizations. This position requires a forward-thinking approach to analytics, a passion for process improvement, and the ability to communicate complex insights effectively to leadership and cross-functional teams.

WHAT YOU'LL DO

• Design, develop, and maintain BI tool data sets, data models, reports, dashboards, and visualizations to support all departmental functions
• Optimize data models for business units and other departments, ensuring robust and scalable solutions
• Routinely meet with stakeholders to understand data needs and deliver tailored BI solutions, including dashboards, Python programs, and Excel/VBA reports
• Enhance business insights and decision-making with intuitive, value-added data visualizations
• Extract, transform, and model transactional data from ERP systems into reporting and analytics solutions
• Coordinate the incremental creation and structuring of QVD files from disparate data sources
• Identify impactful layouts and presentations of key performance metrics in user-friendly, self-service dashboards
• Partner with IT to develop and implement security standards for BI applications and sensitive financial data
• Build and maintain relationships with cross-functional leaders to improve processes, documentation, and adoption of world-class practices
• Proactively seek opportunities to increase business knowledge and create organizational visibility
• Generate and implement new ideas to streamline processes and drive operational efficiencies
• Establish and enforce best practices for data modeling and visualization, ensuring data accuracy and integrity
• Independently manage multiple responsibilities concurrently, demonstrating reliability and attention to detail
• Perform other duties as assigned

WHAT YOU BRING

• Bachelor's degree in information systems or related field, or equivalent combination of education and experience
• 3-5 years of related work experience in business intelligence or data analysis
• Proficiency with Microsoft Office Suite
• Advanced SQL skills and experience with a variety of relational databases
• Experience designing and developing data models, reports, dashboards, and visualizations using BI tools
• Strong analytical skills with the ability to propose positive business solutions
• Knowledge of database design techniques
• Proficiency in Python, R, or other statistical platforms preferred
• Excellent written and oral communication, including presentation skills
• Strong organizational skills, attention to detail, and the ability to manage multiple priorities
• Ability to collaborate and build relationships with cross-functional teams and management at all levels
• Professional presence with strong interpersonal skills, including the ability to influence and challenge decisions and processes
• Forward-thinking approach to implementing tools and techniques that improve analytics and drive better business decisions
• Self-motivated, results-driven, and able to work independently as well as within a team
• BI tool certification preferred