Associate Data & Automation Analyst

re-zoo-me; Boston (MA); Hybrid; USD 65,000 - 72,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

L.E.K. Consulting, based in Boston, seeks an Associate Data & Automation to help build and support automation, data pipelines, and internal web services across Azure.

This early-career role focuses on practical problem solving with code and collaboration with senior colleagues across data, cloud, automation, and platform technologies. Ideal candidates have 1–3 years in automation or data engineering, experience with PowerShell/Python, SQL, and Azure services, and strong English communication.

Qualifications

• 1-3 years of automation, data engineering, DevOps, cloud operations, or related field.

Responsibilities

• Build and maintain PowerShell 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 Fabric lakehouses, 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 escalations more complex problems when appropriate.
• Maintain clear technical documentation, runbooks, source control, and infrastructure-as-code practices so 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.

Skills

PowerShell

Python

SQL

Git

REST APIs

Problem solving

English communication

Bachelor's degree in CS or related

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field

Tools

Azure Data Factory

Azure Functions

Logic Apps

Microsoft Fabric

Azure Blob Storage

OneLake

Power BI

Docker

Job description

About L.E.K. Consulting

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 industry expertise and rigorous, evidence-based insight to global corporations, growth companies and private equity investors, helping them turn strategy into action.

How do we deliver impact? It's the people. We hire exceptional individuals and invest in their growth through hands-on client work, close collaboration and a culture of ownership, inclusion and continuous learning. Across every level, curiosity unites us and challenge excites us.

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 and maintain PowerShell 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 Fabric lakehouses, 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 escalations more complex problems when appropriate.
• Maintain clear technical documentation, runbooks, source control, and infrastructure-as-code practices so 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, or related technical field. Strong internship, 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, and validating datasets.
• Exposure to Microsoft Azure services such as Azure Blob Storage, Azure Data Factory, and Azure Functions.
• Familiarity with Microsoft Fabric, including pipelines, notebooks, lakehouses, or OneLake.
• 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.
• Basic familiarity with HTML, CSS, JavaScript, or a modern front-end framework.

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 range is $65,000 - $72,000 annually. Actual compensation will be determined based on experience, qualifications, skills, and location. This position may also be eligible for discretionary bonus and a comprehensive benefits package.
• L.E.K. Consulting offers a competitive total rewards package including medical, dental, vision, life and disability insurance, 401(k) with employer contribution, HSA contributions (where applicable), paid time off, and other firm-sponsored benefits.
• This role is based in our Boston office and follows 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 candidates requiring visa 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 with applicable state and local laws, we will provide reasonable accommodations for qualified individuals with disabilities and for sincerely held religious beliefs, practices, or observances.