Senior Data Engineer

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

Senior Data Engineer Adaptive Solutions Group is partnering with a growing organization seeking an experienced Senior Data Engineer to join its data and technology team. This role will play a key part in designing, building, and optimizing the organization's data infrastructure while ensuring high-quality, reliable data is available to support business operations and strategic decision-making. The ideal candidate is passionate about data engineering, enjoys solving complex technical challenges, and thrives in a collaborative, fast-paced environment. This position offers the opportunity to influence modern data architecture, mentor team members, and contribute to the continued evolution of the company's data platform.

Key Responsibilities

• Support the long-term strategy and architecture for the organization's data warehouse and analytics environment.
• Design, develop, and maintain scalable data pipelines that ingest data from a variety of internal and external sources.
• Build, enhance, and optimize ETL processes to improve data quality, accessibility, and performance.
• Contribute to data modeling initiatives and data warehouse development.
• Monitor and troubleshoot existing data pipelines, identifying opportunities for process improvements and automation.
• Automate manual data processes to improve operational efficiency.
• Ensure the accuracy, integrity, and availability of enterprise data.
• Partner with cross-functional teams to deliver data-driven solutions that support business objectives.
• Develop and maintain reports and data extracts as needed.
• Assist with data governance initiatives, including cataloging and classifying data assets.
• Participate in code reviews and continuous improvement initiatives.
• Support data requests related to audits, compliance, or regulatory requirements.
• Mentor junior team members and promote data engineering best practices.
• Perform additional duties as assigned.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Mathematics, Statistics, or a related field, or equivalent professional experience.
• 6+ years of experience in data engineering, data warehousing, or a related technical discipline.
• 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.
• Experience with Data Vault is a plus.
• Experience supporting and troubleshooting SSIS packages.
• Experience integrating data through APIs, event-driven architecture, or messaging platforms.
• Familiarity with Agile software development methodologies.
• Experience with Power BI or other business intelligence tools is preferred.
• Industry experience within insurance or financial services is a plus.
• Strong analytical, organizational, and problem-solving skills.
• Excellent written and verbal communication skills.
• Collaborative mindset with the ability to work effectively across technical and business teams.
• Self-motivated and adaptable in a fast-paced environment.

Additional Information

• Full-time, onsite position based in Overland Park, KS.
• Competitive compensation package based on experience, skills, and qualifications.
• Visa sponsorship is not available for this position.