ETL Data Engineer

ETL Data EngineerAllocore powers the leading government loans, grants, and fraud prevention programs with a unified cloud-based platform built for efficiency and security. Our advanced solutions power the largest and most complex government loan and grant programs, streamlining workflows and integrating proven technologies to handle high-volume financial processes with speed and precision. Every day, we're enabling government agencies to deliver critical financial resources to those who need them most—quickly and efficiently. At Allocore, our culture is built on three core values—Urgency, Collaboration, and Commitment—which shape how we work, innovate, and support one another. Joining Allocore means being part of a mission-driven team that values innovation, collaboration, and a commitment to excellence. If you thrive in high-pressure environments where urgency meets creativity and where every challenge is an opportunity to create impact, then continue reading.... Allocore is growing! We are looking for an ETL (Extract, Transform, Load) Data Engineer to join our team.You will be responsible for designing, developing, and maintaining ETL processes that move and transform data from various sources into data storage solutions like data warehouses or data lakes.ResponsibilitiesDesign, implement, and test data pipeline workflows to transform information between various systemsAnalyze database and API schema definitions to build integration between data sourcesCollaborate with business and product owners to define software requirementsResolve problems through analysis, configuration, coding, and coordinating with other team membersWork with business teams to investigate and triage data-related inquiriesWork both independently and as a team to deliver software solutions that are consistent across projectsProactively propose solutions for improvements in software products and team processesHave an impact on day one and continuously learn and develop new skillsRequirements / QualificationsU.S. citizenship is required. Must be eligible to obtain and maintain a Public Trust clearanceBachelor's Degree in computer science, information systems, business, accounting, finance, or equivalent experienceExperience working in a DevOps culture that strives towards best practices of delivering high-quality softwareCloud Development, including Docker and Kubernetes, preferred Bank lending experience, preferred IT experience.Software development experience in team collaboration via GitHub or similar source code management and peer review processesAbility to translate concepts into simple and flexible product featuresUnderstand data warehouse concepts and ETL workflow management fundamentalsRefine and optimize implementation details as requirements change and data volumes increaseProficiency in interacting with data via SQL, API, and cloud-based data sourcesExperience programming with Java, Python, or similar programming languagesDemonstrate experience with Pentaho PDI or similar ETL toolingThis is a hybrid position based in Mechanicsburg, PA, with an expectation of working in the office at least three days per week. Candidates who are willing to relocate to the Mechanicsburg area will also be considered.Why AllocoreWork on high-impact systems that support critical government programsBe part of a growing company where you can shape both product and engineering cultureCollaborative, mission-driven team with startup energyOpportunity to build and scale a platform from the ground upBenefits:Competitive salary and performance-based bonuses - paid 2x a year!Comprehensive health plans to choose from - Allocore pays up to 94% of the premiumFREE dental & FREE vision plans for you - and your loved ones!401k with Match - 100% vested immediately!Employer-paid life & disabilityFlexible work hours and hybrid work optionsAll you can eat snacks!Unlimited PTO and company holidaysCollaborative and inclusive work environment with a diverse teamWhat to Expect: Step 1 - Apply. It only takes a few minutes! Step 2 - HR Phone Screen. If your application is a good match, you'll hear from one of our recruiters about setting up a phone screen. Step 3 - Interview(s). Now's your chance to learn about the job, show us who you are, share why you would be a great addition to the team, and determine if Lenders is the place for you. Step 4: Decision. The team will discuss - if it's a good fit for us and you, we'll make it official! Candidates selected for a conditional offer of employment will be subject to a background check. A criminal conviction does not automatically disqualify a candidate from consideration; results are evaluated in accordance with applicable laws and job relevance.Allocore is an equal-opportunity employer and is committed to providing a workplace free from harassment and discrimination. We celebrate our employees' unique differences because that drives curiosity, innovation, and the success of our business. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, gender identity or expression, age, marital status, veteran status, disability status, pregnancy, parental status, genetic information, political affiliation, or any other status protected by the laws or regulations in the locations where we operate. Accommodations are available for applicants with disabilities.