
Geico
is hiring
Business Intelligence Analyst
About Our Company
GEICO (Government Employees Insurance Company) offers a variety of insurance such as vehicle, property, business, life, umbrella, travel, pet, jewelry and more.
The company, which was founded in 1936, is the third-largest auto insurer in the United States and insures vehicles in all 50 states and Washington, D.C.
GEICO, a member of the Berkshire Hathaway family of companies, constantly strives to make lives better by protecting people against unexpected events while saving them money and providing an outstanding customer experience. Visit geico.com to learn more
▪️ Building a Diverse Workforce ▪️
We are building a diverse and inclusive workforce. GEICO is dedicated to fostering a workplace where everyone feels valued, respected and supported. Our company is focused on building a diverse workforce through a culture of intentional inclusion.
▪️ Supporting Our Communities ▪️
Our commitment to being an engaged and involved corporate citizen is important to us. We work with supportive partners across the country that help us provide resources for people in need. Authenticity and inclusiveness are paramount as we give back to our communities.
▪️GEICO Cares ▪️
Our employees can make a big impact by participating in company-wide social impact programs such as Giving Back Together and FastPitch. They can also volunteer with local and national organizations such as Shoes That Fit, Reading is Fundamental, and more. To learn more, visit GEICO in the Community.
Job Description & Responsibilities
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 GEICO’s 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
Requirements
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 multi-task
What we offer
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 family’s 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.
In office and remote opportunities, as well as our signature GEICO Flex program, offering the ability to work remotely for up to four weeks per year.