Logo of Huzzle

Business Intelligence Developer

image

GEICO

12d ago

  • Job
    Full-time
    Senior Level
  • Data
    IT & Cybersecurity
  • Chevy Chase
  • Quick Apply

AI generated summary

  • You must work independently and in teams, multi-task, learn quickly, and communicate well. Preferably 5+ years of relevant experience required; hybrid in-office 3 days/week.
  • You will create SQL procedures, rewrite SAS code, design databases, develop ETL solutions, optimize processes, maintain data routines, and support reporting while collaborating with cross-functional teams.

Requirements

  • Must be able to work both independently and in a team environment
  • Must be able to multi-task
  • Must be able to learn and apply large amounts of technical and procedural information
  • Must be able to communicate effectively verbally and in writing
  • Must have the following experience:
  • Relevant work experience of 5+ years (preferred)
  • In office Hybrid work requirement: In office 3 days per week (required)

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 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.

FAQs

What is the job title for this position?

The job title for this position is Business Intelligence Developer.

What are the main responsibilities of the Business Intelligence Developer?

The main responsibilities include developing operational data reporting, creating SQL stored procedures, rewriting SAS code into SSIS packages and Power BI, designing relational databases, developing ETL solutions, maintaining data refresh procedures, and assisting with data migrations and testing.

What qualifications are required for this position?

Candidates should have relevant work experience of 5+ years, the ability to work independently and in a team environment, strong communication skills, and the ability to learn and apply large amounts of technical and procedural information.

What is the hybrid work requirement?

The hybrid work requirement is for the employee to work in the office 3 days per week.

What is the salary range for this position?

The annual salary range for this position is between $68,000.00 and $113,000.00.

What benefits are offered to employees in this position?

Benefits include Premier Medical, Dental and Vision Insurance, Paid Vacation, Sick and Parental Leave, a 401(k) Plan, Tuition Assistance, and Paid Training and Licensures.

Does GEICO provide sponsorship for employment authorization?

No, GEICO will not sponsor a new applicant for employment authorization for this position.

What types of skills are required for this role?

Required skills include strong quantitative and analytical skills, problem-solving abilities, organizational skills, and effective communication and interpersonal skills.

Is teamwork important for this position?

Yes, teamwork is important as the developer will work closely with cross-functional teams to ensure the successful delivery of data engineering solutions.

Are there any specific tools or technologies mentioned in the job description?

Yes, the role requires experience with SQL, SAS, SSIS, and Power BI among other data-related technologies.

Finance
Industry
10,001+
Employees

Mission & Purpose

GEICO (Government Employees Insurance Company) provides affordable auto insurance and a variety of other coverage options, including home, renters, motorcycle, and business insurance. Their mission is to offer reliable and accessible insurance services with excellent customer support and innovative solutions. GEICO aims to deliver exceptional value by providing competitive rates, convenient services, and a commitment to meeting the diverse needs of their policyholders.