Data Engineer

Lockton Affinity, located in Overland Park, KS is searching for a Data Engingeer.  At Lockton Affinity, information technology plays a vital role in delivering exceptional business results. The Data Engineer is a key contributor in advancing the firm’s data strategy and analytics ecosystem, transforming raw data into actionable insights that drive business decisions. This role requires a technically strong, curious professional committed to continuous learning and innovation. The ideal candidate combines analytical acumen with data engineering skills to ensure reliable, efficient, and scalable data pipelines and reporting solutions. Lockton values Associates who are proactive, collaborative, and motivated to make a measurable impact.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Data Engineering & Integration

• Design, build, and maintain data pipelines and integrations using Azure Data Factory, SSIS, or equivalent ETL / ELT tools.
• Automate data imports, transformations, and loads from multiple sources (on-premise, SaaS, APIs, and cloud).
• Optimize and monitor data workflows for reliability, performance, and cost efficiency.
• Implement and maintain data quality, validation, and error-handling frameworks.

Data Analysis & Reporting

Collaboration & Governance

Continuous Improvement

Required

Preferred :

Exposure to Python or PowerShell for data transformation or automation.

ABOUT THE ROLE

This position bridges business analytics and data engineering—ideal for someone who enjoys both designing elegant data solutions and delivering meaningful insights. You’ll help shape Lockton Affinity’s evolving data architecture and enable smarter, faster business decisions across the enterprise.