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)