Business Intelligence Developer

$76,000 - $138,000/Yr

Geico - Chevy Chase, MD

Full-time - Mid Level

Chevy Chase, MD

5,001-10,000 employees

Insurance Carriers and Related Activities

About the position

The Financial Data Analyst - Business Intelligence Developer is responsible for developing operational data reporting, data engineering, and creating data sets and tools, including data extracts, reports, and dashboards. This role involves maintaining critical data pipelines and architectures across various technical environments to support GEICO's operational data reporting. The developer will work within an agile team, assisting with testing, validation, user acceptance testing, deployment, and post-implementation support, while also writing code to build datasets and metrics for 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.
• Create and prepare data sets for reporting and dashboards.
• Debug, troubleshoot, and optimize new and existing processes.
• Assist with data and database migrations, testing, and validation.
• Create MS SQL Server procedures and batch jobs to extract, transform and load data.
• Develop and test reports and data extracts.
• Adhere to development standards and software change management procedures.
• Assist with proposing new data strategies and methods to enhance and advance the data environment.
• Assist with project and time management, including estimates and status reporting.
• Conduct root cause analysis and advanced performance tuning functions.
• Design and implement data models and database architectures to support client projects and initiatives.
• Work closely with cross-functional teams to ensure the successful delivery of data engineering solutions.
• Provide technical guidance and mentorship to junior team members as needed.

Requirements

• Relevant work experience of 5+ years (preferred).
• Ability to work both independently and in a team environment.
• Ability to multi-task.
• Ability to learn and apply large amounts of technical and procedural information.
• Effective verbal and written communication skills.

Benefits

• Premier Medical, Dental and Vision Insurance with no waiting period.
• Paid Vacation, Sick and Parental Leave.
• 401(k) Plan.
• Tuition Reimbursement.
• Paid Training and Licensures.