Senior Data & Analytics Engineer
Skills
Agile MethodologiesMicrosoft AzureData Warehousing
What the job involves
The main requirements, responsibilities and hiring steps.
Requirements
- Experience building complex data transformations ideally using dbt
- Experience working on the design and data modelling stages of data warehouse projects and be comfortable with conceptual, logical and physical data modelling techniques as well as dimensional modelling techniques
- Experience using cloud data warehouse technology- Snowflake (preferred), Google BigQuery, AWS Redshift or Azure Synapse and experience working with key services on either GCP, AWS or Azure
- Experience working in an Agile delivery environment, ideally using Scrum and\or Kanban
- Strong written and verbal communication skills and be comfortable communicating and building relationships with stakeholders at all levels
- Experience developing or supporting data CI\CD pipelines regardless of tooling would be beneficial
- Strong understanding of SQL and be comfortable reading and writing complex SQL queries ideally across multiple platforms
- Knowledge of programming languages such as Python would be beneficial
- Experience working with data from a wide variety of data sources including different database platforms, flat files, API’s and event-driven data feeds
Nice to have
- Passionate
- Communicative strength
- Supportive
- Innovative mindset
- Team player
Day to day
- Responsible for delivering complex data and analytics solutions including data ingestion from various sources to analytics platforms, production of data analytics products like data warehouses, analytical data sets, and visualizations
- Transform, cleanse, and model data into enterprise data warehouse for both technical and non-technical users
- Drive a data-first culture within the data team and across the business, supporting continual learning and data enablement activities
- Support production data assets as part of the data-first culture