Senior Data Engineer — Data Platform & ETL Architect

Adaptive Solutions Group; Overland Park (KS); On-site; USD 120,000 - 150,000; Full time

Job summary

Adaptive Solutions Group in Overland Park, KS is seeking a Senior Data Engineer to design, build, and optimize our data infrastructure. You will ensure high-quality, reliable data to support operations and strategy, mentor teammates, and influence modern data architecture.

Join a collaborative, fast-paced environment where you'll design data pipelines, implement ETL processes, and partner with cross-functional teams to deliver data-driven solutions.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Mathematics, Statistics, or related field or equivalent experience.
• 6+ years of data engineering or data warehousing experience.
• Strong experience with Microsoft SQL Server and SQL development.
• Experience designing and maintaining ETL processes and data integration solutions.
• Knowledge of database design principles and data modeling methodologies.
• Data Vault experience is a plus.
• Experience with SSIS packages.
• Experience integrating data via APIs, event-driven architectures, or messaging platforms.
• Familiarity with Agile software development methodologies.
• Experience with Power BI or other BI tools preferred.
• Insurance or financial services industry experience is a plus.
• Strong analytical, organizational, and problem-solving skills.
• Excellent written and verbal communication; collaborative across teams.

Responsibilities

• Support long-term data warehouse strategy and architecture.
• Design, develop, and maintain scalable data pipelines ingesting data from diverse sources.
• Build and optimize ETL processes to improve data quality and performance.
• Contribute to data modeling and data warehouse development.
• Monitor and troubleshoot data pipelines; identify automation opportunities.
• Automate manual data processes to boost operational efficiency.
• Ensure data accuracy, integrity, and availability for business use.
• Partner with cross-functional teams to deliver data-driven solutions.
• Develop and maintain reports and data extracts as needed.
• Assist with data governance, including cataloging/classifying assets.
• Participate in code reviews and continuous improvement initiatives.
• Support data requests for audits, compliance, or regulatory needs.
• Mentor junior engineers and promote best practices.

Skills

Analytical thinking

Collaboration

Problem solving

Self-motivated

Adaptability

Education

Bachelor's degree in Computer Science / related field

Tools

Microsoft SQL Server

SSIS

ETL design

Power BI

APIs & messaging

Data Vault

Job description

Adaptive Solutions Group in Overland Park, KS is seeking a Senior Data Engineer to design, build, and optimize our data infrastructure. You will ensure high-quality, reliable data to support operations and strategy, mentor teammates, and influence modern data architecture.

Join a collaborative, fast-paced environment where you'll design data pipelines, implement ETL processes, and partner with cross-functional teams to deliver data-driven solutions.