Sr. Business Intelligence Developer

Responsibilities

The Sr. Business Intelligence Developer will be responsible for data Integration, and support the development of reporting and dashboards, utilizing various operational data sources. This position reports to the Director, Data Analytics and will collaborate with business stakeholders, business leaders, and subject matter experts in understanding their reporting needs and integrate data from various sources to support development of Business Intelligence (BI) solutions such as reports, dashboards, and self-service apps. This role will also collaborate with other IT staff, and an extended team of offshore resources to meet the delivery objectives.

As the Sr. Business Intelligence Developer, you will:

• Gather and prepare data from various actuarial, operational, product development, and other systems to support reporting and analytics
• Design, develop, and support automated reports and dashboards using SSRS, Tableau, and other reporting tools
• Support the development and enhancements of data repositories, data marts, and analytics cubes
• Support ad-hoc reporting and data extract requests
• Design and/or develop database objects (databases, tables, stored procedures, SSIS Packages) to support the collection, tracking and reporting of business data
• Provide consultative support by answering questions about the available data and the data that is possible to capture from the third-party systems
• Assist with best practices during implementation and integration of the various reporting tools
• Provide input to project planning, status and review meetings.
• Perform unit and integration testing, and participate in reporting validation and QA efforts as they pertain to reporting and data analytics
• Provide support for miscellaneous data projects and initiatives
• Participate in strategic planning around future development and integration of data from various operational sources to support the reporting needs of the business

Qualifications 

• Bachelor’s degree (preferred emphasis in computer science or MIS)
• Minimum 5 years of experience in IT and business intelligence
• Minimum 2 years of experience creating advanced reports using Microsoft SSRS, Tableau, and Excel
• Minimum 3 years of experience with SQL Server 2012 or higher
• Expert level experience designing/developing data integrations using various data sources
• Experience working with Business Intelligence solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures
• Experience writing complex SQL queries and strong knowledge of SQL
• Experience developing complex Tableau applications with powerful visualization

Work Environments

F&G believe in a employee-centric hybrid work arrangement. This role offers the ability for in-office, hybrid (blending both office and remote work in a typical workweek), and remote work arrangements. You’ll work with your leader to determine which option may align best based on several factors