Data Analyst and Developer

Role overview

Responsibilities

• Gather and document requirements for reports, dashboards, data extracts, and analytical solutions.
• Develop, test, and maintain dashboards, reports, data models, and visualizations using company-sanctioned tools.
• Write and optimize SQL queries to retrieve, combine, transform, summarize, and validate data.
• Analyze trends, patterns, exceptions, and opportunities and communicate findings to users and leadership.
• Define KPIs and reporting rules with stakeholders; validate results and help resolve data-quality issues.
• Improve or automate reporting processes; create test plans and document data sources, calculations, refreshes, and support procedures.
• Train report users, collaborate across teams, and follow data security, confidentiality, testing, and change-management standards.

Required qualifications

• Demonstrated experience developing and maintaining dashboards, reports, data models, or visualizations with Carolina-sanctioned tools.
• Proficiency with SQL and relational database concepts, including joins, filters, calculations, and aggregations.
• Experience analyzing data with Excel, including formulas, pivot tables, charts, lookups, filtering, and data manipulation.
• Experience gathering business requirements, validating and reconciling data, and supporting production analytical solutions.

Preferred qualifications

• Related bachelor’s degree preferred; equivalent education, training, certifications, and relevant experience may be considered.
• Two or more years of related professional experience preferred.
• Python or R, ETL and data transformation, automated refreshes, or data modeling experience preferred.
• Familiarity with ERP, CRM, e-commerce, financial, sales, inventory, or other business systems preferred.

Skills

• Strong analytical, problem-solving, organizational, and time-management skills.
• Clear written and verbal communication, including explaining technical concepts to nontechnical audiences.
• Able to work independently and collaboratively, manage priorities, and maintain accuracy and attention to detail.