Position Title: Data Analyst
Location: South Portland, ME
Reports To: Chief Operating Officer
Position Summary: The Data Analyst will utilize a generalist data analytics skillset to significantly impact S&W’s internal business reporting, generate quantitative research content, and improve CRM processes & data accuracy. This is an important role in the execution of several S&W strategic initiatives (inbound lead generation, creating & improving proprietary data sets, and modernizing business intelligence & reporting practices).
Key Responsibilities:
- (30%) In conjunction with the COO, analyze, summarize, & interpret large data sets for internal and external use using Excel, PowerBI, & PowerPoint
- (25%) Capture, clean, organize, & integrate open-source data into proprietary data sets for S&W research & marketing projects
- (25%) CRM – Report on end user adherence to CRM data entry standards & enhance historical data to reach this standard
- (10%) Performing one-off analyses at the request of the COO or S&W leadership
- (10%) Maintain an accurate & timely record of business metrics
Qualifications:
- Bachelor’s degree in a relevant field (e.g., Data Science, Business Analytics, etc.) or 2+ years of relevant job experience
- Proficiency in at least one modern programming language (e.g., Python, R, etc.)
- Advanced Excel skills, including vlookup, pivot tables, and compound formulas (if, sumif, countif)
- Familiarity with Business Intelligence tools (e.g., Tableau, Power BI)
- Familiarity with PowerPoint for data presentation and reporting
Preferred Skills:
- Experience writing Python script for web scraping
- Basic knowledge of statistics and data visualization techniques
- Ability to work independently and juggle multiple initiatives simultaneously
Personal Attributes:
- A team player who communicates proactively and delivers on deadlines
- Strong analytical and problem-solving skills
- Integrity, strong work ethic, & a growth mindset
