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

• Bachelors or Masters 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

SYNECHRONS 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 applicants gender gender identity sexual orientation race ethnicity disabled or veteran status or any other characteristic protected by law.

Candidate Application Notice