Business Intelligence Analyst Intern - Summer 2023 (Des Moines, IA)

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Title: Business Intelligence Analyst Intern - Summer 2023

Location: Des Moines, IA; Sioux Falls, SD or Chicago, IL

Job Summary:Support the Life Data Strategy initiative that involves transitioning to and maximizing the use of platforms including: PowerBI Cloud, Snowflake and Salesforce. Assist the Product Owner and members of the Life Business Intelligence and Advanced Analytics team to load/connect to data in Snowflake, present the data in PowerBI/Excel, and provide broad support to the team on tasks including: documentation, testing/validation, production support, and business intelligence (cause-and-effect analysis). Candidates familiar with Data Science concepts would also spend a portion of their time supporting Machine Learning models.

Essential Functions:

  • Power BI Development
    • Replicating Power BI reports across companies or specific requests utilizing the same Data Set
  • Documentation
    • Creation and maintenance of a "Notes" tab for every report that would define all attributes, metrics and calculations used for current and future reporting
    • Editing requirements documents
    • Best practice documentation for creating dashboards, pipeline deployment, view creation, etc
    • Performing Data Lineage tasks
    • Aid in scribing for meetings and collecting / communicating action items
    • Assist in Report cataloguing in Axon
  • UAT
    • Perform testing of tables inside of Snowflake against source systems (UAT env and higher)
    • Assistance in testing of views and mild development work
    • Snowflake to Tableau CRM validation (and vice-versa)
  • General
    • Follow up on tickets
    • Assist in Marketing Communications Email reporting requests


  • Excel Functions: Vlookup / Index Match (single and multiple criteria), PIVOT Table experience
  • Basic SQL
  • Data Science or Computer Programming track (Python / R language) optional
  • Experience with the Microsoft Office suite (Including OneNote and Visio)
  • Analytical capabilities
  • Experience with PowerBI / Tableau preferred

Internship Program:

Our Internship program is designed to give students experience with projects and performing tasks within their hired work area. You will be exposed to other areas within the organization by participating in development, culture and volunteer events. This paid internship is 8-10 weeks in length with the possibility of extending hours into the school year.
More Information on Sammons Financial Group Companies
Sammons Financial Group Companies operates in the Fintech industry. The company is located in West Des Moines, IA, Chicago, IL, Sioux Falls, SD and Fargo, ND. Sammons Financial Group Companies was founded in 2022. It has 1001 total employees. It offers perks and benefits such as Flexible Spending Account (FSA), Disability Insurance, Dental Benefits, Vision Benefits, Health Insurance Benefits and Life Insurance. To see all 23 open jobs at Sammons Financial Group Companies, click here.
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Similar Jobs

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Sammons Financial Group Companies's full profileFind similar jobs