yandex
merceradvisors
Страна
США
+500% приглашений

Откликайтесь
на вакансии с ИИ

Ускорим процесс поиска работы
InternУдалённоКонтракт

Growth Analytics, Intern

Оценка ИИ

Отличная возможность для старта карьеры в престижной компании с сильной корпоративной культурой и структурированной программой обучения. Предлагается широкий пакет льгот, даже для стажеров, и возможность удаленной работы.


Вакансия из Quick Offer Global, списка международных компаний
Пожаловаться

Сложность вакансии

ЛегкоСложно
Оценка ИИ

Это позиция начального уровня для студентов. Основные требования включают базовые навыки работы с Excel и понимание воронки продаж, что делает ее доступной для кандидатов без обширного опыта.

Анализ зарплаты

Медиана55 000 $
Рынок45 000 $ – 65 000 $
Оценка ИИ

Зарплата не указана в вакансии, но для летних стажировок в сфере аналитики данных в США рыночный диапазон обычно составляет от 20 до 35 долларов в час. Указанные рыночные значения отражают годовой эквивалент для начинающих специалистов в финансовом секторе.

Сопроводительное письмо

I am writing to express my interest in the Growth Analytics Intern position at Mercer Advisors. As a student with a strong foundation in data analysis and a keen interest in digital marketing strategy, I am eager to contribute to your Direct to Consumer Acquisition team. Your firm's reputation as a top-ranked RIA and your commitment to a fiduciary standard align perfectly with my professional values and desire to work in a high-impact environment.

During my studies, I have developed proficiency in Excel and data visualization, which I am excited to apply to real-world marketing-sales funnel analysis. I am particularly drawn to this internship because of the opportunity to work on cross-functional projects involving A/B testing and competitive analytics. I am confident that my attention to detail and analytical mindset will allow me to provide valuable insights that support Mercer Advisors' strategic growth initiatives.

+250% к просмотрам

Составьте идеальное письмо к вакансии с ИИ-агентом

Составьте идеальное письмо к вакансии с ИИ-агентом

Откликнитесь в merceradvisors уже сейчас

Начните свою карьеру в аналитике роста в одной из ведущих финансовых компаний США — подайте заявку на летнюю стажировку прямо сейчас!

Описание вакансии

Why Work at Mercer Advisors?

For 40 years, Mercer Advisors has worked with families to help them amplify and simplify their financial lives. How? By integrating financial planning, investment management, tax, estate, insurance, and more, all managed by a single team. Today we proudly serve over 31,300 families in more than 90 cities across the U.S. Ranked the #1 RIA Firm in the nation by Barron’s, we are an independent, national fiduciary legally obligated to always act in the best interest of our clients.\*

Mercer Advisors offers a distinct work environment that stands out in the financial industry. Our overall employee base and client-facing team are composed of 50% women, reflecting our commitment to diversity. We attract top talent from across the country, with no formal headquarters and flexible working arrangements, allowing us to assemble the best team possible.

Join us and be a part of a team dedicated to making a meaningful impact on the financial lives of families across the country.

\* Mercer Advisors was ranked #1 for RIA firms with up to $70 billion in assets. The Barron’s top RIA ranking is based on a combination of metrics – including size, growth, service quality, technology, succession planning and others. No fee was paid for participation in the ranking, however, Mercer Advisors has paid a fee to Barron’s to use the ranking in marketing. Please see important information about the ranking criteria methodology here.

Job Summary:

As a Growth Analytics intern, you will work with the Direct to Consumer Acquisition team on cross-functional analytical projects bringing valuable business insights to inform strategy. Applicants should have strong verbal and written communication skills with background or interest in digital marketing strategy & full-funnel analytics.  The successful applicant will enjoy working in a dynamic, fast-paced environment.  Your 10-week long summer internship will be filled with opportunities for professional development, mentorship, the chance to apply coursework to real-world experiences, and some fun, too!

Essential Job Functions for the Internship will include:

  • Assist with strategic projects such as competitive analytics and A/B testing to support decision-making.
  • Conduct outside-in research to identify industry best practices, benchmarks, and strategic opportunities for growth.
  • Assist in collecting, cleaning, and analyzing marketing and sales data to identify trends and insights
  • Collaborate with cross-functional teams (Marketing, Client Development, Product, etc.) to provide data-driven insights & recommendations.
  • Other duties as needed

Required Knowledge, Ability and Skills

  • Must be enrolled in a Bachelors (as a rising Sophomore, Junior, or Senior) or Master’s program
  • High attention to detail and analytical ability to work with large datasets accurately, including strong data validation and cleanup skills
  • Understanding of a marketing-sales full funnel, including lead journey and key metrics
  • Ability to work with cross-functional stakeholders and drive projects forward
  • Proficiency in Microsoft Excel and PowerPoint to generate and synthesize insights
  • Excellent written and verbal communication skills to present insights clearly
  • Bonus: Proficiency in Salesforce (e.g., creating dashboards & reports in Sales Cloud) and/or PowerBI (filtering, creating visualizations, updating formulas and backend tables)

Work Schedule

8:00am to 5:00pm local office time

Working Conditions

 Professional office environment. Working inside, siting, standing. Will be assigned to a work station.

Benefits:

