Manager, Business Intelligence

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. Contribute to the strategic technical vision for the BI function and own 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.

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. This position is typically eligible for an annual bonus based on company and individual performance.

Schedule

Hybrid-office environment requiring three days in office per week (Tuesdays, Wednesdays, Thursdays) in one of the following hub locations: Philadelphia, PA; Cedar Rapids, IA; Denver, CO.