Data Engineer
Role details
Job location
Tech stack
Job description
You will joining an experienced and innovative data and analytics function who are currently engaged on multiple data focused projects which are in various stages of development following Agile practices. You'll be automating and integrating multiple data systems, and developing business intelligence solutions for reliable, seamless reporting to serve multiple stakeholders. The technology stack consists of: Oracle tools, Snowflake, Postgres, various AWS Services (SageMaker, Lambda, Step Functions, DMS, S3 etc.) in the AWS Cloud., * Designing, building, and maintaining a Data Warehouse and related applications.
- Analysing, developing, delivering, and managing business intelligence reports in OAS and other tools
- Assisting in the design of the ETL process, including data quality, reconciliation, and testing
- Contributing to technical process improvement initiatives
- Supporting UAT processes by working with stakeholders to successfully sign-off business requirements
- Assisting in prioritisation and estimation of project work
- Transform data into meaningful insights and recommendations
Requirements
- Experience of building a data warehouse using an ETL/ELT tool
- Star schema/dimensional modelling.
- Good knowledge of standard data formats (XML, JSON, csv, etc)
- Proven experience of delivering BI solutions for business requirements
- Experience of developing using an Agile development approach
- Proficient in turning raw, structured and unstructured data into meaningful insights and recommendations
- Efficient at handling large data sets in data platforms (such as Oracle, Snowflake), with mastery of SQL and Power BI. Additional Proficiency in Python or R is an asset.
- Experienced in delivering difficult and complex projects involving multiple teams/stakeholders
- You'll have excellent communication skills with the ability to build relationships at all levels, you are highly customer focused with the ability to work collaboratively.
- Able to perform and work effectively as a sole developer on a project and work collaboratively with the wider BI Team.
Desirable
- Proven Experience of Oracle ODI
- Experience in Oracle
- Familiarity with Snowflake
- Experience of building Oracle OBIEE/OAS reports & dashboards
- Experience with working on the cloud, preferably with AWS, including certifications
- Familiarity with Apex
- Data migration
- Understanding of machine learning or data science, including Python.
Candidates must be based in the UK and hold a British/EU Passport or Indefinite Leave to Reamin