Manager, Business Intelligence

Transamerica

Manager for Business Intelligence team at Transamerica, facilitating data architecture and reporting solutions. Leading and mentoring BI developers and analysts to drive business goals and decision-making.

Posted 6/18/2026full-timeCedar Rapids • Colorado, Iowa, Pennsylvania • 🇺🇸 United StatesJuniorMid-Level💰 $120,000 - $150,000 per yearWebsite

Tech Stack

Tools & technologies

CognosETLMS SQL ServerSQLSSIS

About the role

Key responsibilities & impact

Facilitate and manage activities of the Data and Analytics Business Intelligence team, supporting the ongoing development of technical architecture, self-service reporting solutions, and BI (Business Intelligence) deliverables.
Contributes to the strategic technical vision for the BI function and owns the delivery of scalable data and reporting solutions that drive Transamerica Retirement Solutions business goals and decision-making.
Lead 2-5 BI Developers and Analysts in the development of technical requirements and design solutions, owning the agile delivery of dashboards and data assets.
Support the execution of BI strategy, reporting standards, analytics processes, and aligned technical architecture practices.
Contribute to the ongoing development and improvement of BI architecture, data structures, and reporting frameworks.
Establish relationships with key business constituencies and serve as an advocate for BI deliverables across multiple departments and serve as a liaison between business and other technical areas.
Coach, mentor and train team members to establish a consistent level of quality, accuracy, accountability, and compliance of department standards.
Able to work closely with architects and business users to understand information requirements, model business concepts, and implement data structures and reporting tools and solutions.
Support evaluation and improvement of BI tools, platforms, and visualization capabilities to meet evolving business needs.
Help manage priorities, resources, and delivery plans for BI initiatives in alignment with departmental objectives.
Provide assistance on vendor analysis, selection, and review when necessary.
Identify and monitor ongoing staffing needs to meet department objectives.

Requirements

What you’ll need

Master’s degree in Computer Science; or Bachelors degree plus 2 years equivalent work experience.
2+ years of experience in full Microsoft BI Stack (SSIS,SSRS,SSAS)
Experience managing Enterprise Data Warehouse environments, including experience with database design, modeling, administration and optimization.
Experience leading and delivering full-cycle implementation projects related to Business Intelligence with software applications such as Microsoft SQL Server and IBM Cognos.
Experience in developing ETL processes for Data Warehouses/Data Marts.
Ability to train and mentor staff in the use of Data Warehouse and Business Intelligence systems.
Demonstrated track record of working directly with business and technical audiences alike.
Experience managing offshore staff.
Preferred Qualifications Power BI, Snowflake, and Dataiku experience is a plus.
Insurance Industry experience preferred.
Ability to anticipate future needs and challenges.
Has organizational and prioritization skills, effective judgment, and can make timely decisions with appropriate information.
Has a strong relationship building skill.

Benefits

Comp & perks

Competitive Pay
Bonus for Eligible Employees
Benefits Package
Pension Plan
401k Match
Employee Stock Purchase Plan
Tuition Reimbursement
Disability Insurance
Medical Insurance
Dental Insurance
Vision Insurance
Employee Discounts
Career Training & Development Opportunities
Health and Work/Life Balance Benefits
Paid Time Off starting at 160 hours annually for employees in their first year of service.
Ten (10) paid holidays per year (typically mirroring the New York Stock Exchange (NYSE) holidays).
Be Well Company holistic wellness program, which includes Wellness Coaching and Reward Dollars
Parental Leave – fifteen (15) days of paid parental leave per calendar year to eligible employees with at least one year of service at the time of birth, placement of an adopted child, or placement of a foster care child.
Adoption Assistance
Employee Assistance Program
Back-Up Care Program
PTO for Volunteer Hours
Employee Matching Gifts Program
Employee Resource Groups
Inclusion and Diversity Programs
Employee Recognition Program
Referral Bonus Programs

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Microsoft BI StackSSISSSRSSSASEnterprise Data Warehousedatabase designETL processesBusiness IntelligenceMicrosoft SQL ServerIBM Cognos

Soft Skills

coachingmentoringrelationship buildingorganizational skillsprioritization skillseffective judgmenttimely decision-makingcommunicationcollaborationadvocacy

Certifications

Master’s degree in Computer ScienceBachelor’s degree