Technical Business and Data Analyst
GEICO is more than insurance, it’s truly a tech company at heart. GEICO Technology Solutions is rapidly expanding to keep up with its growth in the digital space.
GEICO'S - Data Consumption team of Data, Security & Infrastructure (DSI) department is seeking a highly motivated Technical Business/Data Analyst to start or continue an IT career at GEICO on the Big Data project. We are looking for a Technical Business/Data Analyst to understand Telematics Data, gather business requirements and work with software engineers, scrum masters, leads, managers to create and implement Models pertaining to various use cases for the telematics data. In this role you will collaborate and communicate with data scientists/ business partners and technical teams in developing insights and understanding across analytical and presentation projects.
Teaming up with software engineers, scrum masters, leads, managers and directors, you will work in an Agile environment to make application data ingested from various partner systems consumable on the Big Data Atomic Layer.
In this role, you will coordinate with a variety of IT departments to elicit and translate high level business requirements into detailed system requirements. You will participate in the entire software development lifecycle by writing and executing test plans, conducting both manual and automated tests of software products, and finding solutions to issues during development and after deployment. You should be intellectually curious, have a solutions-oriented attitude and enjoy learning new tools and techniques.
Qualifications:
Technical Business & Data Analyst – Big Data
GEICO'S - Data Consumption team of Data, Security & Infrastructure (DSI) department is seeking a highly motivated Technical Business/Data Analyst to start or continue an IT career at GEICO on the Big Data project.
Teaming up with software engineers, scrum masters, leads, managers and directors, you will work in an Agile environment to make application data ingested from various partner systems consumable on the Big Data Atomic Layer.
In this role, you will coordinate with a variety of IT departments to elicit and translate high level business requirements into detailed system requirements. You will participate in the entire software development lifecycle by writing and executing test plans, conducting both manual and automated tests of software products, and finding solutions to issues during development and after deployment. You should be intellectually curious, have a solutions-oriented attitude and enjoy learning new tools and techniques.
Basic Qualifications:
- 2+ years knowledge of Data transformation, Data management & ETL processes
- 2+ years’ experience documenting business and system requirements, processes, workflows and test plans
- 2+ years’ experience with Relational Database (Snowflake, Hive, Microsoft SQL, Oracle or DB2)
- 2+ years’ experience on writing queries using SQL
- 2+ years’ working knowledge of Data Vault modelling, Azure DevOps, Hadoop, Hive, Microsoft Power BI, and Python
- 2+ 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 with Profit Sharing
- Tuition Reimbursement
- Paid Training and Licensures
- Benefits may be different by location. Benefit eligibility requirements vary and may include length of service.
**Coverage begins with the pay period after hire date. 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