Logo of Huzzle

Data Analytics Intern (Hybrid - Summer 25)

  • Internship
    Full-time
    Summer Internship
  • Data
    IT & Cybersecurity
  • Lehi
    Remote

AI generated summary

  • You must be skilled in SQL and Excel, with experience in databases, data extraction, transformation, visualization, and ideally a background in tech, math, or finance. U.S. work authorization required.
  • You will build ETL processes, design star schema tables, create reports and dashboards, collaborate with clients and senior consultants, and follow structured learning paths in technology solutions.

Requirements

  • Must be experienced with SQL and Microsoft Excel
  • Experience with these and related technologies is preferred:
  • Databases – e.g., Snowflake, SQL Server, Microsoft Fabric
  • Data extraction – e.g., APIs, Airflow, ADF, SSIS
  • Data transformation – e.g., SQL, dbt, Python, Star Schema
  • Data visualization – e.g., Power BI, Tableau
  • Data science – e.g., Microsoft CoPilot, Databricks
  • Having a strong background in technology, mathematics, statistics, accounting, finance, or other quantitative discipline is preferred
  • Must be authorized to work in the United States now or in the future without sponsorship

Responsibilities

  • Build ETL processes to extract data from multiple sources, apply transformations, and load into data warehouses
  • Leverage Kimball Method (Star Schema) to build fact and dimension tables
  • Build reports and dashboards in visualization technologies
  • Interact directly with clients from various industries to provide analysis needed to make important decisions
  • Collaborate with senior analytics consultants on various client projects
  • Follow structured learning paths for all our Technology Solutions offerings including data analytics, data integrations, IT, cyber security, and Salesforce development, NetSuite development, and Microsoft development

FAQs

What is the duration of the internship?

The internship will last from May to August.

What majors are preferred for this internship?

Preferred majors include Management Information Systems, Computer Science, and related fields.

Where are the internship locations?

The internships are available in Lehi, Phoenix, Fargo, Denver, Fort Collins, Sioux Falls, or Billings.

What is the pay for the intern position?

Interns in technology consulting are paid $25.00 per hour and are eligible for overtime.

Are interns eligible for any benefits?

Yes, interns are eligible for health insurance and 401(k) Profit Sharing.

What type of work will interns be doing?

Interns will work on real client projects, build ETL processes, create reports and dashboards, and collaborate with senior analytics consultants.

What skills are required for this position?

Candidates must have experience with SQL and Microsoft Excel, and familiarity with technologies related to data extraction, transformation, and visualization is preferred.

Is prior work experience required for this internship?

No prior work experience is explicitly required, but having a strong background in technology, mathematics, statistics, or other quantitative disciplines is preferred.

Will interns have the opportunity to interact with clients?

Yes, interns will interact directly with clients from various industries to provide analysis needed for important decisions.

What kind of learning opportunities are available for interns?

Interns will follow structured learning paths covering various areas, including data analytics, IT, cybersecurity, and development in different platforms.

What kind of company culture can interns expect at Eide Bailly?

Interns can expect a people-first culture centered around respect, integrity, support, and work-life integration, with opportunities for social activities and a focus on personal growth.

Is there any support for career development?

Yes, interns will be paired with an Eide Guide and a Career Advisor to help with acclimation and career development.

Are there opportunities for social activities during the internship?

Yes, the firm organizes various social activities such as happy hours, food trucks, competitions, and more to foster connection among employees.

Is sponsorship required for employment eligibility?

No, candidates must be authorized to work in the United States now or in the future without sponsorship.

What inspires you, inspires us.

Accounting
Industry
1001-5000
Employees
1917
Founded Year

Mission & Purpose

We’re Eide Bailly (I’d bay-lee), a business advisory, accounting and technology firm built with our clients in mind. Our goal is your success and we’re here to help you every step of the way. What inspires you, inspires us.