Mercer Advisors offers a competitive and robust benefit package to our employees.   Our benefit programs are focused on meeting all of our employees and their eligible dependents health and welfare needs. We offer the following:

  • Company Paid Basic Life & AD&D Insurance
  • Company Paid Short-Term and Long-Term Disability Insurance
  • Supplemental Life & AD&D; Short-Term Disability; Accident; Critical Illness; and Hospital Indemnity Insurance
  • Three Cigna medical plans offerings including two High Deductible Health Plans and a Traditional Co-Pay medical plan.
  • Kaiser Medical plans available in California
  • Health Savings Account (HSA) with company contributions if enrolled in either HDHP medical plan.
  • Two comprehensive Dental Plans
  • Vision Insurance Plan
  • Dependent Care Savings Account for child and dependent care.
  • 14 Company Paid Holidays including a full week off at Thanksgiving.
  • Generous paid time off program for vacation and sick days
  • Employee Assistance Plan
  • Family Medical Leave
  • Paid Parental Leave (8 weeks)
  • Maternity benefits utilizing company paid STD, any supplemental STD, plus Parental Leave (8 weeks) to provide time for recovery, baby bonding, and enjoying your family time.
  • Adoption Assistance Reimbursement Program
  • Company Paid Concierge Services for you and your loved ones for the spectrum of caring needs for your aging parents, young children, life’s challenges and more.
  • 401(k) Retirement Plan with both Traditional and Roth plans with per pay period match as well as an after-tax option
  • Pet Insurance

We are not accepting unsolicited resumes from agencies and/or search firms for this job posting.

Mercer Advisors is an equal opportunity employer and does not discriminate on the basis of any characteristic protected by applicable federal, state, or local law. Mercer Advisors participates in E-Verify and complies with federal employment eligibility verification requirements.

If you need an accommodation during the application or hiring process, please email PeopleTeam@merceradvisors.com. *This inbox is for accommodation requests only.*

For information about applicant rights, required employment notices, E-Verify participation, and state specific disclosures, please review our Applicant Notices and Employment Rights.

If you are a resident of California, learn more about Mercer's California Consumer Privacy Policy here.

CCPA Notice at Collection

+400% к собеседованиям

Создайте идеальное резюме с помощью ИИ-агента

Создайте идеальное резюме с помощью ИИ-агента

Навыки

  • Data Analysis
  • Microsoft Excel
  • A/B Testing
  • Salesforce
  • Data Visualization
  • Microsoft PowerPoint
  • Power BI
  • Digital Marketing Strategy
  • Competitive Analysis

Возможные вопросы на собеседовании

Проверка понимания ключевых концепций маркетинговой аналитики, упомянутых в описании.

Как бы вы определили основные этапы воронки продаж 'маркетинг-продажи' и какие метрики важны на каждом этапе?

Оценка технических навыков работы с данными, необходимых для стажировки.

Опишите ваш опыт работы в Excel: какими сложными функциями или инструментами (например, ВПР, сводные таблицы) вы владеете для очистки и анализа данных?

Проверка способности мыслить стратегически и проводить конкурентный анализ.

Если бы вам поручили провести конкурентный анализ для Mercer Advisors, на каких ключевых показателях или аспектах их стратегии вы бы сосредоточились?

Оценка навыков командной работы и коммуникации в кросс-функциональной среде.

Расскажите о случае, когда вам нужно было объяснить сложные данные человеку, который не является экспертом в этой области. Как вы подошли к этой задаче?

Проверка интереса к инструментам, указанным в качестве бонуса.

Есть ли у вас опыт работы с Salesforce или PowerBI, и как вы использовали эти инструменты для визуализации данных или создания отчетов?

Похожие вакансии

NDA
300 000 ₽ – 320 000 ₽

Data аналитик Senior

SeniorУдалённоРоссия
MS SQL · ClickHouse · Power BI · Yandex DataLens · Airflow · Python · SSIS · Azure Data Factory · Databricks · DAX · ETL · DWH
+12 навыков
Самолет
200 000 ₽ – 250 000 ₽

Продуктовый аналитик (middle)

MiddleУдалённоРоссия
SQL · ClickHouse · DataLens · Yandex Metrica · GitLab · A/B Testing · Product Metrics · GrowthBook
+8 навыков
Smartis
150 000 ₽ – 210 000 ₽

Аналитик данных

MiddleУдалённоРоссия
SQL · MySQL · ClickHouse · ETL · Python · Data Analysis · Marketing Analytics
+7 навыков
ensono
3 466 $

Project Portfolio Data Analyst Intern

InternУдалённоСША
Python · R · Power BI · Tableau · SQL · Excel · Machine Learning · Data Visualization · Data Analysis · Scikit-learn · TensorFlow · Azure ML
+12 навыков
NDA
202 318 ₽ – 357 000 ₽

Data аналитик (Senior)

SeniorУдалённоРоссия
MS SQL · ClickHouse · Yandex DataLens · Power BI · Apache Airflow · Python · SSIS · Azure Data Factory · Databricks · DAX · ETL · DWH · Azure SQL Server · Yandex Cloud
+14 навыков
impiricus
4 333 $

Intern - Data Analytics

InternУдалённоСША
Excel · Google Sheets · SQL · Data Visualization · Data Analysis · Statistics · Mathematics · Business Analytics
+8 навыков
более 1000 офферов получено
4.9

1000+ офферов получено

Устали искать работу? Мы найдём её за вас

Quick Offer улучшит ваше резюме, подберёт лучшие вакансии и откликнется за вас. Результат — в 3 раза больше приглашений на собеседования и никакой рутины!

merceradvisors
Страна
США