Senior Python Developer with SQL & Teradata exp. - #fulltime

Smart IT Frame LLC; Charlotte (NC); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Smart IT Frame LLC is seeking a Senior Python Developer with strong SQL and Teradata experience in Charlotte, NC. The role involves designing and optimizing data solutions while maintaining Python scripts, writing complex SQL queries, and collaborating with teams to ensure efficient data processing. Ideal candidates will have proven skills in Python, SQL, and Teradata, along with familiarity with ETL processes. A hybrid work model allows flexibility, working 3 days on-site per week from day one.

Qualifications

• Proficiency in Python programming.
• Strong knowledge of SQL (query writing, optimization, joins, indexing).
• Hands-on experience with Teradata databases.
• Familiarity with ETL processes and data warehousing concepts.
• Ability to work independently and in a team environment.
• Good problem-solving and communication skills.

Responsibilities

• Develop and maintain Python scripts for data processing and automation.
• Write and optimize complex SQL queries for large datasets.
• Work with Teradata to design, implement, and manage data pipelines.
• Collaborate with data engineers, analysts, and business teams to deliver reliable solutions.
• Troubleshoot performance issues and ensure data accuracy.
• Document processes and maintain code quality standards.

Skills

Python programming

SQL (query writing, optimization, joins, indexing)

Teradata databases

ETL processes

Data warehousing concepts

Problem-solving

Communication skills

Tools

ETL tools

Cloud platforms (AWS, Azure, GCP)

Big data tools (Hadoop, Spark)

Job description

Job: Senior Python Developer with SQL and Teradata exp.

Location: Charlotte, NC (Hybrid 3 Days/week from day1)

Overview

We are looking for a skilled Python Developer with strong SQL and Teradata experience to join our team. The ideal candidate will design, develop, and optimize data solutions, ensuring efficient data processing and integration across systems.

Key Responsibilities

• Develop and maintain Python scripts for data processing and automation.
• Write and optimize complex SQL queries for large datasets.
• Work with Teradata to design, implement, and manage data pipelines.
• Collaborate with data engineers, analysts, and business teams to deliver reliable solutions.
• Troubleshoot performance issues and ensure data accuracy.
• Document processes and maintain code quality standards.

Required Skills & Experience

• Proficiency in Python programming.
• Strong knowledge of SQL (query writing, optimization, joins, indexing).
• Hands‑on experience with Teradata databases.
• Familiarity with ETL processes and data warehousing concepts.
• Ability to work independently and in a team environment.
• Good problem‑solving and communication skills.

Preferred Qualifications

• Experience with other databases (e.g., Oracle, MySQL, PostgreSQL).
• Knowledge of cloud platforms (AWS, Azure, GCP).
• Exposure to big data tools (Hadoop, Spark).