RESPONSIBILITIES Create and maintain optimal data pipeline architecture Assemble large, complex data sets that meet functional / non-functional businessrequirements. Identify, design, and implement internal process improvements: automating manualprocesses, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Build the infrastructure required for optimal extraction, transformation, and loading ofdata from a wide variety of data sources using SQL and AWS ‘big data’ technologies. Build analytics tools that utilize the data pipeline to provide actionable insights intocustomer acquisition, operational efficiency and other key business performance metrics. Work with stakeholders across the organization to assist with data-related technical issuesand support their data infrastructure needs. Create data tools for analytics and data scientist team members that assist them inbuilding and optimizing our product into an innovative industry leader. Work with data and analytics experts to strive for greater functionality in our datasystems. TECHNICAL REQUIREMENTS Advanced working SQL knowledge and experience working with relational databases,query authoring (SQL) as well as working familiarity with a variety of databases. Experience building and optimizing ‘big data’ data pipelines, architectures and data sets. Experience performing root cause analysis on internal and external data and processesto answer specific business questions and identify opportunities for improvement. Strong analytic skills related to working with unstructured datasets. Build processes supporting data transformation, data structures, metadata, dependencyand workload management.  A successful history of manipulating, processing and extracting value from largedisconnected datasets. Working knowledge of message queuing, stream processing, and highly scalable ‘bigdata’ data stores. Strong project management and organizational skills. Experience supporting and working with cross-functional teams in a dynamicenvironment. We are ideally looking for a candidate with 3+ years of experience in a Data Engineerrole. While our systems are still evolving and architecture will change, the most competitivecandidates will have experience in many of the technologies we use today or arecurrently exploring:o GraphQL (preferred)o Postgres (must have)o Azure EDW (must have) Azure Data Factory SQL Server PowerBIo Tableau or AWS Quicksight (must have)o Excel/Google Sheetso Metabase (preferred)o Redshift (preferredo AWS DMS (preferred) NICE TO HAVE Salesforce  JavaScript Streaming/event-based tech experience: Kafka, AWS SQS, etc. Geospatial experience, such as PostGIS (for Postgres)

Start your professional career with us

At Rootstack, we are focused on creating the technologies of the present and the future that help our clients elevate their digital presence. With a work culture focused on success, we put our employees first and we will focus on your growth within the company, always motivating you to achieve greatness.

First name *

Last name *

E-mail *

Phone *

CV *

Select a file

English level *You can take a quick 15 minutes test here:https://www.efset.org/quick-check/

Primary role

Department *

This is the role for which you are applying: the one you are performing right now or you think you already have enough experience to be considered for the position.

Role *

Years of experience*

This section is for the recruitment of Rootstack employees. We are not responsible for any information you provide. We will not share your information with any third party. We will not be liable for any loss or damage arising from the use of this application.