
Senior Data Engineer
SmartAsset
full-time
Posted on:
Location Type: Remote
Location: New York • United States
Visit company websiteExplore more
Salary
💰 $135,500 - $200,000 per year
Job Level
About the role
- Architect, design, implement, and operate end-to-end data engineering solutions using Agile methodology
- Develop and manage robust data integrations with external vendors and organizations (including complex API integrations)
- Collaborate closely with Data Analysts, Data Scientists, DBAs, and cross-functional teams to understand requirements and deliver high-impact data solutions
- Lead and take ownership of assigned technical projects in a fast-paced environment
- Drive continuous improvement in the quality, security, efficiency, and scalability of our data pipelines and infrastructure
Requirements
- 7+ years of hands-on experience in data engineering
- Bachelor of Science degree in Computer Science or equivalent practical experience
- 4+ years of dedicated experience building and maintaining complex ETL/ELT pipelines
- 3+ years of Python development experience, specifically building production-grade data APIs using FastAPI or similar frameworks
- Strong expertise in SQL, including advanced query optimization and performance tuning
- Expert-level proficiency in dbt implementation, including managing models, macros, and incremental and dynamic tables
- Extensive hands-on experience with Snowflake, including performance optimization, data recovery using Time Travel, and advanced data modeling techniques
- Practical experience with key AWS data services such as Kinesis, Firehose, Redshift, Spectrum, Elastic MapReduce, and Lambda; and container orchestration services like ECS and EKS for deploying and managing data applications
Benefits
- Medical, Dental, Vision - multiple packages available based on your individualized needs
- Life/AD&D Insurance - basic coverage at 100% company paid, additional supplemental available
- Supplemental Short-term and Long-term Disability
- FSA: Medical and Dependant Care
- 401K
- Equity packages for each role
- Time Off: Vacation, Sick and Parental Leave
- EAP (Employee Assistance Program)
- Financial Literacy Mentoring Program
- Pet Insurance
- Home Office Stipend
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data engineeringETLELTPythonSQLdbtFastAPIdata modelingAPI integrationsAgile methodology
Soft Skills
collaborationleadershipownershipcontinuous improvementcommunication
Certifications
Bachelor of Science in Computer Science