Senior Data Engineer

ABOUT THE ROLE:

The Data Engineer will be responsible for developing and maintaining pipelines for Payment Ops Org reporting infrastructure. This person will work within the Payment Ops team, responsible for developing and deploying data pipelines for Payment Ops reporting across all ABC products.

WHAT YOULL DO:

• Design, develop, and maintain efficient and scalable ETL pipelines to support our enterprise data warehouse and analytical needs.
• Build scalable data models to support real-time transaction monitoring, reconciliation, chargeback tracking, and fraud analysis.
• Work with stakeholders across departments to understand business requirements and translate them into actionable data models and reports.
• Manage and optimize large-scale data systems using Oracle and SQL Server.
• Integrate and normalize payment data from diverse platforms (e.g., Worldpay, Adyen, Stripe).
• Identify and troubleshoot data discrepancies between systems to support timely reconciliation and root cause analysis.
• Build dashboards and reports to monitor approval rates, decline reasons, dispute trends, and interchange fee performance.
• Drive automation in payment reporting processes to reduce manual effort and improve accuracy.
• Maintain documentation of ETL workflows, data dictionaries, and SLA guarantees for downstream consumers.
• Thrive in a fast-paced, ambiguous environment and help shape data strategy from the ground up.
• Continuously improve data engineering practices and drive automation wherever possible.

WHAT YOULL NEED:

• 4-6 years of experience in a Business Intelligence or Data Engineering role.
• Strong experience with Oracle and SQL Server, including complex SQL query writing and performance tuning.
• Proven expertise in designing and building ETL workflows for large-scale data warehouses
• Working understanding of payment processing flows, PSP integrations, and key payment metrics (e.g., conversion rate, chargeback rate, retry logic).
• Familiarity with data modeling techniques and data warehousing concepts (e.g., star/snowflake schemas, SCDs).
• Experience handling ambiguity in problem statements and requirements; and converting them into structured data solutions
• Experience in Statistical modelling for forecasting and fraud analytics preferred
• Strong communication and stakeholder management skills.

AND ITS GREAT TO HAVE:

• Exposure to Python, Spark, or other data transformation frameworks is a plus
• Experience working with Databricks platform and related technologies.
• Flexibility in work timings to collaborate across time zones (beyond regular day shift).
• Strong organizational skills to maintain documentation and streamline workflows.
• Experience with data visualization tools such as Power BI, Tableau, or Looker is a plus

WHATS IN IT FOR YOU:

• Purpose led company with a Values focused culture Best Life, One Team, Growth Mindset

• Time Off competitive PTO plans with 15 Earned accrued leave, 12 days Sick leave, and 12 days Casual leave per year

• 11 Holidays plus 4 Days of Disconnect once a quarter, we take a collective breather and enjoy a day off together around the globe. #oneteam

• Group Mediclaim insurance coverage of INR 500,000 for employee + spouse, 2 kids, and parents or parent-in-laws, and including EAP counseling

• Life Insurance and Personal Accident Insurance

• Best Life Perk we are committed to meeting you wherever you are in your fitness journey with a quarterly reimbursement

• Premium Calm App enjoy tranquility with a Calm App subscription for you and up to 4 dependents over the age of 16

• Support for working women with financial aid towards crche facility, ensuring a safe and nurturing environment for their little ones while they focus on their careers.