Data Analyst

Homesteaders Life Company; West Des Moines (IA); Hybrid; USD 52,000 - 72,000; Full time

Benefits offered by this job

Excellent schedule with early Fridays

401(k) with company match

Company-sponsored medical and dental insurance

Company-paid long-term disability

Job summary

A leading life insurance firm is seeking a Sales Administration Specialist to provide analysis and reporting for the sales department. Responsibilities include running SQL reports, managing dashboards, and assisting with data for presentations. Candidates should have a degree, 2+ years of experience, and proficiency in SQL and Microsoft Office. The company offers excellent benefits, including a hybrid work environment and 401(k) with a match. This is an opportunity to contribute to a well-established company's success.

Qualifications

• Bachelor’s degree preferred, associate's degree required.
• 2+ years of relevant experience in sales, agency, or business analysis.
• Proficiency in SQL Reporting and Microsoft Office applications required.
• Advanced proficiency with Microsoft Office (Word, Excel, PowerPoint, Outlook).

Responsibilities

• Run reports in SQL and provide Excel reports to management.
• Act as SME for sales reporting needs, gathering necessary information.
• Manage company dashboards, ensuring data accuracy and relevance.
• Assist with gathering data for PowerPoint presentations.
• Track and process payments for business partners.
• Process various department expenses and support tasks.
• Process expenses and provide department support as needed.

Skills

SQL Reporting

Microsoft Office applications

Data analysis

Office Proficiency

Education

Associate's degree

Bachelor’s Degree in Computer Science or Business Administration

Tools

SQL Management Studio

Report Builder

Power BI

Job description

As a Sales Administration Specialist, you will apply knowledge of the needs of the sales department, customer reporting, and systems technology to provide analysis and reporting and insights. You will analyze report requirements, data sources, and user requirements and recommend possible solutions to meet needs. Provide oversight and management of company dashboards with a team.

Your responsibilities will include:

• Running existing reports in SQL and providing excel reports to management. Review reports for accuracy, and trends in a time bound capacity.
• Acts as SME for sales reporting needs. First point of contact with business partners to gather necessary information for reporting needs.
• Provide on-going review and management of dashboards. Includes a disciplined review of data accuracy and relevance, recommending adjustments and updates, and proactively promoting their utilization to end users.
• Assist business partners with gathering and inputting data from various internal sources to ensure accurate PowerPoint presentations for various meetings.
• Track and process payments for business partners ensuring timely and accurate payments. This includes identifying and communicating missed payments.
• Gathers information to input into PowerPoint presentations, and various agreements.
• Processes various expenses, administration and additional support tasks for department as needed.

Requirements

• Bachelor’s Degree in Computer Science, Business Administration or other related area preferred, associate's degree required.
• 2+ years of experience in sales, agency, marketing or business analyst or some combination required.
• Proficiency in the use of SQL Reporting including SQL Management Studio and Report Builder or Power BI is desirable.
• Demonstrated proficiency at an advanced level in the use of Microsoft Office applications (Word, Excel, PowerPoint, and Outlook).

Pay and Benefits Summary

Our benefits include:

· An excellent schedule – office closes at 1 p.m. every Friday

· 401(k) with company match with discretionary contribution

· Company-sponsored group medical and dental insurance

· Company-paid long-term disability

· Hybrid work environment

About Homesteaders

Homesteaders Life Company, a mutual company owned by its policy holders, is a national leader providing products and services to help people design a better farewell. Founded in 1906, Homesteaders is known for secure preneed funding and innovative solutions that help funeral and end-of-life professionals and consumers connect with each other.

We are currently not hiring in Arizona, Connecticut, California, Massachusetts, Oregon, Colorado, Montana, New York, Illinois, Minnesota, and Washington.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time