Cloud Data Warehouse Consultant

Uli Bethke Uncategorized

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

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.