Data Engineer
Location: London
About L.E.K.
L.E.K. Consulting is a global strategy consulting firm with offices across Europe, the Americas and Asia-Pacific. We advise clients on their key strategic issues, leveraging our deep industry expertise and analytical rigor to help them make informed decisions and solve their toughest and most critical business problems. L.E.K. provides a comprehensive range of capabilities around the globe, including Strategy, Mergers & Acquisitions, and Performance Improvement. We have deep expertise and a proven track record in a broad range of industries.
Founded in London in 1983, we now employ more than 1,600 professionals worldwide across 23 offices.
Position summary
The Data Engineer will collaborate with and support the FinanceBI and global finance team in building our Data Warehouse. They will be required to develop scalable data pipelines, extracting data from core systems, transforming it and loading into database/warehouse tables while also ensuring these are optimised for maximum performance within the tools available. They are expected to have strong collaboration skills and be a high performer within the FinanceBI team.
Responsibilities
- Design and develop data transfer engines and pipelines: highly scalable, end-to-end processes to consume, integrate, and analyse data from different data sources.
- Perform data collection, cleansing, and integration for analytical needs.
- Optimize storage and retrieval processes for maximum performance and efficiency.
- Optimize data transfer engines and pipelines by monitoring, evaluating performance, and applying enhancement.
- Design and develop data marts and define data models.
- Participate in System Data Architecture and Data Governance activities
- Adhere to and take part in enhancement of data management standards, coding standards, guidelines, and policies.
- Employ strong engineering mind-set in design and development of automated monitoring, alerting, and recovery processes.
- Collaborate with Source System analysts, Business Intelligence developers, Architects and Stake holders to ensure that requirements for integration, security, quality, and cross functional usage are addressed.
- Help resolve data issues, troubleshoot system problems, and as needed, assist with reporting, debugging data accuracy issues, and other related functions.
- Work in a collaborative environment—meetings, iterative development, and design and code review sessions.
- Collaborate with all technology and business functions to understand requirements
and produce clear specification and documentation - Implement quality checks and troubleshoot issues to ensure data accuracy and reliability.
- Monitor and manage the performance of data systems.
- Stay updated on emerging technologies and trends in data engineering.
Key Skills:
- Strong analytical and problem-solving skills
- Process and Solution oriented with great documentation skills
- Attention to detail
- Teamwork skills
- Written and verbal communication skills
- Interpersonal skills
- Flexibility
- Adaptability
- Initiative – self-starter, driven, owns tasks with minimal supervision
- Delivery-driven – can work to defined timelines
Qualifications / Experience:
- Minimum bachelor’s degree in Computer Science, Data Engineering, Information Technology, or a related field.
- 3-5 years of experience as a Data Engineer or a similar role.
- Expert knowledge of data engineering tools and technologies (e.g. SQL, ETL, data warehousing).
- Proficiency in T-SQL (4+ years of SQL experience)
- 4+ years of experience with schema design and dimensional data modelling
- Proficiency in the Microsoft BI Tool Stack; Database, SSIS, SSAS, PowerBI (Nice to Have)
- Experience with Azure cloud platform and Azure Data Factory
- Knowledge of data modeling, database design, and data governance.
- Experience with Continuous Integration Processes and Tools (AzureDevOps)
- Experience with Change Management Processes and Cycles (Release and Deployment)
- Experience with Microsoft SQL Data Tools (2019+)
- Experience in working in Development Teams and Team Collaborative tools (Jira or similar)
Other Jobs from LEK Consulting
Similar Jobs
Data Analytics Engineer
Data Scientist
DATA SCIENTIST, SMAI OI
Data Engineer Intern
Senior Data Analyst
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 401 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got about 70,000 jobs from 5,000 vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 5,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say