Senior Business Analyst in Cedar Rapids, Iowa at Auxiant

https://www.auxiant.com/

Auxiant’s Mission Statement and Core Values

Mission:
An Independent TPA investing in People and Innovation to deliver expert-driven experiences with REAL Results.

Core Values: Independent Solutions. REAL Results
Respect
Empowerment
Agility
Leadership

Be part of a growing and prospering company as a Senior Business Analyst. Auxiant is a third party administrator of self-funded employee benefit plans with offices in Cedar Rapids, IA, Madison and Milwaukee, WI. Auxiant is a fast-growing,progressive company offering an excellent wage and benefit package.

Job Summary:

Collaborate with stakeholders both inside and outside our growing organization to streamline business processes, strengthen data integrity and empower informed decision making

Essential Functions:

• Act as a technical resource across operational divisions to drive business efficiencies
• Balance new and legacy tool sets to maintain a reliable data pipeline
• Influence enterprise data architecture expansion and diversification
• Design and execute recurring data integrity audits
• Visualize solutions to complex problems
• Deliver accurate, timely reporting to peers and clients
• Apply mathematical and statistical methods to business problems
• Evaluate healthcare costs and savings achieved through our FocusHealth transparency product
• Analyze data to support health plan decision making for our clients
• Contribute to the design, development and maintenance of proprietary software
• Communicate with business partners to define and securely exchange data
• Demonstrate organized and effective project management skills

Nonessential Functions:

• Other duties as assigned or appropriate

Education/Qualifications:

• Bachelor’s degree with concentration in Business and/or Computer Science related field(s)
• 5+ years of business analytics, health care administration or like industry experience
• Advanced SQL skills
• Experience developing and maintaining stored procedures
• Familiarity with ETL/ELT concepts and related tools like dbt
• Ability to translate complex data into visuals using Grafana, Tableau, etc.
• Experience using Microsoft Office products to generate queries, macros, forms and reports
• An understanding of health care delivery and insurance practices
• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group of executives, managers, customers and employees

Full benefits including: Medical, Dental, Vision, Flexible Spending, Gym Membership Reimbursement, Life Insurance, LTD, STD, 401K, 3 weeks vacation, 9 paid holidays, casual dress code and more