Data Analyst and Developer

Role objective

Core responsibilities

• Gather, clarify, and document business requirements for reporting and analytical solutions.
• Design, develop, test, and maintain interactive dashboards, reports, data models, and visualizations using sanctioned tools.
• Write and optimize SQL queries to retrieve, combine, transform, summarize, and validate data.
• Analyze data and communicate trends, patterns, exceptions, and opportunities to users and leadership.
• Work with stakeholders to define KPIs, calculations, business rules, filters, and reporting needs.
• Validate report results, investigate discrepancies, and help resolve data-quality issues.

Testing, documentation, and support

• Identify opportunities to automate, standardize, consolidate, and improve manual reporting processes.
• Create and execute test plans for new reports, dashboards, enhancements, and corrections before release.
• Document data sources, report definitions, calculations, refresh schedules, testing results, and support procedures.
• Train and support report users and collaborate on systems, processes, data sources, and reporting capabilities.
• Follow company standards for data security, confidentiality, testing, change management, and documentation.

Education and experience

• A bachelor’s degree in a listed analytical, business, or technology field is preferred; equivalent education, training, certifications, and relevant experience may be considered.
• Two or more years of related professional experience is preferred.
• Professional experience developing and maintaining dashboards, reports, data models, or visualizations using company-sanctioned tools is required.
• SQL proficiency, relational database knowledge, and experience with Excel data analysis are required.
• Experience gathering business requirements, validating and reconciling data, and supporting production analytical solutions is required.

Preferred skills and capabilities

• Python or R experience for data preparation, statistical analysis, automation, or advanced analytics is strongly preferred.
• Experience with data transformation, ETL, automated refreshes, or data modeling is preferred.
• Familiarity with ERP, CRM, e-commerce, financial, sales, inventory, or other business systems is preferred.
• The role calls for analytical problem-solving, organization, time management, clear communication, initiative, accuracy, and collaboration.