Business Intelligence Analyst
Caterpillar Inc.
PythonSQLTableau
Business Intelligence Analyst
GEICO
full-time
Posted on:
Location Type: Hybrid
Location: Chevy Chase • Illinois, Maryland • 🇺🇸 United States
Visit company websiteSalary
💰 $77,900 - $129,150 per year
Job Level
Mid-LevelSenior
Tech Stack
ApacheAzureETLSQLSSIS
About the role
- Responsible for the development of data delivery solutions that support operational data reporting, including datasets, extracts, reports, and dashboards.
- 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.
- Assists with testing, validation, user acceptance testing, deployment, and post-implementation support.
- Writing code that builds datasets, metrics, and data needed for our business partners.
- 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
- 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.
Benefits
- 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.
- 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLSASSSISPower BIdbtAzure Data FactoryETLELTdata architecturedata modeling
Soft skills
stakeholder managementquantitative skillsanalytical skillsproblem solvingorganizational skillscommunication skillsinterpersonal skillstechnical guidancementorshipmulti-tasking