Photon Logo

Photon

ETL Engineer_Woonsocket, RI

Posted Yesterday
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
Remote
United States
114K-144K Annually
Senior level
114K-144K Annually
Senior level
Fintech • Financial Services
Own BI analytics using a modern data stack to generate insights, build dashboards and self-serve tools, partner with stakeholders, and deploy AI-driven reporting and natural-language query solutions.
Top Skills: ClaudeExcelSalesforceSnowflakeSnowflake IntelligenceSQLTableau
An Hour Ago
Remote
USA
30-34 Hourly
Junior
30-34 Hourly
Junior
eCommerce • Retail
Manage and optimize the affiliate program: recruit and onboard partners, monitor activity and compliance, analyze performance and report insights, grow network revenue, manage tracking platforms, and coordinate partner-facing content and training.
Top Skills: ImpactLookerPower BIRakutenTableau
An Hour Ago
Remote or Hybrid
120K-150K Annually
Senior level
120K-150K Annually
Senior level
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Partner with Finance, Accounting, and Revenue Operations to design and deliver Power BI analytics, semantic models, and decision support for forecasting, close, revenue, and spend analysis. Translate finance concepts into metrics, reconcile data across systems, collaborate with data engineering, and apply AI-assisted tools to automate and scale finance analytics for executives and business partners.
Top Skills: AdaptiveAnaplanClaudeDaxMicrosoft CopilotNetSuiteOnestreamPower BISalesforceSnowflakeSQL

What you need to know about the Austin Tech Scene

Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.

Key Facts About Austin Tech

  • Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
  • Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
  • Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
  • Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account