Design, build, and optimize Spark ETL pipelines using Scala/Python and Oracle SQL. Lead and mentor a team of engineers, collaborate with stakeholders on scalable data solutions, ensure data integrity, security, and performance, and stay current on emerging technologies to drive improvements.
Key Responsibilities:
- Develop and optimize Spark ETL pipelines using Scala/Python and Oracle SQL.
- Lead a team of engineers, ensuring best practices and high performance.
- Collaborate with stakeholders to define and implement scalable data solutions.
- Ensure data integrity, security, and performance optimization.
- Stay updated on industry trends and emerging tech to drive continuous improvements.
Required Skills and Qualifications:
- 15+ years of experience in data engineering or related fields.
- Strong expertise in Oracle SQL, including query optimization and performance tuning.
- Hands-on experience with Apache Spark for ETL processing.
- Proficiency in Scala and/or Python for data engineering tasks.
- Experience leading teams, managing projects, and mentoring engineers.
- Solid understanding of data warehousing, distributed computing and cloud platform.
- Strong problem-solving skills and the ability to work in a fast-paced environment.
Preferred Qualifications:
- Familiarity with CI/CD pipelines and DevOps practices
- Knowledge of real-time data processing frameworks like Kafka.
Compensation, Benefits and Duration
Minimum Compensation: USD 64,000
Maximum Compensation: USD 225,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 not 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 • Information Technology
Lead architect to design and implement large-scale, distributed big data solutions using Java and Big Data technologies. Hands-on with Java 1.8+, Apache Spark, MapReduce, Hadoop/Cloudera, Hive, Impala, YARN, and Kafka. Perform data analysis, design scalable architectures, enforce testing (JUnit), and optionally use Unix/Python scripting. Manage global technology teams, apply industry best practices, and communicate effectively across stakeholders.
Top Skills:
SparkClouderaHadoopHiveImpalaJavaJunitKafkaMapreducePythonShell ScriptingYarn
Agency • Information Technology
Lead design and implementation of enterprise data architecture and process-engineered data workflows. Drive integration, modeling, ETL/ELT, governance, compliance (GDPR/HIPAA), cloud solutions, and mentor teams while evaluating emerging tools and automation opportunities.
Top Skills:
AirflowAWSAzureAzure SynapseBigQueryCi/CdDatabricksDevOpsEtl/EltGCPInformaticaInfrastructure-As-CodeNoSQLRedshiftSnowflakeSQLTalend
Agency • Information Technology
Design and architect large-scale distributed data solutions using Spark and Cloudera CDH. Build and optimize ETL pipelines, ensure data integrity/security, troubleshoot performance, and implement version control and CI/CD for Spark applications while collaborating with data scientists and stakeholders.
Top Skills:
SparkCi/CdCloudera CdhData LakeDimensional ModelingETLFlumeGitGitlabHbaseHdfsHiveImpalaJavaJenkinsKafkaNifiNoSQLOoziePostgresScalaSpark SqlSqoop
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
