Cloud Data Warehouse Consultant

Sonra is looking for a cloud data warehouse consultant
Join our growing team of the best data experts on the planet
Work on data warehouse projects in Ireland, EMEA, North America, Asia (remote)
The position is permanent and full time (Ireland or Poland)
Starting asap

What you will do:

You will lead the implementation of cloud data warehouse projects with our clients
You will cover the following aspects of the data warehouse life cycle:

  • Collect business requirements and document them in a spec
  • Data exploration of source systems, e.g. using SQL
  • Data modeling and dimensional modeling
  • Source to target maps
  • Work on the design and architecture of the solution with the data architect
  • System integration testing

You will lead a small team (1-3) of data engineers
Mentor other team members

What you must know

Very solid data warehouse knowledge required. Skills around cloud data warehousing are optional
Good experience collecting and documenting business requirements
Very good understanding of the data warehouse lifecycle and associated tasks
Good understanding of data warehouse architecture
Good understanding of data modeling and dimensional modeling
Good understanding of relational databases and data warehouse platforms
Good knowledge of advanced SQL (window functions etc.)

Nice to have skills

Experience with Cloud Computing, e.g. AWS or Azure
Experience with a scripting language, e.g. Python

Personal Qualities:

Passion for data
Very good communication skills
Strong analytical and problem solving skills
Think out of the box. Unconventional and non mainstream thinking
Explore and evaluate new ideas and technologies
Demonstrated ability to work independently
Strong affinity for teamwork and empowering fellow team members.

About Sonra

Sonra offers products and services in data management. We liberate data from silos to solve business problems.
Our offices are on the TU Dublin campus (Dublin 7, Grangegorman, near city centre). We work remotely at the moment.
Experience startup culture in a diverse and international team
20% of effort delivers 80% of results. Perfection is a good goal but making progress is better.
We are a fast growing company with plenty of career opportunities, e.g. data advisory or management
We only work with the best of breed technologies, e.g. Snowflake, Airflow, AWS, Azure, GCP, Qlik Replicate, Fivetran, Power BI
At Sonra we are passionate about data. We love taking challenges. We help each other if stuck on a problem.
Sonra has flat hierarchies and an open culture. We appreciate employees who can think for themselves and provide constructive feedback.

Interview process

  • Submit CV with your cover letter, salary expectations and start date
  • General interview call where we get to know each other
  • Data Warehouse Test
  • Technical interview