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

An Hour Ago
Easy Apply
Remote or Hybrid
United States
Easy Apply
104K-175K Annually
Senior level
104K-175K Annually
Senior level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Own and optimize Samsaras identity infrastructure (Okta, Google Workspace, Workato). Design and support integrations/automations, lead IAM initiatives, ensure StateRAMP/FedRAMP compliance, provide Tier 3 escalation, document runbooks, and partner with Security and GRC to strengthen identity security.
Top Skills: GCPGemini EnterpriseGoogle Apps Manager (Gam)Google WorkspaceIgaOktaOkta WorkflowsOwl-ItPamPythonRest ApisSaviyntScimSplunkTerraformVertex AiWorkatoWorkato Connector SdkWorkato One
An Hour Ago
Easy Apply
Remote
USA
Easy Apply
218K-257K Annually
Senior level
218K-257K Annually
Senior level
Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
Design, build, and operate backend systems for prediction markets, including order management, trade matching, settlement, and market resolution. Architect distributed, low-latency systems with strict financial correctness, lead multi-quarter technical projects, mentor engineers, and collaborate with Product, Compliance, and Risk to meet regulatory requirements.
Top Skills: Generative AiGoJava
An Hour Ago
Easy Apply
Remote
USA
Easy Apply
207K-244K Annually
Senior level
207K-244K Annually
Senior level
Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
Lead end-to-end design for Coinbase's CX products (Help Center, Chatbot, Voicebot, in-app Concierge). Define AI-powered support UX, build reusable pattern libraries, drive MVPs and future-state concepts, partner with product/engineering/operations, translate Concierge revenue goals into experience, and generate insights from customers and agents to improve automation and satisfaction.
Top Skills: ChatbotConversational UiDesign SystemFigmaGenerative AiPrototyping ToolsVoicebot

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account