Enterprise Data Engineer | SQL, Python, Cloud Platforms & Data Migration Support

Job Summary
Synechron is seeking an experienced Data Migration and Data Engineering Specialist supporting large-scale data transformation projects. This role involves leveraging advanced SQL development and Python scripting to support data migration data warehousing and enterprise analytics initiatives. The ideal candidate will design and execute complex data pipelines support cloud-based data environments and apply AI integration techniques to enhance operational efficiency and data quality.

Software Requirements

Required Software Proficiency:

• SQL (Snowflake SQL Server) advanced skills in designing developing and optimizing queries supporting data migration and warehousing (supporting 10 years)

• Python (latest version e.g. Python 3.8) extensive experience scripting automating data workflows and supporting data transformation projects (supporting 10 years)

• Data warehousing technologies supporting scalable data storage and data lakes in Snowflake or SQL Server (support supporting 10 years)

• Data migration tools: supporting complex data conversions migration validation and reconciliation support

Preferred Software Skills:

• Cloud platform support: AWS Azure or GCP supporting data platform migration and cloud-native data management (preferred)

• ETL & Data Pipelines: Talend Informatica or similar supporting large enterprise data integration support

Overall Responsibilities

• Design develop and optimize scalable data pipelines supporting enterprise data migration analytics and compliance needs

• Support data validation reconciliation and cleansing activities ensuring integrity during migration processes

• Collaborate with data architects scientists and business stakeholders to translate business needs into robust data solutions supporting operational and analytical objectives

• Support cloud-based data environments including migration support schema evolution and data platform setup

• Automate data workflows supporting data load transformation and validation operations supporting continuous delivery

• Monitor data pipeline performance troubleshoot failures and optimize for performance and data quality

• Develop and maintain comprehensive documentation for data integrations schemas migration processes and operational workflows

• Support ongoing data quality initiatives data governance and compliance in line with enterprise standards

Technical Skills (By Category)

• Languages & Data Tools (Essential):

  • SQL (Snowflake SQL Server): data validation migration and query optimization support

  • Python: scripting automation of data workflows transformation support

• Databases & Data Management:

  • Relational databases: SQL Server Snowflake supporting enterprise data warehouses and data lakes

  • Data validation reconciliation and schema design supporting data quality and compliance

• Cloud & Infrastructure:

  • AWS Azure or GCP (supporting cloud migration and hybrid architecture) (preferred)

• Data Integration & Migration:

  • Support for ETL tools (Talend Informatica) or scripting frameworks supporting enterprise data migration

• Security & Compliance:

  • Knowledge of encryption data masking access controls supporting data privacy and security standards (e.g. GDPR HIPAA)

Experience Requirements

• 10 years supporting enterprise data warehouses large-scale data migration and analytics solutions

• Proven track record designing executing and supporting complex data pipelines supporting enterprise data platforms

• Extensive experience with SQL Python cloud data migration and data validation in regulated or large enterprise environments supporting compliance standards

• Demonstrated ability to optimize data workflows ensure data integrity and support cloud migration projects supporting operational resilience

Day-to-Day Activities

• Develop test and support data migration pipelines and data validation workflows supporting enterprise projects

• Collaborate with data teams to translate business requirements into scalable and secure data solutions

• Support data platform migrations schema updates and performance tuning activities supporting operational efficiency

• Troubleshoot data discrepancies performance bottlenecks and security gaps supporting compliance and operational resilience

• Automate data loading transformation and reconciliation workflows supporting continuous integration/delivery practices

• Maintain detailed documentation for data schemas workflows migration processes and operational procedures

• Support ongoing data governance initiatives data security and compliance support activities

Qualifications

• Bachelors or Masters degree in Data Science Computer Science or a related field

• 10 years supporting enterprise data management large-scale data migrations and data warehousing in regulated environments

• Certifications supporting cloud data management or enterprise data governance are advantageous (e.g. Snowflake Data Engineer AWS or GCP certifications)

• Proven ability supporting complex data systems supporting high data volumes and enterprise compliance standards

Professional Competencies

• Strong analytical and troubleshooting abilities supporting complex data processes and migration activities

• Leadership skills to guide teams enforce best practices and support enterprise data standards

• Effective stakeholder management and communication skills supporting project requirements and compliance reporting

• Adaptability supporting evolving data standards security protocols and cloud environment enhancements

• Strategic thinking to optimize data workflows ensure data quality and support enterprise analytics and compliance goals

• Organizational skills to support multiple data migration projects schema changes and process improvements in a fast-paced 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