Senior Data Engineer

Data & Analytics is a Core Services function that helps case teams succeed with their analytics work, contributes to training Associates and Consultants, and supports Managing Directors with IP, developing commercial proposals, and ensuring timely data capture at the launch of casework. Data & Analytics is an important strategic capability for LEK in our quest to support our clients with actionable findings from data. LEK works in verticals like Consumer/Retail, Industrial, and Life Science/Healthcare practices. LEK has been a highly successful international management consulting firm, with a history of rapid yet controlled revenue growth. To further fuel this expansion we are seeking to grow a thriving analytics practice.

The Sr. Data Engineer plays a pivotal role in determining viable paths to sound and actionable results from analysis. Across the value chain from inception of client proposals, to capturing and cleaning of data sources, assessing data quality and completeness, running analyses and presenting findings in a compelling and actionable format, you hold your own. Versatility and flexibility of methods and tools is important, because no two cases will be alike. Our clients’ data assets never cease to amaze us. We blend data sources across proprietary data, client data, subscription data, and public sources to enrich our analyses. You play a key role in building frameworks and reproducible methods to make data engineering predictable, reliable, and scalable.

As part of a dynamic and growing team, there is every opportunity to carve out value added work, and to grow your skills and experience. You receive state-of-art training in a variety of domains, and lead the organization to adopting new and innovative methods to solve our clients’ hardest questions. You aren’t just a technical expert: you intersect between data science, statistics and computer science, with business expertise in a variety of domains, financial modeling to determine suitability of recommendations, and managerial and influencing skills to “sell” your recommendations to our clients.

Responsibilities:

• Identifying and flagging potential data sources in support of client needs
• Sourcing, restructuring and cleaning of data to make them amenable to analysis
• Supporting case teams with their analytics work in either a “consultancy/expert” mode, or as part of active case work
• Guide the firm along a multi-year roadmap that you design to profitable and sustainable data monetization
• Build out our proprietary data sources by matching and merging of procured, proprietary, as well as public data sources in support of business development, client proposals, and generating IP that helps further establish our thought leadership
• Determine data needs for case team projects. Specify what data our clients are expected to deliver, and securely manage file exchanges with our clients’ IT departments
• Train and coach LEK staff on the use of our software and proposed data management methods
• Contribute to commercial proposals, as required by Managing Directors
• Develop templates and training materials to build out LEK’s analytical capabilities

Qualifications and Experience:

• Expert level knowledge of the MS SQL Server stack, including PowerPivot and PowerBI
• Hands-on experience with all major cloud providers: Azure, AWS, GCP, Snowflake
• Familiar with selecting, recommending, and tuning optimal cloud solutions
• 5+ years’ experience loading and updating temporal data solutions
• A minimum of 10 years of experience in data engineering
• Experience with Alteryx and Tableau, as well as Python/Pandas is preferable, but not required
• Experience doing hands-on, practical casework and data migrations. This might have been at a consultancy, or on the corporate side.
• Ideally, you have gained experience managing small teams.

Candidates responding to this posting must currently possess eligibility to work in the United States

L.E.K. Consulting offers a competitive compensation and benefits package 

L.E.K Consulting is an Equal Opportunity Employer