BI Dashboard Analyst & Data Developer

Carolina Biological Supply Company; North Carolina; On-site; USD 65,000 - 95,000; Full time

Job summary

Carolina Biological Supply Company is seeking a Data Analyst and Developer in Whitsett, NC. The role focuses on transforming data into actionable information, building dashboards, reports, and data extracts to support sales, customers, and operations.

The position requires two+ years in BI/data analysis, strong SQL skills, and experience with Python or R. Collaboration with business users and IS teams is essential to improve data quality and reporting consistency.

Qualifications

• Bachelor’s degree preferred in a quantitative field or equivalent experience.
• Two+ years of professional BI/data analysis experience.
• Proficiency with SQL and understanding of relational databases, joins, filters, calculations, and aggregations.
• Experience with Excel for data analysis including pivot tables, charts, lookups, and data manipulation.
• Experience with Python or R for data preparation, analysis, or automation is strongly preferred.

Responsibilities

• Gather, clarify, and document business requirements for reports, dashboards, data extracts, and analytical solutions.
• Design, develop, test, and maintain dashboards, reports, data models, and visualizations using sanctioned tools.
• Write and optimize SQL queries to retrieve, transform, and validate data from enterprise sources.
• Analyze business data to identify trends, patterns, and opportunities; clearly communicate findings to stakeholders.
• Partner with stakeholders to define KPIs, calculations, business rules, and reporting requirements.
• Validate report results, investigate discrepancies, and assist with data quality issues.
• Identify opportunities to automate, standardize, or improve manual reporting and analytics processes.
• Develop and execute test plans for new reports and dashboards before production release.

Skills

SQL

Data visualization

Dashboard design

Python

R

Excel

Education

Bachelor's degree in Business Analytics, Information Systems, Computer Science, Data Analytics, Finance, Economics, Mathematics, Statistics, or related field

Tools

Tableau

Power BI

SQL databases

Job description

Carolina Biological Supply Company is seeking a Data Analyst and Developer in Whitsett, NC. The role focuses on transforming data into actionable information, building dashboards, reports, and data extracts to support sales, customers, and operations.

The position requires two+ years in BI/data analysis, strong SQL skills, and experience with Python or R. Collaboration with business users and IS teams is essential to improve data quality and reporting consistency.