At a Glance
- Tasks: Design and maintain data systems, transforming raw data into actionable insights.
- Company: Leading financial services company focused on customer-centric solutions.
- Benefits: Competitive salary, extensive benefits, and flexible working arrangements.
- Why this job: Join an innovative team and work on exciting data projects that make a real difference.
- Qualifications: Experience in data warehousing, ETL processes, and delivering BI solutions.
- Other info: Collaborative environment with opportunities for professional growth and development.
The predicted salary is between 60000 - 84000 £ per year.
12 month FTC
£70,000 - £75,000 + extensive benefits
Edinburgh – 3 days pw onsite
We are currently partnering with a leading and customer centric financial services company in their search for a Data Engineer. You will be 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.
Responsibilities
- 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.
What you'll bring
- 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.
- Excellent communication skills with the ability to build relationships at all levels, 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 Remain.
Please apply now for more information.
InterQuest Group is acting as an employment agency for this vacancy. InterQuest Group is an equal opportunities employer and we welcome applications from all suitably qualified persons regardless of age, disability, gender, religion/belief, race, marriage, civil partnership, pregnancy, maternity, sex or sexual orientation. Please make us aware if you require any reasonable adjustments throughout the recruitment process.
Data Engineer in Edinburgh employer: Morson Edge
Contact Detail:
Morson Edge Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer in Edinburgh
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even just grab a coffee with someone who’s already in the data engineering field. Building relationships can lead to job opportunities that aren’t even advertised.
✨Show Off Your Skills
Don’t just tell them what you can do; show them! Create a portfolio of your projects, especially those involving data warehousing or BI solutions. Share it on platforms like GitHub or your personal website to give potential employers a taste of your work.
✨Ace the Interview
Prepare for technical interviews by brushing up on your SQL and data modelling skills. Practice common interview questions and be ready to discuss your past projects in detail. Remember, they want to see how you think and solve problems!
✨Apply Through Us!
We’ve got your back! Make sure to apply through our website for the best chance at landing that Data Engineer role. We’re here to help you every step of the way, so don’t hesitate to reach out if you need any tips or support.
We think you need these skills to ace Data Engineer in Edinburgh
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Engineer role. Highlight your experience with data warehouses, ETL processes, and any relevant technologies like Oracle or AWS. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how your background makes you a great fit for our team. Keep it concise but engaging – we love a good story!
Showcase Your Projects: If you've worked on any relevant projects, make sure to mention them! Whether it's building BI solutions or automating data systems, we want to know what you've done and how it relates to the role. Real-world examples can really make your application stand out.
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you'll be able to keep track of your application status. Plus, we love seeing applications come directly from our site!
How to prepare for a job interview at Morson Edge
✨Know Your Tech Stack
Familiarise yourself with the specific technologies mentioned in the job description, like Oracle tools, Snowflake, and AWS services. Be ready to discuss your experience with these tools and how you've used them in past projects.
✨Showcase Your BI Solutions
Prepare examples of business intelligence solutions you've delivered. Highlight how you transformed raw data into meaningful insights and how those insights impacted decision-making for stakeholders.
✨Emphasise Agile Experience
Since the role involves Agile practices, be prepared to discuss your experience working in Agile environments. Share specific examples of how you've contributed to sprints or collaborated with cross-functional teams.
✨Communicate Effectively
Strong communication skills are key for this role. Practice explaining complex technical concepts in simple terms, as you'll need to build relationships with various stakeholders. Think about how you can demonstrate your customer-focused approach during the interview.