Description
I am looking for a data analyst/data engineer. This role is fully remote and may possibly have the onsite requirement once a week or once every fortnight once Codiv improved. This can be in either Sussex or Kent.
Project Details
This project aims to deliver a data solution that enables timely access to all our data sources, which is stored in a centralised single source of truth, in an efficient and easy to understand format, from which all our BI and analysis flows.
Data Ingestion: To load appropriate data points from our existing source systems, including (but not limited to) Dev Azure Production database, Google Analytics, Orchestrated Spirits, and Zaius; into Snowflake, in a timely fashion to deliver value to the end Power BI users, through utilising the Rivery.io tool in the most effective and efficient manner.
Data Integration To combine the various ingested data sources into a consolidated and co-ordinated FACT and DIM database structure within our Snowflake data warehouse, the design of which should facilitate the delivery of value to the end Power BI users.
Data Democratisation To slice and aggregate the data contained within the FACT and DIM database structure, in order to produce Power BI datasets, through which users can self-serve answers to the majority of their day-to-day business queries.
Skills & Toolsets:
- SnowSQL, Snowflake, SQL, SQL Server on Azure
- Google Analytics, BigQuery, extraction APIs
- Rivery.io, AWS S3
- GitHub, Git
- Javascript (Stored Procedures in Snowflake)
- Sqitch & Linux or Snowchange & Python (potentially for automated deployment)
- Power BI Desktop, DAX expressions
- Tabular Editor
If this sounds of interest, please send your CV for review.