Senior Data Engineer

Note: Open to candidates requiring sponsorship and relocation; however, must have extensive hands-on experience with Fivetran. Onsite requirement remains 5 days/week.

The Senior Data Engineer will be part of a team designing and implementing our modern data platform to support enterprise-wide analytics, integration, and AI/ML initiatives. Together, the team will build a scalable enterprise data warehouse, enable modern visualization tools, and advance self-service analytics capabilities for business users.

Major Duties and Responsibilities:

• Data Engineering & Pipeline Development Design, build, and maintain scalable data pipelines and workflows in Snowflake, leveraging dbt for modular transformations and Fivetran for automated ingestion.
• Enterprise Data Warehouse & Modeling Architect and optimize the enterprise data warehouse, applying best practices in data modeling, performance tuning, and scalability to support enterprise-wide analytics.
• Data Governance & Quality Partner with governance teams to document cataloging, lineage, and stewardship, while ensuring data quality, security, and compliance.
• Collaboration & Business Enablement Work closely with business and analytics teams to translate requirements into scalable data solutions.
• Cloud Integration & Infrastructure Utilize AWS services (primarily S3) for data storage and integration, ensuring reliability, performance, and cost-effectiveness.
• Additional responsibilities as assigned.
  
  

Education and Experience:

Required:

• Bachelor s degree in Computer Science, Data Engineering, Information Systems, or a related technical field.
• 5+ years of professional experience in data engineering or related roles.
• Proven expertise with Snowflake for data pipelines, development, and optimization.
• Strong experience with dbt for modular transformations and Fivetran for automated ingestion.
• Solid background in data warehousing, dimensional modeling, and performance tuning.
• Hands-on experience with AWS cloud services (especially S3) for data integration and storage.
• Familiarity with data governance tools (Alation or Atlan) for cataloging, lineage, and stewardship.
• Proficiency in SQL and comfort with scripting languages such as Python.
  
  

Preferred:

• Master s degree in a related field.

Looking to advance your Data Science career with relocation support? Explore Data Science Jobs with Relocation Packages that include comprehensive packages to help you move and settle in your new role.

• Experience with real-time/streaming technologies (e.g., Kafka, Kinesis, Flink).
• Knowledge of data security, compliance, and access control best practices.
• Exposure to AI/ML workflows and integrating data engineering solutions with ML pipelines.
• Background in modern visualization platforms (Power BI, Tableau, Looker) to support self-service analytics.
• Demonstrated ability to A39mentor junior engineers and contribute to engineering best practices.
  
  

Knowledge and Skills:

• Snowflake (Expert) deep expertise in data pipelines, query optimization, and enterprise-scale implementation.
• dbt (Advanced) strong ability to design modular, reusable transformations and maintain version-controlled models.
• Fivetran (Advanced) hands-on skill in managing ingestion pipelines and troubleshooting data connectors.
• Data Warehousing & Data Modeling (Advanced) proficiency in dimensional modeling, star/snowflake schemas, and performance tuning.
• AWS Cloud (Intermediate) working knowledge of S3 for storage and integration; familiarity with broader AWS data services a plus.
• Data Governance (Intermediate) understanding of metadata management, lineage, and cataloging.
• SQL (Expert) strong command of writing complex queries and optimizing performance.
• Python (Intermediate) ability to script automation, testing, and lightweight data transformations.
• Collaboration & Communication skilled in working with cross-functional teams and translating technical concepts to business stakeholders.
• Emerging Tech & AI awareness of how AI/ML can accelerate data engineering practices; willingness to experiment and learn.
  
  

Salary: $150,000- $165,000 per year (depends on experience level).

Benefits: Medical Insurance, PTO, 401 (k) and more

About Us

Peterson Technology Partners (PTP) is an Equal Opportunity Employer committed to creating a transparent, inclusive, and human-centered hiring experience. For more than 27 years, PTP has operated as a premier Information Technology (IT) staffing, consulting, and recruiting firm—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. 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):

Discover our full range of relocation jobs with comprehensive support packages to help you relocate and settle in your new location.

To provide a consistent, fair, and flexible experience for all candidates, we use AI-assisted tools—including our proprietary platform Pete & Gabi – Rebecca—to support parts of the interview process. These tools help us:

• transcribe interviews,
• summarize candidate responses,
• generate job-related insights
• streamline communication and scheduling.
  
  

Please note that

• 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):

For certain positions, 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 27 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

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.