Senior Data Engineer
Electronic Merchant Systems
- Cleveland, Ohio, United States
- Cleveland, Ohio, United States
À propos
Complex SQL Development: Design and maintain high-performance stored procedures, table-valued functions, and complex CTEs to handle large-scale financial transaction data. ETL & Integration: Manage and optimize existing SSIS packages and ETL workflows to ensure seamless data movement between legacy systems and our reporting environments. Domain Expertise: Apply deep knowledge of Clearing and Settlement logic, Merchant Pricing (Interchange, Tiered, etc.), and exposure to Chargeback processing workflows. Data Modeling: Maintain and optimize relational databases, utilizing temp tables, table variables, and XML parsing where necessary to handle complex message formats. Modernization: Assist in the transition of legacy data processes into AWS Cloud and Databricks. You will be mentored and trained on these modern tools as we evolve our infrastructure. Required Technical Qualifications
Expert-Level SQL: 7+ years of experience with T-SQL (Stored Procs, Views, CTEs, Functions). SSIS & ETL: Proven track record of building and maintaining robust integration packages. XML Processing: Experience working with XML within SQL Server (OpenXML, XQuery) to handle transaction payloads. Relational Database Design: Deep understanding of indexing, normalization, and performance tuning for high-volume databases. Preferred Industry Experience
TSYS Experience: Strong preference for candidates who have worked with TSYS platforms or similar core processors. Settlement & Clearing: A firm grasp of how money moves from a merchant's terminal to their bank account. Chargeback Management: Understanding of the lifecycle of a disputed transaction. Bonus Points (We will train you on these!)
Experience or interest in Databricks/Spark. Familiarity with AWS (S3, Lambda, RDS). Experience with Python or PySpark.
Financial Technology or Card Payment Processing experience is a plus
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.