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 Chicago, Illinois, USA Office
11 East Adams Street Suite 1100, Chicago, IL, United States, 60603
Similar Jobs
Cloud • Information Technology • Security • Software • Cybersecurity
Lead the enterprise data platform strategy and architecture, driving Snowflake/dbt-based platform evolution, self-service Data Mesh and medallion models. Build AI-ready pipelines, RAG systems, and observability/cost frameworks while managing a central data team, supporting federated BI, and executing hands-on technical work.
Top Skills:
AiopsAutomated TestingCi/CdCortexData MeshDbtGitGraph RagMatillion Data Productivity Cloud (Matillion Dpc)Medallion ArchitecturePythonRetrieval-Augmented Generation (Rag)SnowflakeSnowparkSQLStreamlit
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Design and develop FPGA systems using VHDL and vendor toolchains. Create testbenches and perform simulation with QuestaSim, perform lab verification and debugging, manage configurations with Git, provide architectural input, and mentor/lead a team of engineers on communications-related FPGA projects.
Top Skills:
GitIntel QuartusLinuxMentor Graphics QuestasimVhdlWindowsXilinx Vivado
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Lead and deliver enterprise-scale IT projects (infrastructure modernization, cloud migration, cybersecurity, compliance) across the project lifecycle. Manage schedules, EVM, budgets, vendors, resources, risks, stakeholder engagement, change management, and benefits realization. Drive agile execution and executive communications.
Top Skills:
AgileCloud MigrationEarned Value Management (Evm)ExcelMicrosoft ProjectPowerPointServicenow SpmWord
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
