Associate Data & Automation Analyst

LEK; Boston; Hybrid; PHP 4,073,000 - 4,511,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) with employer contribution

Paid time off

Job summary

L.E.K. Consulting in Boston is seeking an Associate Data & Automation to join the Data & AI Enablement team. The role focuses on automating business and IT processes, building data pipelines, and deploying internal web apps and APIs on Azure.

You will work with senior engineers across Azure services, PowerShell, Python, SQL, and Git, contributing to repeatable solutions, dashboards, and AI/ML data preparation. This is an early-career position offering hands-on learning and growth.

Qualifications

• Bachelor's degree in CS, IS, engineering, or related field, or equivalent.
• Strong PowerShell and Python scripting for automation.
• Proficient SQL querying, transforming and validating datasets.

Responsibilities

• Build and maintain PowerShell and Python scripts to automate IT and business processes.
• Develop, schedule, monitor, and troubleshoot workflows with Azure Data Factory, Functions, and Logic Apps.
• Operate data pipelines that ingest, cleanse, refine, and enrich data for Power BI and AI/ML datasets.
• Support data storage across Azure Blob Storage, OneLake, and Microsoft Fabric lakehouses.
• Deploy and support internal web apps and REST APIs on Azure.
• Monitor jobs and pipelines; investigate issues and escalate complex problems.
• Maintain documentation, runbooks, and infrastructure-as-code for repeatable work.
• Collaborate with Data Platform, AI Enablement, and Analytics teams to translate requirements into solutions.

Skills

Automation

Data engineering

DevOps

Education

Bachelor's degree in CS/IS/Engineering

Tools

PowerShell

Python

SQL

Git

Azure

Azure Data Factory

Azure Functions

Logic Apps

Microsoft Fabric

OneLake

Docker

REST APIs

Kubernetes

Job description

L.E.K. Consulting is a premier global strategy consulting firm that partners with clients to solve their most critical business challenges and deliver high-impact outcomes. We bring deep industryexpertiseand rigorous, evidence-based insighttoglobal corporations, growthcompaniesand private equity investors, helping them turn strategy into action.

How do we deliver impact?It’sthe people. We hire exceptional individuals and invest in their growth through hands-on client work, close collaboration and a culture of ownership,inclusionand continuous learning. Across every level, curiosity unites us andchallenge excitesus.

Founded more than 40 years ago, L.E.K. employs more than 2,200 professionals worldwide and is consistently recognized as one of the industry's best firms to work for. For more information, visit lek.com.

Overview of Role

The Associate Data & Automation Associate is a hands-on member of the Data and AI Enablement team, helping build and support the automation, data, and web services that enable analytics and AI capabilities across the firm.

Working closely with senior technical colleagues, this role focuses on three core areas: automating repeatable business and IT processes; operating data pipelines that prepare information for dashboards and AI/ML use cases; and deploying and supporting internal web applications and APIs in Microsoft Azure. This is an early-career role designed for someone who enjoys solving practical problems with code and is looking to broaden their experience across data, cloud, automation, and platform technologies.

Key Responsibilities

• Build andmaintainPowerShell and Python scripts that automate repeatable IT and business processes.
• Develop, schedule, monitor, and troubleshoot workflows using Microsoft Fabric, Azure Data Factory, Azure Functions, and Logic Apps.
• Operate and extend data pipelines that ingest, cleanse, refine, and enrich data for Power BI reporting and AI/ML datasets.
• Support data storage and curation across Azure Blob Storage,OneLake, and Microsoft Fabriclakehouses, following established quality, lineage, security, and governance standards.
• Deploy and support internal web applications and services on Azure, including containerized applications and REST APIs.
• Monitor jobs, pipelines, and deployed services; investigate issues, resolve common failures, and escalation more complex problems whenappropriate.
• Maintain clear technical documentation, runbooks, source control, and infrastructure-as-codepracticesso work is repeatable and transferable.
• Collaborate with senior Data Platform colleagues, AI Enablement team members, and Data & Analytics stakeholders to translate requirements into working solutions.

Qualifications

• 1-3 years of relevant experience in automation, data engineering, DevOps, cloud operations, orrelatedtechnical field. Stronginternship,apprenticeship, or substantial project experience may also be considered.
• Practical experience with PowerShell and Python for automation and data processing.
• Working knowledge of SQL and experience querying, transforming, andvalidatingdatasets.
• Exposure toMicrosoft Azure services such as Azure Blob Storage, Azure Data Factory, and Azure Functions.
• Familiarity with Microsoft Fabric, including pipelines, notebooks,lakehouses, orOneLake.
• Experience with Git-based version control and collaborative development practices such as branching, pull requests, and code review.
• Exposure to Docker, cloud-hosted application deployment, and REST APIs.
• Strong problem-solving skills, attention to detail, and the initiative to investigate issues before escalating them.
• Strong written and verbal communication skills in English and the ability to document technical work clearly.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience.

Preferred Qualifications

• Exposure to Power BI, including dataset refresh, report publishing, or semantic models.
• Experience preparing, labeling,validating, or curating datasets for AI/ML training or retrieval-augmented generation (RAG).
• Exposure to CI/CD pipelines in Azure DevOps or GitHub Actions.
• Familiarity with Kubernetes concepts and cloud monitoring tools such as Azure Monitor, Log Analytics, or Application Insights.
• Microsoft certification such as AZ-900, DP-900, AZ-104, or DP-700, or progress toward certification.

What You'll Bring

• A practical, hands-on approach to automation and technical problem solving.
• Curiosity and a willingness to learn from more senior colleagues while steadily taking on greater ownership.
• Ability to work effectively with global and remote teams across time zones.
• A disciplined approach to code quality, documentation, reliability, and data governance.

Additional Information

• The expected base salary rangeis $65,000 - $72,000annually. Actual compensation will bedeterminedbased on experience, qualifications, skills, and location. This position may also be eligible for discretionarybonusand a comprehensive benefits package.
• L.E.K. Consulting offers a competitive total rewards package including medical, dental, vision,lifeand disability insurance, 401(k) with employer contribution, HSA contributions (where applicable), paid time off, and other firm-sponsored benefits.
• This role is based in ourBostonofficeandfollows our hybrid work model for U.S. offices. We require employees to be in their assigned home office Tuesday, Wednesday, and Thursday each week, as well as the first Friday of each month.
• Applicants must be legally authorized to work in the United States on a permanent basis without the need for employer sponsorship. Unfortunately, we are unable to consider candidatesrequiringvisa sponsorship, including but not limited to H-1B, TN, F-1 (OPT/CPT/STEM), or other work authorization.
• L.E.K. Consulting is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all qualified individuals regardless of race, color,religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.
• In accordance withapplicable state and local laws, we will provide reasonableaccommodationsfor qualified individuals with disabilities and forsincerely heldreligious beliefs, practices, or observances.