Sr. Data Engineer

Sr. Data Engineer

Archetype’s Analytics Insights consulting practice develops insights for our customers through innovative technology solutions. Archetype sees the value in data science and self-service analytics, providing these capabilities to our customers. At Archetype, you will get to work with the best of breed products that include Snowflake, AWS, Azure, GCP Fivetran, dbt, Tableau, ThoughtSpot, Dataiku, DataRobot and partner with our strong growing consulting team.

Job Description

We are seeking a Senior Data Engineer (Architect level) to work with our customers to solve complex problems with well-designed, modern analytical solutions. This role’s responsibilities include:

  • Working with customers and data analysts, product managers, data architects and engineers to define requirements, design solutions, and build/test/deploy these solutions

  • Be deep and broad with your technical and functional skill set to support end-to-end analytics across a variety of industries

  • Stay up to speed on emerging technologies and dynamic in how we evolve our approach for our customers

  • Support sales processes by participating in scoping calls, solution design workshops, developing estimates and prototyping solutions

  • Support project management and mentor/manage junior resources.

  • Research, design and write new software components

  • Create technical specifications

  • Maintain systems by monitoring and correcting software defects


Required Qualifications: (Must Have)

  • 5+ years of experience in database and data pipeline development

  • Proven experience working with both cloud and on-premise DBMSs such as: Snowflake, RedShift, BigQuery, SQL Server, Postgres, and Oracle

  • Code development in a version control environment

  • Proven experience with working with structured and semi-structured data

  • Hands-on experience working with and creating REST web services and APIs

  • 2+ years of experience hands-on experience creating serverless applications on AWS using Lambda or Azure Functions and NodeJS

  • Top 5% of SQL practitioners


Preferred Qualifications: (Nice-To-Have)

  • Comfort with scripting languages (JavaScript, Python, or Ruby)

  • Comfort with Linux and Windows command line functionality

  • Exposure to multiple cloud providers: AWS, Azure, Google Cloud

  • Knowledge of common design patterns and how they can be applied to JavaScript.

  • Experience working with APIs, either integrating a third-party API

  • Facility with source control, particularly git and Github

  • Strong independent problem-solving skills

  • Knowledgeable of best practices, with the ability to convey to non-practitioners

  • Champions modern, disciplined development process (agile, source control, testing, CI/CD)

Apply Now