2027 Summer/ Winter Data Analyst

Altman Solon is a global strategy consulting group focused exclusively on the telecommunications, media, and technology sectors. The Summer/Winter Data Analyst Intern will support strategy consulting projects by querying and building datasets, identifying data quality issues, collaborating on data insights, and creating advanced visualizations using big data and analytics tools.

What you'll do:

• 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

What they're looking for:

• 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
• 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
• 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
• 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

Benefits:

• Our default schedule is a low-travel model
• 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.
• Employees constantly experience new challenges and growth opportunities while building relationships with senior Altman Solon team members who are recognized experts in their field
• Opportunities for professional growth and faster role advancement through tailored learning and development
• Our offices utilize a hybrid work model