Geico Logo Geico
Geico Logo

Junior Etl Software Engineer

💰 $100,000 - $150,000 🌍 United States of America 📅 07/05/2023

Apply

Job Description

##### Job Description :

**Basic Qualifications:**

* 1+ years knowledge of Data transformation, Data management & ETL processes
* 1+ years’ experience documenting business and system requirements, processes, workflows, and test plans
* 1+ years’ experience with Relational Database (Snowflake, Hive, Microsoft SQL, Oracle or DB2)
* 2+ years’ experience on writing queries using SQL
* 1+ years’ working knowledge of Data Vault modelling, Azure DevOps, Hadoop, Hive, Microsoft Power BI, and Python
* 1+ years’ working knowledge of Big Data and the Azure/Snowflake ecosystem
* Strong SQL, data mapping, and data profiling skills
* Assists developers with more complex and detailed projects including root cause analysis, gap analysis etc.
* Knowledge of Telematics is a plus.
* Excellent time management skills and attention to detail is required
* Excellent verbal/written communication skills, including communicating technical issues to non-technical audiences
* Strong problem-solving ability, critical thinking skills, creative/innovative thinking
* Ability and desire to learn new skills and techniques
* Ability to thrive while working on ambiguous or challenging projects
* A Bachelor's degree in a computer or information technology or currently enrolled in a degree program


**Desirable Qualifications:**

* Proficient in SQL and be able to extract & validate data using SQL query
* Knowledge of DBT. schema and data testing knowledge
* Ability to work independently while supporting multiple projects in a dynamic environment
* Understanding of software development, web technologies, and testing approaches
* Ability to discern data inaccuracies through technical experience and knowledge.
* Develop an understanding of the business and the data needed to promote success
* Ability to query, organize and interpret large amounts of data
* Research data from key business systems, assess data quality, and map data to requirements for analysis and reporting

**Benefits:**

At GEICO, we make sure you have the support and resources to leverage and
develop your skills, secure your financial future, and take care of your
health and well-being. GEICO continually seeks to provide a workplace where
everyone can be their authentic self. To help achieve this goal, we support
associate-led Employee Resource Groups that foster a true sense of community.
Through GEICO’s competitive benefits offerings and various training and
development opportunities, we have you covered with our Total Rewards Program*
that includes:

* Premier Medical, Dental and Vision Insurance with no waiting period**
* Paid Vacation, Sick and Parental Leave
* 401(k) Plan
* Tuition Reimbursement
* 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.

_GEICO is proud to be an equal opportunity employer. We are committed to
cultivating an environment where equal employment opportunities are available
to 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
celebrates diversity and believes it is critical to our success. As such, we
are committed to recruit, develop and retain the most talented individuals to
join our team._

#LI-SS3

**Annual Salary**

$70,000.00 - $132,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.