Data Analyst and Developer

Carolina-Biological; Whitsett (NC); On-site; USD 70,000 - 100,000; Full time

Job summary

Carolina-Biological in Whitsett, NC seeks a Data Analyst and Developer to transform data into actionable insights. You will build dashboards, reports, data extracts, and models across sales, inventory, finance, and operations.

Collaborate with business users and IT to define KPIs and data requirements, ensure data quality, and automate reporting where possible. The role requires 2+ years in BI or analytics, strong SQL, Excel, and familiarity with Python or R.

Qualifications

• Bachelor’s degree in Business Analytics, Information Systems, Computer Science, Data Analytics, Finance, Economics, Mathematics, Statistics, or related field preferred.
• Two+ years of experience in business intelligence, data analysis, reporting, database analysis, or related discipline.
• Proficiency with SQL and strong understanding of relational databases, joins, filters, and aggregations.
• Experience with Excel for data analysis including pivot tables, charts, and lookups.
• Experience with Python or R for data prep, analytics, or automation is preferred.

Responsibilities

• Gather and document business requirements for reports, dashboards, data extracts, and analytics.
• Design, develop, and maintain dashboards, reports, and data models.
• Write and optimize SQL queries to retrieve and transform data from enterprise sources.
• Analyze data to identify trends and communicate findings to stakeholders.
• Partner with stakeholders to define KPIs, calculations, and reporting requirements.
• Validate reports, investigate discrepancies, and support data quality efforts.
• Identify opportunities to automate and improve reporting processes.
• Develop and execute test plans for reports and dashboards before release.
• Maintain documentation for data sources, definitions, and schedules.
• Provide training and support to report users and collaborate with cross-functional teams.

Skills

SQL

Excel

Python

R

Data visualization

Dashboards

Education

Bachelor’s degree in Business Analytics

Tools

SQL Server

Power BI

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Analyst and Developer

Whitsett, NC, US

3 days ago Requisition ID: 1743

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:

• Two or more years of professional experience in business intelligence, data analysis, reporting, database analysis, or a related discipline preferred.
• Demonstrated professional experience developing and maintaining dashboards, reports, data models, or visualizations using Carolina's sanctioned tools is required.
• Proficiency with SQL and a strong understanding of relational databases, data relationships, joins, filters, calculations, and aggregations.
• Experience using Microsoft Excel for data analysis, including formulas, pivot tables, charts, lookups, filtering, and data manipulation.
• Experience gathering business requirements, validating data, reconciling results, and supporting analytical solutions in a production environment.
• Experience with Python or R for data preparation, statistical analysis, process automation, or advanced analytics is strongly preferred.
• Experience with data transformation, ETL processes, automated data refreshes, or data modeling is preferred.

Specialized Training/Skills:

• Strong analytical, problem-solving, organizational, and time-management skills.
• Strong written and verbal communication skills, including the ability to explain technical and analytical concepts to nontechnical audiences.
• Ability to work independently and collaboratively while managing multiple priorities and maintaining accuracy.
• High degree of initiative, analytical curiosity, accountability, attention to detail, and ownership.
• Familiarity with enterprise resource planning, customer relationship management, e-commerce, financial, sales, inventory, or other business systems is preferred.