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.
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
Photon New York, New York, USA Office
New York, United States
Similar Jobs
Agency • Artificial Intelligence • Consumer Web • Digital Media • Analytics • Design
Manage end-to-end paid media campaigns across multiple clients and channels, including strategy, setup, optimization, tracking, and reporting. Analyze performance data, maintain tracking (GA4/Tag Manager), build reports and dashboards, and present insights to clients. Collaborate with account, creative, and analytics teams to drive growth and improve ROI while staying current on platform best practices.
Top Skills:
Conversions ApiFacebook/Meta AdsGoogle AdsGoogle Analytics (Ga4)Google Looker StudioGoogle SheetsGoogle Tag ManagerLinkedin AdsMicrosoft/Bing AdsPerformance MaxPinterest AdsProgrammatic AdvertisingReddit AdsTwitter/X AdsYoutube Ads
.png)
Artificial Intelligence • Big Data • Healthtech • Machine Learning • Software • Biotech
The GRAIL Galleri Consultant will drive territory growth by engaging healthcare providers, executing the sales strategy for the Galleri product, and managing customer relationships.
Top Skills:
Google Suite
eCommerce • Fashion • Retail • Sales • Wearables • Design
Lead daily store operations to drive sales, profitability, and exceptional customer service. Recruit, coach, and develop a high-performing team; manage inventory, payroll, loss prevention, visual merchandising, scheduling, and local business plans. Serve as brand ambassador and ensure inclusive, results-driven store culture.
Top Skills:
Inventory Management SystemsLabor Management SystemsMS OfficeSales Reporting ToolsSocial Media
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
