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.
Job Requirements
Data Modeling, Data Warehouse, PowerBI, SSRS, SSIS, Data Vault, Medallion, SQL Server, ETL
Unlock exciting career opportunities in the vibrant area surrounding Overland Park, Kansas! This thriving region, part of the greater Kansas City metropolitan area, offers a delightful blend of urban amenities and natural beauty. From the renowned Nelson-Atkins Museum of Art to the lively Power & Light District, and the iconic Kauffman Stadium where the Kansas City Royals play, there is no shortage of enriching experiences to enjoy. With its famous barbecue cuisine and welcoming community spirit, Overland Park is a place where both your career and quality of life can flourish. Explore our job listings today and set your sights on a fulfilling career in this charming and dynamic location!
Are you sure you want to apply for this job?
Please take a moment to verify your personal information and resume are up-to-date before you apply.