Big Data / ETL Developer

Apply for this position Please mention DailyRemote when applying
timePosted 13 days ago location United States salarySalary undisclosed
Before you apply - make sure the job is legit.

Attempting to apply for jobs might take you off this site to a different website not owned by us. Any consequence as a result for attempting to apply for jobs is strictly at your own risk and we assume no liability.

Job Description

Ready to make an impact? If so, read on! The IT Actuary Systems team is seeking an experienced and highly self-motivated Big DataETL Developer to support Financial Reporting of Claims Case reserve activity and Statistical Reporting. In this role, you will design, develop, test, and implement ETLELT solutions in addition to developing complex queries to mine data from the Enterprise Data Warehouse and the Big Data Platform. You must excel at working independently as well as part of a team, show an appropriate sense of urgency, multi-task across multiple projects, all while providing production support. Job Responsibilities bull Be part of a development team to build and maintain the ETL processes bull Analyze the needs and the environment to make sure the solution you're developing considers the current architecture and operating environment as well as future functionality and enhancements bull Develop, test, debug, document and help operationalize various ETL applications leveraging industry best practices bull Work closely and collaborate with various cross functional IT teams to identify, troubleshoot and fix data issues, and resolve data gaps that impact the fulfillment of the business's functional requirements bull Work collaboratively with team members and customers to gather and validate requirements as well as deliver featuresenhancements bull Collaborate with architects, team leads and team members to architect and design solutions to meet functional and technical requirements bull Troubleshoot issues, identify resolutions and be available for 247 production support on a rotational basis bull Responsible for writing complex SQL queries for mining of operational data Would you like to join our innovative team? If so, do you meet these qualifications? Required Skills bull Minimum 3 years of experience with Relational Database Systems and Oracle PLSQL bull Minimum 2-3 years of experience with manipulating and transforming large and complicated datasets bull Experience with developing, tuning and debugging code, stored procedures, functions and packages. bull Strong functional and analytical skills. bull Minimum 2 years of experience in developing high volume transaction processing solutions bull Experience in Data Profiling Preferred Skills bull 2+ years of experience in designing and developing efficient and robust ETLELT workflows using tools such as Informatica, Ab Initio, Talend or Apache Spark bull Work with large streams of data (1TB.) in a large enterprise environment bull Experience in LinuxUNIX scripting and SQL bull Experience with Personal or Commercial auto insurance policy and claims systems bull Experience with TFS or GIT bull Experience with advanced Data Warehousing concepts and skills bull Experience with sourcing data across multiple platforms (Mainframe, FTP, Data Warehouse, ESB) bull Experience with JSON and XML bull Experience with SDLCWaterfallAgile methodologies and developing Project Artifacts bull Experience with Application Systems and Data Analysis Note The safety of our associates, both current and future, is GEICO's highest priority. At this time, most of our associates are working remotely due to the current COVID-19 pandemic. Candidates who are selected for this position will be trained remotely and must be able to work from home in a designated work area. Once GEICO determines it is safe for associates to return to the office, candidates may be required to work in our Chevy Chase, MD office. Benefits As a full-time Big Data ETL Developer, you'll enjoy our Total Rewards Program to help secure your financial future and preserve your health and well-being, including 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 an equal opportunity employer. GEICO conducts drug screens and background checks on applicants who accept employment offers. 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 andor 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.descr2