Apply on Employer Site

Lockton · 6 hours ago

Data Engineer

Overland Park, KS

Full-time

Onsite

Mid Level

Lockton Affinity is seeking a Data Engineer to contribute to their data strategy and analytics ecosystem. The role involves designing and maintaining data pipelines, developing reporting solutions, and collaborating with various stakeholders to ensure data integrity and governance.

Auto InsuranceInsuranceRisk Management

H1B Sponsor Likely

Responsibilities

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

Develop and maintain reporting databases, views, and semantic models for business intelligence solutions

Design and publish dashboards and visualizations in Power BI and SSRS, ensuring alignment with business KPIs

Perform ad-hoc data exploration and statistical analysis to support business initiatives

Partner with stakeholders across marketing, underwriting, operations, and IT to define analytical and data integration requirements

Maintain data integrity, enforce governance standards, and promote best practices in data stewardship

Support data security and compliance initiatives in coordination with IT and business teams

Stay current with emerging data technologies and analytics practices

Recommend tools, processes, or automation improvements to enhance data accessibility and insight delivery

Qualification

SQL developmentAzure Data FactoryPower BIData modelingMicrosoft ExcelData integrationPythonPowerShellGitAgile practicesCommunication skillsCollaboration skills

Required

Strong SQL development skills and experience with Microsoft SQL Server and Azure SQL Database

Hands-on experience with data import, transformation, and integration using Azure Data Factory, SSIS, or similar tools

Proficiency in building BI solutions using Power BI and/or SSRS

Strong data modeling and relational database design skills

Proficiency in Microsoft Excel (advanced formulas, pivot tables, external data connections)

Ability to translate business goals into data requirements and technical solutions

Excellent communication and collaboration skills

Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience)

Preferred

Experience with cloud-based data platforms (Azure Data Lake, Synapse Analytics, Databricks)

Familiarity with version control tools (Git, Azure DevOps) and Agile development practices

Exposure to Python or PowerShell for data transformation or automation

Experience integrating data from insurance or financial systems

Company

Lockton

Glassdoor4.0

Lockton provides risk management and insurance services.

Founded in 1966

Kansas City, Missouri, USA

10001+ employees

https://www.lockton.com/offices/uk

H1B Sponsorship

Lockton has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (1)