TMS LLC Logo

TMS LLC

Data Engineer - Python, PySpark, SQL, Snowflake & API Integration

Posted Yesterday
Be an Early Applicant
In-Office or Remote
Hiring Remotely in Toronto, ON
Mid level
In-Office or Remote
Hiring Remotely in Toronto, ON
Mid level
Build and optimize scalable data pipelines and cloud-based data solutions using Python, PySpark, SQL, and Snowflake. Integrate REST APIs and external data sources, develop ETL/ELT workflows, optimize Snowflake queries, and implement data quality, validation, monitoring, and automation. Collaborate with engineering and analytics teams to deliver reliable data platforms.
The summary above was generated by AI
Job Description

Data Engineer - Python, PySpark, SQL, Snowflake & API Integration

Job Description:

We are seeking a skilled Data Engineer with strong hands-on experience in Python, PySpark, SQL, Snowflake, and API integrations to build scalable data pipelines and cloud-based data solutions.

Key Responsibilities:

  • Design, develop, and optimize data pipelines using Python, PySpark, SQL, and Snowflake.
  • Integrate REST APIs and external data sources into Snowflake-based data platforms.
  • Build and maintain ETL/ELT workflows for data ingestion, transformation, and processing.
  • Develop efficient SQL queries and optimize Snowflake performance.
  • Implement data quality, validation, monitoring, and automation.
  • Collaborate with engineering and analytics teams to deliver reliable data solutions.

Required Qualifications:

  • 3+ years of experience in Data Engineering.
  • Strong hands-on expertise in Python, PySpark, SQL, and Snowflake.
  • Experience with REST APIs, JSON, and API-based data integration.
  • Knowledge of ETL/ELT processes, data modeling, and data warehousing.
  • Experience with cloud platforms such as AWS, Azure, or GCP is preferred.

 

Additional Information

All your information will be kept confidential according to EEO guidelines.

Similar Jobs

2 Hours Ago
Remote or Hybrid
CA, USA
223K-335K Annually
Expert/Leader
223K-335K Annually
Expert/Leader
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Leads and develops an enterprise sales team responsible for strategic seller acquisition, pipeline generation, complex deal execution, forecasting, and revenue outcomes. Builds repeatable sales motions, coaches Enterprise Account Executives, manages territory and account strategies, leads high-value negotiations, and partners cross-functionally with product, legal, finance, marketing, implementation, and customer success teams. Uses market insight to influence product, pricing, partnerships, and go-to-market strategy.
Top Skills: AIAPIsAutomationDataFintechIntegrationsPaymentsSaaS
9 Hours Ago
Remote or Hybrid
150K-192K Annually
Senior level
150K-192K Annually
Senior level
Artificial Intelligence • Information Technology • Machine Learning • Natural Language Processing • Productivity • Software • Generative AI
Build and operate high-throughput backend services for AI agent orchestration, calendar systems, real-time infrastructure, APIs, and data pipelines. Design scalable platform services, infrastructure as code, and highly available production systems using Go, PostgreSQL, Kubernetes, and cloud platforms. Collaborate with AI, product, and frontend teams to deliver AI-powered features, contribute to reliability and testing practices, and mentor junior engineers.
Top Skills: AWSAzureCi/CdClaude CodeCursorGCPGithub CopilotGoInfrastructure As CodeKubernetesPostgres
10 Hours Ago
Remote
180K-283K Annually
Expert/Leader
180K-283K Annually
Expert/Leader
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Leads an enterprise account executive team, setting sales strategy, revenue goals, performance metrics, and development plans. The role recruits and coaches sales professionals, manages key client relationships and negotiations, analyzes market and sales data, collaborates with internal partners, and reports performance to senior leadership. It also drives enterprise market expansion, optimizes sales processes, and promotes consultative, value-based selling.
Top Skills: CRMPipeline ManagementSales Analytics Tools

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account