Business Intelligence Analyst
Business Intelligence Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 77900 - 129150
1 Vacancy
Job Description
This role is responsible for the development of data delivery solutions that support operational data reporting including datasets 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 GEICOs operational data reporting. As a member of an agile team the incumbent assists with testing validation user acceptance testing deployment and postimplementation support. This includes writing code that builds datasets metrics and data needed for our business partners.
Responsibilities
Strong foundation in modern data architecture concepts like data warehouse data mart data lake data lakehouse data mesh etc.
Full life cycle development of automated data delivery processes for reporting and dashboards using ETL/ELT tools such as dbt Azure Data Factory SSIS etc.
Highly proficient in SQL with the ability to write debug and optimize queries and data pipelines
Migrate existing SAS solutions to technologies used widely at GEICO such as dbt and Power BI
Work closely with crossfunctional teams to design develop and implement data models and architectures to support client projects and initiatives
Perform and automate daily maintenance processes
Assist with data and database migrations testing and validation
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
Provide technical guidance and mentorship to junior team members as needed
Qualifications
Bachelors degree preferred
3 years of relevant work experience
Proficient in Power BI SQL SAS and SSIS
Proficiency with one or more of: Snowflake dbt ADO GitHub Apache Iceberg Apache Superset is preferred.
Stakeholder management skills
Strong quantitative analytical problem solving organizational communication and interpersonal skills are required
Ability to provide technical guidance and mentorship to junior team members as needed
Must be able to work both independently and in a team environment
Must be able to multitask
Location: This position is a hybrid role. It is required to be onsite 3 days per week at one of the following office locations: Chevy Chase MD Chicago IL New York NY.
Annual Salary
$77900.00 $129150.00The above annual salary range is a general guideline. Multiple factors are taken into consideration to arrive at the final hourly rate/ annual salary to be offered to the selected candidate. Factors include but are not limited to the scope and responsibilities of the role the selected candidates work experience education and training the work location as well as market and business considerations.
Benefits:
As an Associate youll enjoy our Total Rewards Program* to help secure your financial future and preserve your health and wellbeing including:
- Premier Medical Dental and Vision Insurance with no waiting period**
- Paid Vacation Sick and Parental Leave
- 401(k) Plan
- Tuition Assistance
- Paid Training and Licensures
*Benefits may be different by location. Benefit eligibility requirements vary and may include length of service.
**Coverage begins on the date of hire. Must enroll in New Hire Benefits within 30 days of the date of hire for coverage to take effect.
The equal employment opportunity policy of the GEICO Companies provides for a fair and equal employment opportunity for all associates and job applicants regardless of race color religious creed national origin ancestry age gender pregnancy sexual orientation gender identity marital status familial status disability or genetic information in compliance with applicable federal state and local law. GEICO hires and promotes individuals solely on the basis of their qualifications for the job to be filled.
GEICO reasonably accommodates qualified individuals with disabilities to enable them to receive equal employment opportunity and/or perform the essential functions of the job unless the accommodation would impose an undue hardship to the Company. This applies to all applicants and associates. GEICO also provides a work environment in which each associate is able to be productive and work to the best of their ability. We do not condone or tolerate an atmosphere of intimidation or harassment. We expect and require the cooperation of all associates in maintaining an atmosphere free from discrimination and harassment with mutual respect by and for all associates and applicants.
Required Experience:
IC
Employment Type
Full-Time
