Business Intelligence Developer

Financial Data Analyst – Business Intelligence Developer Overview

This role is responsible for the development of operational data reporting, data engineering, and the development of data sets and data tools including data extracts, reports, and dashboards. This role will be responsible for proactively developing, testing, and maintaining critical data pipelines and architectures across multiple technical environments within various business functions in support of the GEICO’s operational data reporting. As a member of an agile team, the developer assists with testing, validation, user acceptance testing, deployment, and post-implementation support. This includes writing code that builds datasets, metrics, and data needed for our business partners.

Responsibilities

• Create SQL stored procedures, advanced queries, debugging, and optimization.
• Rewrite SAS code into SSIS Packages and Power BI, including SSIS debugging.
• Design, update, and maintain relational databases.
• Develop process automation and ETL solutions.
• Maintain and support daily data refresh procedures
• Perform and automate daily maintenance processes.
• Creates and prepare data sets for reporting and ...