SmartAsset
An award-winning financial technology company that helps millions of people make smart financial decisions.
Senior Data Engineer
Location
New York
Posted
48 days ago
Salary
$135.5K - $200K / year
Bachelor Degree7 yrs expEnglishAmazon RedshiftAWSETLMap ReducePythonSQL
Job Description
• 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
Job 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