ROLE DESCRIPTION
Are you someone who enjoys solving complex data challenges and ensuring everything runs smoothly? VerifyToday is looking for a highly motivated and detail-oriented Junior ETL Developer to join our team. In this role, you’ll play a critical part in managing payroll data that includes PII, employment, and income information—data that powers our background verification services. You’ll work directly with data received via SFTP (as CSV / XLSX files) and through API data pipelines. Your insights and efforts will drive accuracy, efficiency, and innovation in our data processes. This is more than just a job; it’s an opportunity to grow your skills, take ownership of impactful projects, and contribute to a fast-growing company at the forefront of background verifications. If you’re passionate about data and want to make a meaningful difference, we’d love to have you on board.
ESSENTIAL FUNCTIONS
Data Extraction and Loading
- Extract data from multiple sources such as APIs, databases, and flat files(e.g., CSV, XML, JSON),
- Review, validate, and load data daily.
- Monitor data integrity and resolve any discrepancies.
- Ensure timely processing of files to meet client expectations.
- Design and implement data transformation rules to clean, format, and standardize data.
- Develop scripts or workflows for data aggregation, de-duplication, and enrichment.
Client Onboard and Initial Data Management :
Create and maintain initial file mappings for data integration for new clients.Review and validate historical data files from new clients.Load, process and monitor historical data into the system.Generate onboarding reports and share findings with internal stakeholders.Data Disputes Resolution :
Investigate and address data disputes raised by verifiers.Cross-check data with sources and determine resolution paths.Redirect disputes to the support team or client as necessary.Partnership Data Assessment :
Review incoming data from potential partnerships via APIs.Assess whether the data fits our database schema and template requirements.Provide detailed reports and recommendations after assessment.Process Optimization :
Identify repetitive tasks and propose automation solutions.Suggest enhancements for manual processes to streamline operations.Collaborate with the engineering team to integrate improvements into the system.Place of growth if interested in expanding knowledge in software engineering.Communication and Collaboration :
Communicate effectively with clients, support teams, and other stakeholders.Document processes and share knowledge to promote transparency and efficiency.Provide updates on task progress and escalate issues when necessary.Generate reports from MySQL database with support from Data Engineer.REQUIRED SKILLS AND EXPERIENCE
Familiarity with data formats (e.g., CSV, JSON) and data integration processes.Knowledge of ETL (Extract, Transform, Load) processes.Proficiency in MySQL for data validation and reporting.Basic knowledge of scripting languages (e.g., Python, Java, or Shell scripting).Strong problem-solving skills and a keen eye for detail.Excellent communication skills, both written and verbal.Ability to identify areas for process improvement and propose actionable solutions.Willingness to learn and grow within the software engineering domain.Ability to work independently and in a team environment.PREFERRED QUALIFICATIONS
Knowledge of APIs and system integration.Prior experience with payroll data, data operations or a similar role.
