Photon Logo

Photon

ETL Engineer_Woonsocket, RI

Posted 2 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

43 Minutes Ago
Remote or Hybrid
TN, USA
160K-192K Annually
Expert/Leader
160K-192K Annually
Expert/Leader
Information Technology
Sell CDW Security services and products across the full sales lifecycle. Develop strategic account plans, build relationships with enterprise clients and partners, manage pipeline and forecasts in Salesforce, coordinate cross-functional resources, mentor junior sellers, represent CDW at events, and achieve bookings, revenue, and profit targets while tracking market trends and driving customer security program adoption.
Top Skills: AICloud SecurityData PrivacyEmerging Security TechnologiesIdentity And Access ManagementPhysical SecuritySalesforceSecure InfrastructureThird-Party Risk ManagementThreat And Vulnerability Management
43 Minutes Ago
Remote or Hybrid
FL, USA
160K-192K Annually
Expert/Leader
160K-192K Annually
Expert/Leader
Information Technology
Sell CDW Security services and products, manage full sales lifecycle, develop strategic account plans, build and grow client and partner relationships, coordinate internal resources, maintain Salesforce pipeline and forecasts, mentor junior sellers, represent CDW at industry events, and meet bookings, revenue, and profit targets.
Top Skills: AICloud SecurityCyber Workforce DevelopmentEmerging Security TechnologiesIdentity And Access ManagementPhysical SecurityPrivacyRisk And ComplianceSalesforceSecure InfrastructureThird-Party Risk ManagementThreat And Vulnerability Management
44 Minutes Ago
Remote or Hybrid
CA, USA
160K-192K Annually
Expert/Leader
160K-192K Annually
Expert/Leader
Information Technology
Sell CDW Security services and products through full sales lifecycle management: strategic account planning, opportunity qualification, relationship building, partnering with services and OEMs, pipeline forecasting, and closing. Mentor junior team members, engage partners and marketing, maintain Salesforce, represent CDW at industry events, and drive revenue, bookings, and gross profit targets.
Top Skills: Salesforce

What you need to know about the Seattle Tech Scene

Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.

Key Facts About Seattle Tech

  • Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Amazon, Microsoft, Meta, Google
  • Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Madrona, Fuse, Tola, Maveron
  • Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account