Mole Street is an Elite HubSpot Solutions Partner and industry-leading technology and marketing consultancy. We are a fully remote agency with a presence in the U.S. and South America. Our clients consist of mid-market and enterprise B2B companies that partner with us to define strategies and execute programs that meet business objectives through technical and creative applications of the HubSpot platform.
We specialize in guiding our clients through digital transformation initiatives, including technical HubSpot consulting projects and growth-driven design programs.
Our culture is driven by the core values of Joy, Grit, Accountability, Clarity, Curiosity, Authenticity, and Growth Mindedness. The team is positive, passionate, rational, resourceful, resilient, and results-oriented. We take pride in collaborating with each client to implement strategies that will grow their company. We also believe that “Great Things are Happening!”
The team is positive, passionate, rational, resourceful, resilient and results driven, taking pride in the work and the people who do it. Employees are highly valued and dependable, driven to win for the collective good of the company and its clientele and dedicated to breaking the mold from the agency of the past into the agency of the future as Mole Street grows.
Mole Street is seeking a detail-oriented and strategic Senior Data Analyst who will transform complex datasets into actionable insights for clients and internal teams. In this role, you will design and implement data workflows that ensure accuracy, consistency, and scalability across projects. By combining strong technical expertise in SQL and Python with clear communication skills, you will support decision-making, improve data quality, and help drive digital transformation initiatives. Above all else, this person thrives in uncovering patterns, solving data challenges, and ensuring that Mole Street and its clients are equipped with reliable, insight-driven information to achieve their goals.
Day-to-Day Responsibilities(Examples – not exhaustive)
- Analyze large, often unstructured datasets from multiple systems to identify inconsistencies, gaps, and patterns.
- Design and implement data cleaning and transformation workflows to prepare datasets for migration.
- Map source attributes to target system fields, ensuring consistency and data integrity.
- Develop SQL queries and Python scripts to automate repetitive processes and perform bulk data transformations.
- Collaborate with consultants and project managers to ensure data deliverables meet project timelines and quality standards.
- Perform quality assurance checks post-migration to confirm data accuracy.
- Document processes, mappings, and transformation rules for internal and client use.
- Highly detail-oriented with a problem-solving mindset.
- Strong communicator who can explain complex data concepts to non-technical stakeholders.
- Comfortable working in fast-paced, project-based environments with tight deadlines.
- Proactive in identifying potential data issues before they impact project outcomes.
- Adaptable and resourceful in working with incomplete or messy datasets.
- Comfortable communicating, writing and presenting in English.
- 2–3+ years of professional experience in a data analyst or related role.
- Strong Foundation in SQL skills for querying, joining, and transforming data across large datasets.
- Python programming experience, particularly with libraries for data manipulation (e.g., Pandas, NumPy).
- Proven track record in data cleaning, attribute mapping, and large-scale data migration projects.
- Understanding of data structures, relationships, and normalization concepts.
- Experience collaborating with cross-functional teams to deliver data-driven solutions.
- Familiarity with APIs and data extraction processes.
- Experience working with HubSpot or other CRM platforms.
- Knowledge of ETL tools or automation platforms (e.g., n8n, Make, Zapier, etc.).
- Bi - weekly account meeting attendance - 10:30am-11:00am Monday
- Weekly Technology Department meeting attendance
- Availability on email, Slack, Zoom, and phone during working hours for connects with team
- Generous compensation package with performance incentives
- Full Health and Dental Insurance Coverage
- 401(k) with company match
- Paid maternity and paternity leave
- Flexible PTO
- The flexibility of working remotely
Top Skills
Similar Jobs
What you need to know about the Boston Tech Scene
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
