Intermediate Business Data Analyst

Transamerica•Cedar Rapids, IA

4d•Hybrid

About The Position

Responsible for measuring, analyzing, and reporting key performance indicators and operational performance for the Legal and Corporate Affairs team. The role prepares recurring and ad hoc reports and assists with analysis and presentations to support management and compliance reporting, inform business decisions, and identify process improvements. The analyst works with business data and statistical methods to identify trends, variances, and opportunities for improvement. The role also compiles, validates, and analyzes executive expense and corporate resource usage data, maintains supporting documentation, and prepares accurate reports. The analyst partners with stakeholders to clarify reporting needs, reconcile data, improve reporting processes, and help resolve technical issues affecting reports, queries, or visualizations. The position is based in a hybrid office environment and involves occasional travel of less than 10% to meet with internal and external stakeholders.

Requirements

Bachelor’s degree in a business-related field or equivalent experience.
Three years of experience in data analytics, process improvement, or other relevant work.
Understanding of data tools for visualization, extraction, modeling, CRM solutions, and SQL.
Analytical and problem-solving skills for analyzing and creating reports.
Communication and presentation skills for delivering reports and analysis.
Ability to multitask and work as part of a team in a dynamic and complex environment.
Proficiency using MS Office, including Word, Excel, and PowerPoint.

Nice To Haves

Background in the insurance or financial services industry.
Experience using Tableau, SQL, and Power BI.

Responsibilities

Prepare recurring reports on key performance indicators and operational performance for the Legal and Administrative Affairs team.
Analyze business performance using data and statistical methods, identifying trends, variances, and opportunities for improvement.
Compile, validate, and analyze data on executive expenses and use of corporate resources; maintain supporting documentation and prepare timely, accurate management and compliance reports.
Conduct ad hoc reporting and in-depth analysis, communicating findings and recommendations through reports and presentations to support process efficiencies and business decisions.
Maintain knowledge of the supported group’s business and systems; partner with stakeholders to clarify reporting needs, reconcile data, and improve reporting processes.
Assist in resolving technical issues, including report or query malfunctions, data discrepancies, and visualization stability or functionality problems.

Benefits

Competitive pay.
Bonus for eligible employees.
Pension plan.
401(k) match.
Employee stock purchase plan.
Tuition reimbursement.
Disability insurance.
Medical insurance.
Dental insurance.
Vision insurance.
Employee discounts.
Career training and development opportunities.
Paid time off starting at 160 hours annually for employees in their first year of service.
Ten paid holidays per year.
Holistic wellness program, including wellness coaching and reward dollars.
Paid parental leave for eligible employees with at least one year of service.
Adoption assistance.
Employee assistance program.
Back-up care program.
Paid time off for volunteer hours.
Employee matching gifts program.
Employee resource groups.
Inclusion and diversity programs.
Employee recognition program.
Referral bonus programs.