Ascensus→
Data Analyst Intern at Ascensus in Newton, MA
InternshipHybridNewton, MA$42k–$42k/yr
Skills
data analysissqlexceldata visualizationpythonrdata modelingdata warehousing
Job Description
Summary: Ascensus is the leading independent technology and service platform powering savings plans across America. They are seeking a Data Analyst Intern to support the Retirement Operations team by transforming data into meaningful insights that inform business decisions while gaining hands-on experience with real-world datasets and analytics tools.
Responsibilities:
- Assist in collecting, cleaning, and validating data from internal and external sources to ensure data quality and accuracy
- Support analysis of datasets to identify trends, patterns, and opportunities for operational or business improvement
- Help build and maintain dashboards, reports, and visualizations used by leadership and cross‑functional teams
- Partner with analysts and business stakeholders to understand data needs and help define metrics and KPIs
- Contribute to the development and documentation of data models, data dictionaries, and standard reporting definitions
- Perform ad hoc analyses to support business questions and ongoing initiatives
- Assist with tracking performance metrics and supporting regular reporting cycles
- Collaborate with data engineering, IT, and analytics teams to learn how data pipelines and infrastructure are managed
- Follow established data governance, privacy, and security standards
Required Qualifications:
- Currently pursuing a Bachelor's degree in Data Analytics, Statistics, Mathematics, Computer Science, Economics, or a related field (or recent graduate)
- Strong interest in data analysis, analytics, or business intelligence
- Exposure to SQL or relational databases through coursework, projects, or internships
- Familiarity with Excel (basic to intermediate formulas, pivot tables, data analysis concepts)
- Ability to analyze data, think critically, and solve problems
- Strong attention to detail and willingness to learn
- Ability to communicate findings clearly to both technical and non‑technical audiences
Preferred Qualifications:
- Exposure to data visualization tools such as Power BI, Tableau, or Alteryx
- Coursework or project experience using Python or R for data analysis
- Familiarity with basic data modeling or data warehousing concepts
- Interest in financial services, retirement plans, or a highly metrics‑driven industry
- Experience working on academic, personal, or team data projects
Required Skills: Data Analysis, SQL, Excel, Data Visualization, Python, R, Data Modeling, Data Warehousing