GEICO
Staff Engineer - Data Engineering & Analytics
GEICO, Chevy Chase, Maryland, United States, 20815
Position Summary
GEICO is seeking an experienced Engin
eer with a pa
ssion for
building high-performance,
low maintenance
, zero-downtime platforms, and applications
.
You
will he
lp drive our insurance business transformation as we transition from a traditional IT model to a tech organization with engineering excellence as its mission
.
Within the Data Analytics and Vertical Engineering team, you will lead the design and development of
state-of-the-art
data pipelines, models, and reports, transforming vast datasets that reach up to multiple terabytes in size, while championing innovation, best practices,
co-creating the culture of psychological safety and continuous improvement. Position Description Our
Staff
Engineer is a key member of the engineering staff working across the organization to
provide
a friction
-less experience
to
our customers and
maintain
the highest standards of protection and availability. Our team thrives and succeeds in delivering high quality technology products and services in a hyper-growth environment where priorities shift quickly.
The ideal candidate has broad and deep technical knowledge, typically ranging from
data processing, pipeline development to dimensional data modeling and reporting
. Position Responsibilities As a
Staff
Engineer
,
you will: Scope, design, and build scalable, resilient distributed systems
Utilize programming languages like
Python,
SQL,
NoSQL,
DBT
along with Apache Spark for data processing, container orchestration services such as Docker and Kubernetes, and various Azure tools and services
SQL Server Integration Services as well as reporting tools like Power
BI
and Apache Superset
to transform and report on large volumes of enterprise data to gain new insights
Utilize your passion for data exploration to produce high quality,
accurate
data and/or reports with visualizations to empower outstanding business decisions
Responsible for technical aspects of a project at the team level
Lead in design sessions and code reviews with peers to elevate the quality of engineering across the organization
Spearhead new feature use(innovate within existing tooling)
Spearhead new software acquisition
and
use (innovate with new tooling)
Leverage automation to remove redundant error prone tasks to improve the quality of the solution
Build with engineering excellence and
leverage
your technical skills to drive towards the best solutions
Engage in cross-functional collaboration throughout the entire software lifecycle
Define, create, and support reusable application components/patterns from a business and technology perspective
Mentor other engineers
Consistently share best practices and improve processes within and across teams
Qualifications Advanced programming experience and big data experience within Python, SQL, DBT, Spark,
Kafka
, Git, Containerization (Docker and Kubernetes)
Advanced experience with Data Warehouses, OLAP, dimensional modeling and analytics
Demonstrable knowledge of business intelligence tools (strong preference for Power
BI) and/or ETL tools (strong preference for SSIS or DBT)
Experience with Apache Iceberg for managing large-scale tabular data in data lakes is a plus
Familiarity with understanding SQL concepts (such as MPP-based, No-SQL, Cloud WH)
Experience architecting and designing new ETL and BI systems
Experience with supporting existing ETL and BI systems
Experience with scripting languages such as Python is preferred
Experience with enterprise orchestration tools such as Airflow is preferred
Ability to balance the competing needs of multiple priorities and excel in a dynamic environment
Advanced understanding of DevOps concepts including Azure DevOps framework and tools
Knowledge of developer tooling across the software development life cycle (task management, source code, building, deployment, operations, real-time communication)
Advanced understanding of monitoring concepts and tooling
Strong problem-solving ability
Experience with Marketing, Product, Sales, Service, Customer, Associate, Billing, Agency, Claims, or Telematics data is preferred
Experience with f
ront end development
using
REACT
/
Javascript
is a plus
Experience 8
+ years of professional data/analytics/database engineering, programming languages and developing with big data
technologies
5
+
years
of experience with data architecture and
design
especially
Data Warehousing concepts
5+ years of experience with AWS, GCP, Azure, or another cloud service
4
+ years of
professional software development experience
with SQL-based technologies
4+ years of experience in open-source frameworks
4+ years of experience with ETL and/or BI tools
3
+ years of experience in Big-data tools like Spark and Databricks
2+ years of experience with Microsoft Fabric/Azure Data Factory
preferred
Education Bachelor’s degree in Computer Science
, Information Systems,
Data Science, Data Analytics
or equivalent education or work experience
#LI-RP2
Annual Salary $105,000.00 - $230,000.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 candidate’s work experience, education and training, the work location as well as market and business considerations. GEICO will consider sponsoring a new qualified applicant for employment authorization for this position.
The GEICO Pledge: Great Company: At GEICO, we help our customers through life’s twists and turns. Our mission is to protect people when they need it most and we’re constantly evolving to stay ahead of their needs. We’re an iconic brand that thrives on innovation, exceeding our customers’ expectations and enabling our collective success. From day one, you’ll take on exciting challenges that help you grow and collaborate with dynamic teams who want to make a positive impact on people’s 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. You’ll 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 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. 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.
#J-18808-Ljbffr
eer with a pa
ssion for
building high-performance,
low maintenance
, zero-downtime platforms, and applications
.
You
will he
lp drive our insurance business transformation as we transition from a traditional IT model to a tech organization with engineering excellence as its mission
.
Within the Data Analytics and Vertical Engineering team, you will lead the design and development of
state-of-the-art
data pipelines, models, and reports, transforming vast datasets that reach up to multiple terabytes in size, while championing innovation, best practices,
co-creating the culture of psychological safety and continuous improvement. Position Description Our
Staff
Engineer is a key member of the engineering staff working across the organization to
provide
a friction
-less experience
to
our customers and
maintain
the highest standards of protection and availability. Our team thrives and succeeds in delivering high quality technology products and services in a hyper-growth environment where priorities shift quickly.
The ideal candidate has broad and deep technical knowledge, typically ranging from
data processing, pipeline development to dimensional data modeling and reporting
. Position Responsibilities As a
Staff
Engineer
,
you will: Scope, design, and build scalable, resilient distributed systems
Utilize programming languages like
Python,
SQL,
NoSQL,
DBT
along with Apache Spark for data processing, container orchestration services such as Docker and Kubernetes, and various Azure tools and services
SQL Server Integration Services as well as reporting tools like Power
BI
and Apache Superset
to transform and report on large volumes of enterprise data to gain new insights
Utilize your passion for data exploration to produce high quality,
accurate
data and/or reports with visualizations to empower outstanding business decisions
Responsible for technical aspects of a project at the team level
Lead in design sessions and code reviews with peers to elevate the quality of engineering across the organization
Spearhead new feature use(innovate within existing tooling)
Spearhead new software acquisition
and
use (innovate with new tooling)
Leverage automation to remove redundant error prone tasks to improve the quality of the solution
Build with engineering excellence and
leverage
your technical skills to drive towards the best solutions
Engage in cross-functional collaboration throughout the entire software lifecycle
Define, create, and support reusable application components/patterns from a business and technology perspective
Mentor other engineers
Consistently share best practices and improve processes within and across teams
Qualifications Advanced programming experience and big data experience within Python, SQL, DBT, Spark,
Kafka
, Git, Containerization (Docker and Kubernetes)
Advanced experience with Data Warehouses, OLAP, dimensional modeling and analytics
Demonstrable knowledge of business intelligence tools (strong preference for Power
BI) and/or ETL tools (strong preference for SSIS or DBT)
Experience with Apache Iceberg for managing large-scale tabular data in data lakes is a plus
Familiarity with understanding SQL concepts (such as MPP-based, No-SQL, Cloud WH)
Experience architecting and designing new ETL and BI systems
Experience with supporting existing ETL and BI systems
Experience with scripting languages such as Python is preferred
Experience with enterprise orchestration tools such as Airflow is preferred
Ability to balance the competing needs of multiple priorities and excel in a dynamic environment
Advanced understanding of DevOps concepts including Azure DevOps framework and tools
Knowledge of developer tooling across the software development life cycle (task management, source code, building, deployment, operations, real-time communication)
Advanced understanding of monitoring concepts and tooling
Strong problem-solving ability
Experience with Marketing, Product, Sales, Service, Customer, Associate, Billing, Agency, Claims, or Telematics data is preferred
Experience with f
ront end development
using
REACT
/
Javascript
is a plus
Experience 8
+ years of professional data/analytics/database engineering, programming languages and developing with big data
technologies
5
+
years
of experience with data architecture and
design
especially
Data Warehousing concepts
5+ years of experience with AWS, GCP, Azure, or another cloud service
4
+ years of
professional software development experience
with SQL-based technologies
4+ years of experience in open-source frameworks
4+ years of experience with ETL and/or BI tools
3
+ years of experience in Big-data tools like Spark and Databricks
2+ years of experience with Microsoft Fabric/Azure Data Factory
preferred
Education Bachelor’s degree in Computer Science
, Information Systems,
Data Science, Data Analytics
or equivalent education or work experience
#LI-RP2
Annual Salary $105,000.00 - $230,000.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 candidate’s work experience, education and training, the work location as well as market and business considerations. GEICO will consider sponsoring a new qualified applicant for employment authorization for this position.
The GEICO Pledge: Great Company: At GEICO, we help our customers through life’s twists and turns. Our mission is to protect people when they need it most and we’re constantly evolving to stay ahead of their needs. We’re an iconic brand that thrives on innovation, exceeding our customers’ expectations and enabling our collective success. From day one, you’ll take on exciting challenges that help you grow and collaborate with dynamic teams who want to make a positive impact on people’s 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. You’ll 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 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. 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.
#J-18808-Ljbffr