Python Developer (ETL Pandas, SQL, Data Pipelines & Automation)

Job Summary

Synechron is seeking a detail-oriented and analytical Python Developer to join our data team. In this role, you will design, develop, and optimize data pipelines, analysis tools, and workflows that support key business and analytical functions. Your expertise in data manipulation, database management, and scripting will enable the organization to enhance data accuracy, efficiency, and insights. This position offers an opportunity to work closely with data analysts and scientists to build scalable, reliable data solutions that contribute directly to business decision-making and operational excellence.

Software Requirements

Required Skills:

• Python (version 3.7 or higher) with experience in data processing and scripting
• Pandas library (experience in large dataset manipulation and analysis)
• SQL (proficiency in writing performant queries for data extraction and database management)
• Data management tools and databases such as MySQL, PostgreSQL, or similar relational databases
  
  

Preferred Skills:

• Experience with cloud data services (AWS RDS, Azure SQL, GCP Cloud SQL)
• Knowledge of additional Python libraries such as NumPy, Matplotlib, or Jupyter Notebooks for data analysis and visualization
• Data pipeline orchestration tools (e.g., Apache Airflow)
• Version control tools like Git
  
  

Overall Responsibilities

• Develop, test, and maintain Python scripts for ETL processes and data workflows
• Utilize Pandas to clean, analyze, and transform large datasets efficiently
• Write, optimize, and troubleshoot SQL queries for data extraction, updates, and management
• Collaborate with data analysts and scientists to create data-driven analytic tools and solutions
• Automate repetitive data workflows to increase operational efficiency and reduce errors
• Maintain detailed documentation of data processes, pipelines, and procedures
• Troubleshoot data discrepancies, pipeline failures, and database-related issues efficiently
• Support ongoing data quality initiatives by identifying and resolving data inconsistencies
  
  

Technical Skills (By Category)

Programming Languages:

• Required: Python (3.7+), proficiency with data manipulation and scripting
• Preferred: Additional scripting languages such as R or familiarity with other programming environments
  
  

Databases/Data Management:

• Relational databases: MySQL, PostgreSQL, or similar
• Experience with query optimization and database schema design
  
  

Cloud Technologies:

• Preferred: Basic experience with cloud data services (AWS, Azure, GCP) for data storage and processing
  
  

Frameworks and Libraries:

• Pandas, NumPy, Matplotlib, Jupyter Notebooks for data analysis and visualization
• Airflow or similar orchestration tools (preferred)
  
  

Development Tools and Methodologies:

• Git or similar version control tools
• Agile development practices and collaborative workflows
  
  

Security Protocols:

• Understanding of data privacy, confidentiality, and secure coding practices
  
  

Experience Requirements

• 3+ years of experience in Python development with a focus on data processing and management
• Proven hands-on experience in building and supporting ETL workflows and data pipelines
• Strong experience working with SQL and relational databases
• Demonstrated ability to analyze and manipulate large datasets efficiently
• Familiarity with cloud data services is advantageous but not mandatory
  
  

Day-to-Day Activities

• Write and enhance Python scripts to perform ETL, data transformation, and automation tasks
• Design and optimize SQL queries for data extraction and updates
• Collaborate with data analysts, scientists, and team members during daily stand-ups and planning sessions
• Investigate and resolve data quality issues or pipeline failures promptly
• Document data pipelines, workflows, and processes for clarity and future maintenance
• Assist in developing analytical tools and dashboards for business insights
• Review code changes through peer reviews and ensure adherence to best practices
• Participate in continuous improvement initiatives related to data workflows and processing techniques
  
  

Qualifications

• Bachelor’s degree in Computer Science, Data Science, Information Technology, or a related field
• Relevant certifications or training in Python, data engineering, or database management are a plus
• Proven track record of working on data pipelines, analysis, and automation projects
  
  

Professional Competencies

• Strong analytical and problem-solving skills with attention to detail
• Effective communication skills, able to collaborate across teams and explain technical concepts clearly
• Ability to work independently and prioritize tasks effectively
• Continuous learner, eager to adopt new tools, techniques, and best practices in data processing
• Adaptability to changing project requirements and proactive in identifying process improvements
• Focused on delivering high-quality work with a results-oriented approach
  
  

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