Analytics Consultant

Analytics engineers provide clean data sets to end users, modeling data in a way that empowers users to answer their own questions. While a data analyst spends their time analyzing data, an analytics engineer spends their time transforming, testing, deploying, and documenting data. Data modeling techniques are a part of their skilset. Analytics engineers apply software engineering best practices like version control and continuous integration to the analytics code base.

Required experience and qualifications:

dbt certified

Skilled in data processing

Experience with data modeling and designing conceptual, logical and physical data models

Design EL(T) data pipelines using SQL (dbt certification is adviced)

Is familiar with traditional DW relational concepts (Dimensions, Facts, star schema, snowflake, SCDs)

Understands the fundamentals of distributed data warehousing (Redshift)

git knowledge is a must

DataOps mindset

Experience with Data Vault 2.0 methodology is a plus

python and jinja experience is a plus

CI/CD experience is a plus

DevOps & DataOps skill is a plus

Knowledge of the Pharma Commercial Data landscape is a plus