Manager, Business Intelligence

About Us

At Transamerica, hard work, innovative thinking, and personal accountability are qualities we honor and reward. We understand the potential of leveraging the talents of a diverse workforce. We embrace an environment where employees enjoy a balance between their careers, families, communities, and personal interests. Ultimately, we appreciate the uniqueness of a company where talented professionals work collaboratively in a positive environment — one focused on helping people look forward and plan for the best life possible while providing tools and solutions that make it easier to get there.

We believe everyone deserves to live their best life. More than a century ago, we were among the first financial services companies in America to serve everyday people from all walks of life. Today, we’re part of an international holding company, with millions of customers and thousands of employees worldwide. Our insurance, retirement, and investment solutions help people make the most of what’s important to them. We’re empowered by a vast agent network covering North America, with diversity to match. Together with our nonprofit research institute and foundation, we tune in, step up, and are a force for good — for our customers and the communities where we live, work, and play. United in our purpose, we help people create the financial freedom to live life on their terms.

Transamerica is organized into three distinct businesses: 1) World Financial Group, including Transamerica Financial Advisors, 2) Protection Solutions and Savings & Investments, comprised of life insurance, annuities, employee benefits, retirement plans, and Transamerica Investment Solutions, and 3) Financial Assets, which includes legacy blocks of long-term care, universal life, and variable and fixed annuities. These are supported by Transamerica Corporate, which includes Finance, People and Places, General Counsel, Risk, Internal Audit, Strategy and Development, and Corporate Affairs, covering Communications, Brand, and Government and Policy Affairs. Transamerica employs nearly 7,000 people and is part of Aegon, an integrated, diversified, international financial services group serving approximately 23.9 million customers worldwide.

About the Role

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.

Responsibilities

• 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, acting 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 with department standards.
• 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

• Master’s degree in Computer Science; or Bachelor’s 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.
• Strong organizational and prioritization skills, effective judgment, and ability to make timely decisions with appropriate information.
• Strong relationship-building skills.

Schedule

Hybrid-Office Environment (Tuesdays, Wednesdays, Thursdays in one of our hub locations: Philadelphia, PA; Cedar Rapids, IA; Denver, CO).

Pay

The salary for this position generally ranges between $120,000 - $150,000 annually. Actual starting pay is determined by several factors including qualifications, experience, geography, work location designation (in-office, hybrid, remote), and operational needs. Salary may vary above and below the stated amounts, as permitted by applicable law. Additionally, this position is typically eligible for an Annual Bonus based on the Company Bonus Plan and individual performance, at the Company’s discretion.

Benefits

• Compensation Benefits:
  • Competitive Pay
  • Bonus for Eligible Employees
  • Pension Plan
  • 401k Match
  • Employee Stock Purchase Plan
  • Tuition Reimbursement
  • Disability Insurance
• Health and Insurance Benefits:
  • Medical Insurance
  • Dental Insurance
  • Vision Insurance
• 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, including 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.
  • Adoption Assistance
  • Employee Assistance Program
  • Back-Up Care Program
  • PTO for Volunteer Hours
  • Employee Matching Gifts Program
• Additional Benefits:
  • Employee Discounts
  • Career Training & Development Opportunities
  • Employee Resource Groups
  • Inclusion and Diversity Programs
  • Employee Recognition Program
  • Referral Bonus Programs