Intern, Software Engineer - Business Intelligence (Summer 2023)
Summary
Join F&G as a Summer 2023 intern and gain relevant experience, professional development and incredible networking at a growing company. The Software Engineer (Business Intelligence) Intern work with other Analytics and Data Management team members. Supports the Actuarial team in a variety of tasks around data analysis, data exploration, report dashboarding, and data prep.
Organization
This position reports directly to the Analytics and Data Management Team and interacts with other members of the Actuarial organization.
Internship Activities
Listed below are some of the different data governance and analytical activities that the intern may be asked to do.
- Obtain an understanding of data processes and business data needs
- Meet with business users to discuss data shortfalls and gather business requirements to set functional specifications for reporting applications
- Assist with developing automated reports and dashboards using Tableau, SQL Server Management Studio, Excel and other reporting applications
- Clearly convey key insights or the “story” the data reveals in a visual format that is grouped, summarized, or formatted to be easily understood and with a clear call to action
- Work with developers to automate reports and processes
- Work with team members to document and apply Tableau best practices and the life cycle of a dashboard at F&G
- Utilizing applications such as Alteryx, create ETL processes to load and extract data from various data sources to support information analytics
- Assist Tableau Server users with problem resolution and report access questions
Experience & Education Requirements
- Pursuing Associate’s or Bachelor's Degree in Computer Science, Information Science, Information Systems, Computer Engineering, Data Science
- Student with a 3.0 GPA or above
- Experience with operating systems and commercial software (MS Office, Adobe, etc.)
- Understanding of data prep and dashboarding principles including; visualization, parameters and report optimization
- Strong understanding of SQL development with the ability to write complex SQL queries
- Customer and results oriented
- Strong technical documentation ability
- Strong verbal communication skills and a demonstrated ability to work effectively in team-based development projects
- Excellent oral and written communication skills
- Knowledge of Tableau Software is preferred
- Experience with Life Insurance and Indexed Annuity data preferred
Skills and Abilities
A successful candidate will possess the following skills and abilities:
- Highly motivated, self-starter and team player with high energy level and willingness to take on responsibility
- Relationship building, collaboration and situational leadership skills
- Strong analytical and problem-solving skills
- Ability to complete duties timely and accurately with minimal supervision
- Ability to communicate clearly, concisely, and transparently – both verbal and written
Work Environments
F&G believes in an employee-centric flexible environment, which is why we offer the ability for in-office, hybrid and remote work arrangements. During the hiring process, you'll work with your leader to decide what works best for your role.
Join our employee-centric hybrid work environment: fglife.com/about/culture.html
About F&G
Since 1959, Fidelity & Guaranty Life Insurance Company (F&G) has offered annuity and life insurance products to those who are seeking security in retirement and protection during life’s unexpected events.
As an Iowa Top Workplace1 and a proud equal opportunity employer, F&G employees are empowered, collaborative, dynamic and authentic. We believe that by embracing these values, we will continue to build and strengthen the company, while continuing to be a great place to work.
1Des Moines Register Top Workplaces 2018-2021.
Link: https://topworkplaces.com/company/fidelity-guaranty-life/desmoinesregister/