Altman Solon Campus

2027 Summer/ Winter Data Analyst

Altman Solon Campus Boston, Massachusetts, United States · $99K/yr

Business Consulting and Services · 501-1,000 employees

9 h ago
data-analyst Junior (0-2 yrs) Internship United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The intern will convert complex business logic into SQL queries and build datasets by integrating disparate data sources. They will also collaborate with analysts and data scientists to create advanced visualizations and report on data quality issues.

What they look for

SQL Python R Data analysis Tableau Apache Hadoop Hive Teradata Spark BigQuery ArcGIS Geospatial mapping Data visualization Communication skills Problem solving Quantitative analysis

Requirements

Candidates must be undergraduate or master's students graduating in late 2027 or 2028 with a strong academic record in a quantitative field. Proficiency in programming languages like SQL, Python, or R and strong analytical and communication skills are required.

Benefits

Flexible work programs Sabbaticals Internal rotations Extended parental leave

Full description

Summer/ Winter Data Analyst Internship

Altman Solon is a strategy consulting group that focuses exclusively on the telecommunications, media and technology (TMT) related sectors. As the largest global TMT strategy firm, we assist clients in fast, high-impact, confident decision making. We enable clients to seize new opportunities, improve performance, and increase shareholder value within complex and converging industries.

Trusted Leader with Industry Expertise and Innovative Approaches

  • As the leading pure play communications and media strategy consulting group globally, we assist operating companies and financial groups in fast, high-impact, confident decision making
  • Deep industry knowledge and advanced analytics allow us to develop more actionable insights and recommendations, delivering better advice, more quickly – we succeed in building long-term client relationships because of the results we deliver
  • Altman Solon’s industry focus and shorter average project duration allow employees to quickly gain exposure to a breadth of projects and develop an expertise in TMT along with a sophisticated consulting toolkit

Growing Firm with an Entrepreneurial Spirit & Inclusive Culture

  • The size of our organization allows our employees to constantly experience new challenges and growth opportunities while building relationships with senior Altman Solon team members who are recognized experts in their field
  • We realize work/life fit is important to our staff. Our default schedule is a low-travel model, accelerating our staff‘s professional growth and helping them build meaningful relationships with peers and mentors. Eligible employees can design their own or choose from an array of flexible work programs, such as reduced work year, sabbaticals, internal rotations, and extended parental leave.

Flat Teams, Collaborative Philosophy, Personalized Support

  • We offer staff strategic projects and client interaction at an earlier stage than generalist consulting firms, with opportunities to truly own a piece of work from start to finish
  • Our small size, collaborative culture, and tailored approach to learning and development results in faster role advancement and professional growth throughout your career with us

As a Summer/Winter Data Analyst at Altman Solon, you will gain exposure to strategy consulting. The Winter Internship runs from January to March and the Summer Internship program runs for 10 weeks from June to August in our Boston, MA and New York, NY offices. While the specific role will vary from project to project, responsibilities include:

  • Convert complex business logic into SQL queries across our multiple internal databases as well as client databases we are staffed to work on
  • Build and maintain datasets for consulting teams by pulling together disparate data sources
  • Identify and report potential data quality issues
  • Collaborate with Analysts and Data Scientists to effectively tie the data insights to client questions
  • Work with big data technologies including Redshift, Apache Hadoop, Hive, Teradata, Spark, and BigQuery
  • Use tools like Tableau, Python Jupyter Notebooks, and ArcGIS to create advanced visualizations including complex geospatial maps and interactive dashboards

The Summer and Winter Analyst roles are open to undergraduate students who are on track to graduate in December 2027 or spring of 2028 and to Masters degree students on track to graduate in December 2027 or spring of 2028.

We are looking for:

Problem solvers with analytical minds and strong communication skills

  • Motivated to use strong quantitative and analytical skills to solve problems in dynamic industries that require innovative solutions
  • Strong academic record
  • Pursuing a degree in a related field (Computer Science, Math, Statistics, Economics, MIS or related IT/Engineering field preferred)
  • Experience working with programming languages (SQL, Python, R preferred)
  • Ability to translate complex problems into structured, manageable concepts and approaches
  • Ability to effectively communicate complex ideas and concepts via verbal, written, and visual means

Team players with a commitment to producing outstanding work

  • Enjoy working with teams and working independently as required
  • Dedication to producing high-quality output with integrity and exceptional attention to detail
  • Excited about the prospect of contributing to internal firm life and culture
  • Passion for learning and interest in TMT industry, with ability to absorb information quickly and effectively and a growth mindset

Location: Boston, MA, New York, NY

Compensation: $1,900 per week

We believe that diversity, equity, and inclusion are key principles for the successful operation of any business, and especially ours. We are committed to ensuring that all employees, at all levels, feel supported, feel a sense of belonging, and are equally invested in the success of our shared work. This starts with ensuring that we draw the most talented people from all backgrounds. If your access to educational or extracurricular opportunities has been impacted by factors you would like to make us aware of, please include this information in your cover letter if you choose to submit one.

Altman Solon is an Equal Opportunity Employer and E-Verify user. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veteran status, or other protected status.

Our offices utilize a hybrid work model and this role will be expected to be in the office on a regular basis.

Please note, we are unable to provide sponsorship for employment visa status for this role. Please see below for additional information regarding sponsorship:

  • If your responses regarding your work authorization and/or sponsorship needs are inconsistent between your application and the information you provide us at any point thereafter, Altman Solon reserves the right to discontinue consideration for employment. (E.g. if you note in your application that you do not require sponsorship, but upon receiving an offer you inform the firm that you will require sponsorship at any point, the firm reserves the right to discontinue consideration for employment.)
  • Please note: both H1-B and TN are visas that require employer sponsorship

Application Instructions:

In addition to your resume, please submit a cover letter and transcript if applicable.

Similar roles