Family, innovation and culture are some of the key words that you will hear when people talk about the VGM Group. A Top Workplace in Iowa and 100% employee owned, the VGM Group is looking to add to our growing VGM Insurance Services team. VGM Insurance Services, a vital division of the VGM Group, specializes in Product and Professional Liability Insurance to Home Care dealers throughout the United States.

As a mid-level data analyst, your primary responsibility will be to ensure that VGM Insurance Services and its leaders have quality, meaningful, relevant, accurate and actionable information on which to make key business decisions. The ideal candidate will be able to acquire, structure, manage, visualize and report on critical company data. Utilizing a creative and service-oriented approach to working with data to meet team and business user information needs, the Data Analyst 2 is responsible for extracting, transforming, and visualizing data for reporting and analysis as directed by the Business Analyst.

Reports to : Director of Business Analytics, directly and Senior VP of Information Systems, indirectly

Location :   Waterloo, Iowa- onsite or hybrid

Working Hours : Full-time, Monday-Friday

As a Data Analyst 2 with VGM Insurance Services, a typical day might include :

• Create reports, presentations, dashboards, insights and analytics
• Produce ad-hoc datasets and reports using SQL and other industry technologies to fulfill data requests
• Perform research and assist in analyzing data
• Develop or update existing Tableau dashboards
• Create and maintain daily, weekly, monthly, quarterly and annual datasets, reports and visualizations
• Apply mathematical routines and formulas to provide summarized information
• Maintain a high level of proficiency in business analytics and emerging trends related to the position
• Complete other data, systems and I.T. oriented activities as an active member of the Systems team
• Monitor and upgrade analytics software such as : Tableau server / desktop, Enterprise Data Warehouse, or RedGate
• Execute annual audit and decommissioning process for existing reporting objects
• Deliver of cross-divisional analytics initiatives
• Mentor newer employees
• Organize and run meetings surrounding analytic engagements such as : First looks of dashboards / research projects, task prioritization or requirements gathering

You have :

We have :

Work Conditions

This job description reflects the general duties of the job but is not a detailed description of all duties which may be inherent to the position. Reasonably related additional duties may be assigned to the individual Associate.

VGM Group, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.