Senior Data Engineer
ABC Financial Services2 months ago
Hyderābād, IndiaSenior
Responsibilities
- Design, develop, and maintain scalable ETL pipelines for enterprise data warehouses and analytical use cases.
- Build data models for transaction monitoring, reconciliation, chargeback tracking, and fraud analysis.
- Manage and optimize large-scale Oracle and SQL Server data systems, including complex SQL queries and performance tuning.
- Integrate and normalize payment data from Worldpay, Adyen, Stripe, and other platforms.
- Identify and troubleshoot data discrepancies to support reconciliation and root cause analysis.
- Build dashboards and reports covering approval rates, decline reasons, dispute trends, and interchange fee performance.
- Automate payment reporting processes to reduce manual effort and improve accuracy.
- Maintain ETL workflow documentation, data dictionaries, and SLA guarantees for downstream consumers.
- Translate stakeholder requirements into structured data models, reports, and data solutions.
- Continuously improve data engineering practices and help shape data strategy.
Requirements
- At least 4 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 experience designing and building ETL workflows for large-scale data warehouses.
- Working understanding of payment processing flows, PSP integrations, and payment metrics such as conversion rate, chargeback rate, and retry logic.
- Familiarity with data modeling, data warehousing concepts, star and snowflake schemas, and slowly changing dimensions.
- Ability to handle ambiguous requirements and convert them into structured data solutions.
- Strong communication, stakeholder management, and organizational skills.
- Statistical modeling experience for forecasting and fraud analytics is preferred.
- Exposure to Python, Spark, or other data transformation frameworks is a plus.
- Experience with Databricks and related technologies is a plus.
- Experience with Power BI, Tableau, or Looker is a plus.
- Flexibility to collaborate across time zones beyond regular day-shift hours.
Benefits
- Hybrid work arrangement requiring attendance at the Hyderabad office 2–3 times per week.
- 15 earned accrued leave days, 12 sick leave days, and 12 casual leave days per year.
- 11 holidays plus 4 quarterly Days of Disconnect.
- Group Mediclaim insurance covering the employee, spouse, children, and parents or parents-in-law, including EAP counseling.
- Life insurance and personal accident insurance.
- Quarterly fitness reimbursement through the Best Life Perk.
- Calm App subscription for the employee and up to four dependents over age 16.
- Financial aid toward crèche facilities for working women.
- Values-focused culture with learning, mentorship, professional development, and inclusion initiatives.
Tech Stack
Categories
Data Engineering
About ABC Financial Services
ABC Financial Services (now ABC Fitness) builds club management and billing software for gyms, studios, and health clubs, combining SaaS tools with integrated payment processing. Its products cover member management, scheduling, point-of-sale, and reporting for single-location studios to multi-site fitness chains, with recurring revenue from subscriptions and processing fees. The company is privately held, backed by private equity, and headquartered in Sherwood, Arkansas, with customers across North America and internationally.