Senior Data Engineer

Our client is seeking a Senior Data Engineer to join their team. The Senior Data Engineer will design, code, test, and analyze software programs and applications. This includes researching, designing, documenting, and modifying software specifications throughout the production lifecycle. This role will also analyze and amend software errors in a timely and accurate fashion and provide status reports where required. The position responsibilities outlined below are not all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary.

Position Responsibilities:

• Strong experience with Snowflake for cloud data warehousing, data modeling, performance optimization, and SQL development.
• Hands-on experience with Airflow for workflow orchestration, scheduling, monitoring, and management of data pipelines.
• Experience with ThoughtSpot for self-service analytics, reporting, dashboard development, and business intelligence solutions.
• Proficiency in SQL and data integration technologies.
• Experience designing and implementing scalable ETL/ELT pipelines in cloud environments.
• Strong understanding of data warehousing concepts, dimensional modeling, and data governance best practices.
• Experience working with large-scale datasets and supporting analytical reporting requirements.
• Ability to collaborate with business stakeholders, data analysts, and engineering teams to deliver data-driven solutions.

Experience And Qualifications:

• Required Skills - Experience and comfort solving problems in an ambiguous environment where there is constant change. Have the tenacity to thrive in a dynamic and fast-paced environment, inspire change, and collaborate with a variety of individuals and organizational partners
• Experience designing and building scalable and robust data pipelines to enable data-driven decisions for the business
• Very good understanding of the full software development life cycle
• Very good understanding of Data warehousing concepts and approaches
• Experience in building Data pipelines and ETL approaches using Informatica IICS, Alteryx or any leading pipeline tool.
• Experience in building high-volume data workflows in a cloud environment
• Experience in building Data warehouse and Business intelligence projects
• Good Experience using Snowflake environment.
• Good Experience using streaming data using Kafka.
• Experience in data cleansing, data validation and data wrangling.
• Hands-on experience in AWS cloud and AWS native technologies such as Glue, Lambda, Kinesis, Lake Formation, S3, Redshift
• Experience using Spark EMR, RDS, EC2, Athena, API capabilities, CloudWatch, CloudTrail is a plus
• Experience with Business Intelligence tools like Tableau, Cognos, ThoughtSpot, etc is a plus.
• Experience in one of the scripting languages: Python or Unix Scripting
• Proficient in SQL, PL/SQL, relational databases (RDBMS), database concepts and dimensional modeling
• Strong verbal and written communication skills
• Demonstrate analytical and problem-solving skills, particularly those that apply to Data Warehouse and Big Data environments.
• Resources should be able work along with On-site hours to participate in Req/Design discussions.

Education:

• Bachelor s degree in Engineering, Computer Science, Statistics, Economics, Mathematics, Finance, or a related quantitative field.
• 5 to 8+ years of experience within the field of data engineering or related technical work including business intelligence, analytics.

Salary/Rate: $65-$80/HR (depends on experience level). This is a contract position with candidates expected to work 40 hours/ 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:

• Conduct recorded video interviews
• 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.