Data Flow Engineer II

JobCubby; Hinoba-an; On-site; PHP 600,000 - 900,000; Full time

Job summary

JobCubby is seeking a Data Flow Engineer in the Philippines to design and manage data connections, validate inputs, and perform transformations. The role focuses on improving auto-reconciliation through advanced data handling and Clearwater workflows.

You will work across API and FTP integrations, data normalization, and process automation. Ideal candidates have 2+ years in data engineering, strong SQL skills, scripting in Groovy/Perl/Python, and solid communication.

Qualifications

• Bachelor's degree in Math, Computer Information Systems, or related field.
• 2+ years of relevant experience in data engineering or related roles.
• Strong SQL and relational database knowledge.
• Experience with Groovy, Perl or Python scripting.
• Familiarity with data transmission protocols.
• Proficiency in Microsoft Office applications.
• Excellent attention to detail and documentation skills.
• Strong verbal and written communication skills.

Responsibilities

• Import and validate file delivery for new clients.
• Automate daily process monitoring and reporting.
• Establish connections via external APIs and FTPs.
• Normalize external datasets into Clearwater format for intake.
• Mine data from feeds to improve auto-reconciliation.
• Implement improvements requested by Operations and Development.
• Explain Clearwater workflows and best practices to stakeholders.
• Engage in light on-call duties.

Skills

SQL & Relational DB

Scripting: Groovy/Perl/Python

Data transmission protocols

Microsoft Office

Attention to detail

Communication skills

Organizational skills

Problem solving

Education

Bachelor's degree in Math, Computer Science, or related field

Tools

External APIs

FTP protocols

Job description

Job Summary:

The Data Flow Engineer's primary role is to create and manage data connections, perform validations, and execute transformations. Their work is integral to the ongoing process of iterative improvement, with a particular focus on enhancing auto-reconciliation within the system through advanced technology.

Responsibilities:

• Import and validate file delivery for new clients.
• Automate daily process monitoring and reporting.
• Establish connections through external APIs and FTPs.
• Ensure timely and dependable consumption of external portfolio data.
• Normalize external datasets into a standardized Clearwater format facilitating the in-take process.
• Mine data from existing feeds to identify, design, and implement solutions to improve auto-reconciliation.
• Execute improvements requested from Operations and Development groups.
• Apply acquired skills, procedures, and decision-making best practices to complete various issues, such as normalizing new feeds and improving automation.
• Understand and reference or explain the general workflow, tools, and Clearwater value proposition.
• Use critical thinking to address issues and offer solutions for both internal and external parties, ensuring best practices are employed.
• Clearly and effectively communicate the technical aspects of Clearwater systems and our best practices with non-technical internal and external stakeholders.
• Engage in light on-call duties.

Required Skills:

• Securities, accounting, and financial experience.
• Strong understanding of SQL and relational database principles.
• Experience with scripting programming languages like Groovy, Perl or Python.
• Experience with industry-standard data transmission protocols preferred.
• Securities, accounting, and financial experience preferred.
• Strong computer skills, including proficiency in Microsoft Office.
• Excellent attention to detail and strong documentation skills.
• Outstanding verbal and written communication skills.
• Strong organizational and interpersonal skills.
• Exceptional problem-solving abilities.

Education and Experience:

• Bachelor's degree in Math, Computer Information Systems, or other relevant degrees.
• 2+ years of relevant experience.
• Experience with industry-standard data transmission protocols.