Design, build, and optimize scalable cloud data pipelines and infrastructure. Maintain and refactor SQL and ETL processes, automate data workflows, ensure data quality/security, and troubleshoot complex issues. Provide technical leadership and mentor junior engineers while collaborating with stakeholders to translate requirements.
Summary:
The Senior Data Engineer designs, builds, and optimizes scalable data pipelines and cloud-based data infrastructure. This role is critical to managing and organizing structured and unstructured data across the organization to enable outcomes analysis, insights, compliance, reporting, business intelligence, and data science. The Senior Engineer ensures data quality, security, and performance across platforms while providing technical leadership and mentorship to junior engineers.
Essential Duties & Responsibilities:
- Design and build efficient, scalable data pipelines using cloud services
- Maintain and refactor complex SQL and ETL processes in enterprise data platforms
- Develop automation scripts, APIs, and infrastructure components
- Collaborate with architects, analysts, and stakeholders to translate requirements
- Ensure strong data quality, integrity, and security controls across platforms
- Troubleshoot complex data issues and lead root cause analysis
Skills & Competencies:
- Advanced SQL and strong data modeling expertise
- Proficiency in Python or JVM languages for data engineering and automation
- Deep knowledge of cloud-based data patterns, distributed systems, and modern data architectures
- Strong analytical reasoning and problem-solving abilities
- Ability to lead delivery efforts and mentor junior team members
- Clear communication skills with the ability to explain technical concepts to non-technical audiences
- Ability to work independently and collaborate effectively in cross-functional environments
Minimum Qualifications:
- Bachelor’s degree in Information Systems, Computer Science, Data Management, or related field preferred
- 5–8 years of experience in data engineering or a similar role
- Strong SQL skills and deep knowledge of relational databases and data warehousing
- Proficiency in Python or JVM languages (e.g., Java, Scala, Kotlin) for data manipulation and automation
- Hands-on experience with cloud data platforms (e.g., AWS, Azure, or GCP)
- Solid understanding of ETL/ELT processes, data modeling, and data architecture
- Track record of owning and leading technical projects
- Experience with Agile methodologies and version control
Similar Jobs
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Build and maintain ETL/ELT pipelines to move product data into analytics-ready stores (Postgres, data lake, warehouse). Design and optimize data models, ensure data quality and documentation, support ad-hoc research requests, and collaborate with research and engineering teams to enable reproducible analytics.
Top Skills:
Analytics WarehouseData LakeEltETLJsonbPostgresSQL
Artificial Intelligence • Cloud • Software • Infrastructure as a Service (IaaS)
Design and implement scalable data pipelines and a SOC2-compliant data warehouse. Support analytics and ML teams, enable real-time and batch ETL, mentor data engineers, and collaborate cross-functionally to drive data-driven decisions.
Top Skills:
DagsterDatabricksDbtLlmsPlanetscaleRedshiftSnowflakeSoc2Tinybird
AdTech • Artificial Intelligence • Marketing Tech • Software • Analytics
Build, deploy, and operate production-grade data pipelines and data products for healthcare audiences. Design transformations, data models, and governed views using Python, SQL, Airflow, S3, Snowflake, and EMR. Implement data-quality, monitoring, and privacy-by-design controls for PHI/PII. Partner with product, analytics, and platform teams to onboard sources, support audience discovery, segmentation, activation, measurement, and troubleshoot production issues.
Top Skills:
Amazon EmrAmazon S3Apache AirflowAthenaHivePythonSnowflakeSQL
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
