Photon Logo

Photon

ETL Engineer_Woonsocket, RI

Posted 3 Days Ago
Be an Early Applicant
Remote
2 Locations
44K-154K Annually
Senior level
Remote
2 Locations
44K-154K Annually
Senior level
Design, build, and maintain scalable ETL pipelines and Snowflake data warehouses. Develop Python/SQL transformations, use Spark/PySpark for large-scale processing, implement real-time and batch pipelines, ensure data quality, troubleshoot production issues, and support platform modernization and migrations while collaborating with stakeholders.
The summary above was generated by AI

Role Overview:

We are looking for a highly skilled Senior ETL Engineer with strong experience in modern data engineering, data warehousing, and cloud-based data platforms. The ideal candidate will have hands-on expertise in building scalable data pipelines, working with Snowflake, and processing large datasets using distributed frameworks.

Key Responsibilities:

  • Design, develop, and maintain robust ETL pipelines to ingest data from multiple sources (databases, flat files, APIs, Snowflake, etc.)
  • Build and optimize scalable data warehouse solutions using Snowflake or similar platforms
  • Develop data transformation and processing workflows using Python and SQL
  • Work with large-scale distributed data processing frameworks like Spark/PySpark
  • Implement real-time and batch data processing pipelines (Kafka or equivalent tools preferred)
  • Ensure data quality through validation, testing, and monitoring frameworks
  • Troubleshoot and resolve data pipeline and performance issues in production environments
  • Collaborate with business stakeholders and data teams to understand data requirements and deliver solutions
  • Support data platform modernization and migration initiatives

Required Skills:

  • 10+ years of experience in ETL/Data Engineering
  • Strong hands-on experience in Python and SQL
  • Expertise in Snowflake (data warehousing, streams, tasks, optimization)
  • Experience with ETL tools (Talend, Informatica, or similar)
  • Hands-on experience with Apache Spark / PySpark
  • Solid understanding of data warehousing concepts (EDW, Data Marts, OLAP/ROLAP)
  • Experience working with cloud platforms (AWS preferred)
  • Strong debugging, performance tuning, and troubleshooting skills

Good to Have:

  • Experience with Kafka or real-time data streaming tools
  • Exposure to CI/CD pipelines (Jenkins, Git, Groovy)
  • Knowledge of Terraform / CloudFormation
  • Basic exposure to Java / REST APIs / Spring Boot

Soft Skills:

  • Strong communication and stakeholder interaction skills
  • Ability to work in fast-paced, enterprise environments
  • Experience working with cross-functional and global teams

Compensation, Benefits and Duration

Minimum Compensation: USD 44,000
Maximum Compensation: USD 154,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is available for independent contractors
No applications will be considered if received more than 120 days after the date of this post

Similar Jobs

59 Minutes Ago
In-Office or Remote
123K-223K Annually
Mid level
123K-223K Annually
Mid level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Field-driven territory sales role responsible for full-cycle, self-sourced selling: prospecting, in-person demos, closing deals, building pipeline and partnerships, onboarding coordination, and maintaining Salesforce pipeline and forecasts. Spend most of the week in-market, hit weekly visit targets, and exceed quota across Square's product ecosystem.
Top Skills: Salesforce
An Hour Ago
Remote or Hybrid
United States
103K-129K Annually
Mid level
103K-129K Annually
Mid level
HR Tech • Information Technology • Professional Services • Sales • Software
The role involves supporting customers with benefits administration issues, troubleshooting complex problems, and collaborating with multiple teams to improve product functionality and customer experience. Candidates should have a strong background in US benefits administration and exceptional problem-solving skills.
Top Skills: APIsAsanaJIRASaaSSalesforceZendesk
An Hour Ago
Remote
United States
157K-242K Annually
Senior level
157K-242K Annually
Senior level
Security • Software • Cybersecurity • Automation
Lead and scale an enterprise Customer Success team for high-touch SaaS customers. Build CS processes, drive retention and expansion, manage escalations, collaborate cross-functionally, monitor performance metrics, and use data to improve outcomes for strategic accounts.

What you need to know about the Charlotte Tech Scene

Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.

Key Facts About Charlotte Tech

  • Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
  • Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
  • Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
  • Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account