
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
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
- 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
- All roles at SmartAsset are currently and will remain remote - flexibility to work from anywhere in the Contiguous US.
- 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 engineeringETLELTPythonFastAPISQLdbtSnowflakeAWSdata APIs
Soft Skills
collaborationleadershipownershipcontinuous improvementcommunication
Certifications
Bachelor of Science in Computer Science