SmartAsset

Data Engineer

SmartAsset

full-time

Posted on:

Location Type: Remote

Location: New YorkUnited States

Visit company website

Explore more

AI Apply
Apply

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

  • 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