Sr. Data Engineer ( DBT, Snowflake) - Onshore

Job Description We are seeking a Data Engineer to join our growing team focused on Customer Information Management (KIM). Technology Stack • Snowflake (all data infrastructure) • dbt (core transformation framework) • Python (select data workflows) • GitHub & GitHub Actions (CI/CD pipelines) • AWS (Kubernetes environment) – Infrastructure already established (AWS expertise not required) Key Responsibilities • Design, build, and maintain scalable data models in Snowflake • Develop and optimize transformation workflows using dbt • Collaborate through pair programming (up to 6 hours daily) as a core working practice • Integrate and manage data from multiple internal and external customer-related sources • Contribute to CI/CD pipelines using GitHub and GitHub Actions • Ensure data quality, reliability, and performance across the analytics platform • Support the ongoing evolution of the Customer Information Management ecosystem Required Qualifications • Strong hands-on experience with Snowflake • Solid experience building transformations with dbt • Experience writing data workflows in Python • Deep understanding of data modeling, ELT/ETL patterns, and analytics engineering best practices • Comfortable with Git-based workflows and CI/CD practices • Experience working with multiple data sources and complex data ecosystems • Strong communication skills and ability to work in a highly collaborative, pair-programming environment Rate: $65-75/hour ( depends on experience level). This is a contract position with contractors expected to work 40 hours per week. About the Company Peterson Technology Partners (PTP) is an Equal Opportunity Employer committed to creating a transparent, inclusive, and human-centered hiring experience. For more than 28 years, PTP has operated as one of the top IT staffing and recruiting firms in the USA—built on trust, long-term partnerships, and technical excellence. Based in the Chicago suburb of Park Ridge, IL, our team of more than 500 employees and consultants is dedicated to: Helping every client make the best hiring decisions possible Matching professionals with the right IT jobs and career opportunities As part of that commitment, we believe in providing clear information about how our hiring technologies work and how your data is used. The following section outlines our AI-assisted interview process and your rights as a candidate. AI-Assisted Interview Experience (Pete & Gabi – Rebecca) To provide a consistent, fair, and flexible experience for all candidates, we use AI-assisted tools to support parts of the interview process. This includes our proprietary AI platform Pete & Gabi, which includes AI recruiter Rebecca. These AI hiring tools help us: • Transcribe interviews • Summarize candidate responses • Generate job-related insights • Streamline communication and scheduling Please note that: The AI does NOT make hiring decisions; all decisions are made by our human recruiters, hiring managers, or client partners. The AI does not evaluate facial expressions, emotions, or physical traits; it is used only to support fairness, consistency, and efficiency. If you prefer a non-AI interview format, we will gladly provide an alternative. Technical or Case Interviews (Role-Dependent): + When applying for certain tech jobs, you may participate in: • A technical interview • A coding challenge • A case study • A client-specific assessment We will always explain what to expect in advance so you can prepare with confidence. Human Review & Selection: + Every candidate's profile—including interviews, conversations, and assessments—is reviewed by experienced recruiters and hiring leaders. AI insights may assist with organization and evaluation, but final decisions are always human-driven. Your Rights as a Candidate: + At PTP, every candidate has the right to: Request a non-AI interview path Ask how your data is being used Request access to transcripts or interview recordings Request deletion of your AI-recorded interview Receive clear, timely communication Our goal is to ensure you feel respected, informed, and supported throughout your experience. Our Commitment: + For more than 28 years, PTP has focused on putting people first—candidates, consultants, employees, and clients. We're committed to a hiring process that is: • Transparent • Compliant • Equitable • Powered by innovative technology that enhances—not replaces—human judgment Welcome to the future of hiring at Peterson Technology Partners. We're excited to learn more about you. Equal Employment Opportunity: + Peterson Technology Partners is an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, national origin, gender identity, sexual orientation, disability, veteran status, or any other protected characteristic.