Enterprise Data Engineer | SQL, ETL, Cloud Platforms & Data Governance

Job Summary
Synechron is seeking an experienced Data Mart Developer specialized in Cards and Payments data environments. This role involves designing, developing, and maintaining scalable data marts supporting regulatory, operational, and analytics reporting. The ideal candidate will leverage extensive knowledge of payment transaction workflows, database modeling, and ETL processes to build high-quality, reliable data solutions that support enterprise decision-making and compliance standards.

Software Requirements
 

Required Software Proficiency:

• SQL (MySQL, Oracle, SQL Server, PostgreSQL) — strong skills in schema design, complex queries, and performance tuning supporting data validation and reconciliation (supporting 4+ years)

• ETL tools: Informatica PowerCenter, SSIS, Talend, or equivalent — extensive experience in developing, deploying, and maintaining scalable data pipelines supporting large transaction volumes (supporting 4+ years)

• Data warehousing concepts: star schema, snowflake, SCDs — deep understanding for designing enterprise data marts supporting analytics and compliance

• Database management and Data Governance tools supporting data quality, lineage, and security (preferred)

Preferred Software Skills:

• Cloud data platforms such as AWS Redshift, Snowflake, or Azure Synapse supporting cloud migration and scalable data warehousing (preferred)

• Data validation and reconciliation tools supporting enterprise audits and data integrity

Overall Responsibilities

• Design, develop, and optimize data marts supporting client reporting, analytics, and regulatory compliance in enterprise environments

• Build scalable, high-performance ETL/ELT processes for extracting, transforming, and loading large transaction data supporting payments, securities, and trading systems

• Collaborate with data architects, business analysts, and stakeholders to translate business needs into scalable data solutions and schemas

• Support data migration, schema design, and data validation activities supporting compliance standards such as PCI DSS and industry regulations

• Implement data governance, lineage, and security standards supporting audit and compliance requirements

• Monitor data pipelines for performance, troubleshoot issues, and optimize for efficiency and scalability

• Automate data workflows and processes supporting continuous data integration and delivery

• Maintain detailed documentation of data architecture, workflows, validation procedures, and operational procedures

Technical Skills (By Category)

• Languages & Data Tools (Essential):

  • SQL (MySQL, Oracle, PostgreSQL, SQL Server): schema design, complex query development, data validation

  • Metadata management and data lineage tools supporting compliance and operational transparency

• Data & Warehouse Management:

  • Data modeling, data validation, reconciliation, supporting compliance standards (PCI DSS, GDPR)

• ETL and Data Pipelines:

  • ETL tools: Informatica PowerCenter, SSIS, Talend — for scalable data workflows supporting large enterprise systems

• Cloud Platforms (Preferred):

  • AWS (Redshift, S3), Azure (Synapse), or GCP supporting cloud data migration and scalability support

• Data Processing & Migration Technologies:

  • Support for big data frameworks supporting large data volumes and high throughput (preferred)

Experience Requirements

• 4+ years of experience supporting enterprise data marts, large-scale data pipelines, and financial or transactional data systems

• Proven experience designing, implementing, and maintaining data marts supporting analytics and compliance efforts

• Knowledge supporting migration to cloud data platforms and enterprise data governance practices (preferred)

• Deep understanding of payment workflows, transaction data, and regulatory data management (preferred)

Day-to-Day Activities

• Develop, support, and optimize scalable data marts supporting regulatory reporting, analytics, and data migration

• Collaborate with stakeholders to gather requirements and translate business needs into scalable data schemas and pipelines

• Support data migration activities, schema design, validation, and reconciliation processes supporting compliance standards

• Troubleshoot data discrepancies and pipeline failures, performing root cause analysis and resolution

• Automate data processing workflows supporting data integration and operational efficiency

• Monitor data pipeline performance, optimize query and data load processes, and support operational resilience

• Document data architecture, schemas, validation procedures, and operational support support support

Qualifications

• Bachelor’s or Master’s degree in Data Science, Computer Science, or an equivalent technical discipline

• 4+ years of experience supporting enterprise data environments, data marts, and large-scale data pipelines

• Certifications in data management, cloud hosting, or enterprise data warehousing are a plus

• Proven track record supporting high-volume, compliant, enterprise data management systems supporting enterprise growth

Professional Competencies

• Strong analytical and troubleshooting skills supporting complex data quality and reconciliation issues

• Leadership qualities to guide and mentor junior engineers supporting data governance and operational excellence

• Excellent stakeholder communication skills supporting requirements gathering and compliance documentation

• Adaptability to evolving data standards, cloud platforms, and security regulations supporting enterprise compliance

• Strategic thinking supporting scalable, secure, and compliant enterprise data solutions supporting business objectives

• Organizational skills for managing multiple data pipelines, schema changes, and migration activities effectively in a regulated environment

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT
 

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice