OBJECTIVE / PURPOSE
The Business Intelligence Analyst supports the company’s business operations and growth strategies by transforming data into accurate, accessible, and actionable information. This position works with business users and Information Services team members to understand reporting needs and develop dashboards, reports, queries, data extracts, and analytical solutions.
The analyst will work with data from enterprise applications and other approved business systems to provide insight into sales, customers, products, inventory, financial performance, operations, and other key business areas. This position will also help improve data quality, reporting consistency, and access to information across the organization.
The analyst takes day to day direction from the Lead Application Developer.
MAJOR RESPONSIBILITIES AND FUNCTIONS
- Gather, clarify, and document business requirements for reports, dashboards, data extracts, and analytical solutions.
- Design, develop, test, and maintain interactive dashboards, reports, data models, and visualizations using company sanctioned tools.
- Write and optimize SQL queries to retrieve, combine, transform, summarize, and validate data from enterprise databases and approved data sources.
- Analyze business data to identify trends, patterns, exceptions, and opportunities, and clearly communicate findings to business users and leadership.
- Partner with stakeholders to define key performance indicators, calculations, business rules, filters, and reporting requirements.
- Validate report results, investigate discrepancies, and assist with resolving data quality issues.
- Identify opportunities to automate, standardize, consolidate, or improve manual reporting and analytical processes.
- Develop and execute test plans for new reports, dashboards, enhancements, and corrections before production release.
- Maintain documentation for data sources, report definitions, calculations, refresh schedules, testing results, and support procedures.
- Provide training and support to report users and collaborate with cross-functional teams on new systems, processes, data sources, and reporting capabilities.
- Follow company standards for data security, confidentiality, testing, change management, and documentation.
POSITION REQUIREMENTS
Education: Bachelor’s degree in Business Analytics, Information Systems, Computer Science, Data Analytics, Finance, Economics, Mathematics, Statistics, or a related field preferred. An equivalent combination of education, professional training, certifications, and relevant work experience may be considered.
Experience: