Business Intelligence Analyst

At GEICO, we offer a rewarding career where your ambitions are met with endless possibilities. Every day we honor our iconic brand by offering quality coverage to millions of customers and being there when they need us most. We thrive through relentless innovation to exceed our customers expectations while making a real impact for our company through our shared purpose. When you join our company, we want you to feel valued, supported and proud to work here. Thats why we offer The GEICO Pledge: Great Company, Great Culture, Great Rewards and Great Careers. 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 post-implementation 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 cross-functional 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 P&C claims data/analytics experience or any P&C insurance industry experience 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 multi-task Location: This position is a hybrid role. It is required to be on-site 3 days per week at one of the following office locations: Chevy Chase, MD, Chicago, IL, New York, NY. Annual Salary $77,900.00 - $129,150.00 The 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. At this time, GEICO will not sponsor a new applicant for employment authorization for this position. The GEICO Pledge: Great Company: At GEICO, we help our customers through lifes twists and turns. Our mission is to protect people when they need it most and were constantly evolving to stay ahead of their needs. Were an iconic brand that thrives on innovation, exceeding our customers expectations and enabling our collective success. From day one, youll take on exciting challenges that help you grow and collaborate with dynamic teams who want to make a positive impact on peoples lives. Great Careers: We offer a career where you can learn, grow, and thrive through personalized development programs, created with your career and your potential in mind. Youll have access to industry leading training, certification assistance, career mentorship and coaching with supportive leaders at all levels. Great Culture: We foster an inclusive culture of shared success, rooted in integrity, a bias for action and a winning mindset. Grounded by our core values, we have an an established culture of caring, inclusion, and belonging, that values different perspectives. Our teams are led by dynamic, multi-faceted teams led by supportive leaders, driven by performance excellence and unified under a shared purpose. As part of our culture, we also offer employee engagement and recognition programs that reward the positive impact our work makes on the lives of our customers. Great Rewards: We offer compensation and benefits built to enhance your physical well-being, mental and emotional health and financial future. Comprehensive Total Rewards program that offers personalized coverage tailor-made for you and your familys overall well-being. Financial benefits including market-competitive compensation; a 401K savings plan vested from day one that offers a 6% match; performance and recognition-based incentives; and tuition assistance. Access to additional benefits like mental healthcare as well as fertility and adoption assistance. Supports flexibility- We provide workplace flexibility as well as our GEICO Flex program, which offers the ability to work from anywhere in the US for up to four weeks per year. 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. For more than 75 years, GEICO has stood out from the rest of the insurance industry! We are one of the nation's largest and fastest-growing auto insurers thanks to our low rates, outstanding service and clever marketing. We're an industry leader employing thousands of dedicated and hard-working associates. As a wholly owned subsidiary of Berkshire Hathaway, we offer associates training and career advancement in a financially stable and rewarding workplace. Opportunities for Students & Grads Learn more about GEICO Learn more about GEICO Diversity and Inclusion Learn more about GEICO Benefits