2027 Summer/ Winter Data Analyst

Altman Solon Campus•Boston, MA

14d•Hybrid

About The Position

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

Requirements

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

Responsibilities

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