1
Chicago, USA
Work Designation: Home-based (Remote). Schedule: Monday-Friday, 8:00 AM - 5:00 PM (CST or similar US business hours). Equipment: Candidate to use their own or supplier-owned PC/MAC, accessing systems via Virtual Desktop. Rate: $50-58/hr, W2. Engagement Type: Contract.
Project Overview: This role supports a large-scale enterprise initiative to replace 34,000 computers by the end of Q1 2027. The project requires extensive coordination to clean, process, and format user and device data, as well as project coordination work to ensure PC orders are processed accurately, efficiently, and on schedule.
Our client is seeking an experienced Data Analyst / Data Wrangler to support the pre-deployment data preparation phase of this initiative. This individual will be responsible for cleaning and validating large datasets, filling gaps in existing records, and ensuring all user and device data is accurate and complete ahead of the mass PC replacement rollout.
Key Responsibilities:
- Perform advanced Excel-based work ("Excel gymnastics"), including complex formulas, data wrangling, and data transformation
- Identify and remove duplicate records (deduping) across large, multi-source datasets
- Conduct data analysis to surface missing, inconsistent, or inaccurate information
- Fill in missing data within an existing spreadsheet to establish complete, accurate pre-requisite data for all impacted users
- Cross-reference and validate data against Active Directory (AD) structure and attributes
- Ensure data integrity and accuracy to support downstream PC ordering and deployment processes
- Quickly adapt to shifting priorities, new data sources, and evolving project requirements as the initiative progresses
- Collaborate with project coordination and deployment teams to ensure data readiness aligns with rollout timelines
- Flag data anomalies or risks that could impact the success of device deployment for individual users or groups
Required Skills & Experience:
- Proven experience in data analysis, data wrangling, and data cleansing, ideally in a large-scale IT asset or device deployment context
- Advanced Excel proficiency - comfortable with complex formulas, lookups, pivot tables, and large dataset manipulation
- Solid understanding of Active Directory (AD) structure and how user/device data maps within it
- Strong experience deduplicating and reconciling data across multiple, potentially inconsistent sources
- High attention to detail and a strong analytical mindset
- Demonstrated ability to work accurately and efficiently under pressure amid rapidly changing requirements
- Strong organizational skills with the ability to manage large volumes of data without losing accuracy
Preferred Skills:
- Power BI experience, to help build reporting dashboards off the cleaned/processed data
Ideal Candidate Profile: The ideal candidate is a highly analytical, detail-driven professional who thrives in a fast-paced, high-change environment. They should be comfortable working independently with messy, incomplete datasets, applying strong problem-solving skills to fill gaps and resolve inconsistencies, while maintaining accuracy under tight deadlines as project needs evolve.
Salary/Rate: $50-$58/HR (depends on experience level). This is a contract position with candidates expected to work 40 hours/ week
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:
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.
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:
Please note that:
If you prefer a non-AI interview format, we will gladly provide an alternative.
When applying for certain tech jobs, you may participate in:
We will always explain what to expect in advance so you can prepare with confidence.
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.
At PTP, every candidate has the right to:
Our goal is to ensure you feel respected, informed, and supported throughout your experience.
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:
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.
Chicago, USA
Work Designation: Home-based (Remote). Schedule: Monday-Friday, 8:00 AM - 5:00 PM (CST or similar US business hours). Equipment: Candidate to use their own or supplier-owned PC/MAC, accessing systems via Virtual Desktop. Rate: $50-58/hr, W2. Engagement Type: Contract.
Project Overview: This role supports a large-scale enterprise initiative to replace 34,000 computers by the end of Q1 2027. The project requires extensive coordination to clean, process, and format user and device data, as well as project coordination work to ensure PC orders are processed accurately, efficiently, and on schedule.
Our client is seeking an experienced Data Analyst / Data Wrangler to support the pre-deployment data preparation phase of this initiative. This individual will be responsible for cleaning and validating large datasets, filling gaps in existing records, and ensuring all user and device data is accurate and complete ahead of the mass PC replacement rollout.
Key Responsibilities:
- Perform advanced Excel-based work ("Excel gymnastics"), including complex formulas, data wrangling, and data transformation
- Identify and remove duplicate records (deduping) across large, multi-source datasets
- Conduct data analysis to surface missing, inconsistent, or inaccurate information
- Fill in missing data within an existing spreadsheet to establish complete, accurate pre-requisite data for all impacted users
- Cross-reference and validate data against Active Directory (AD) structure and attributes
- Ensure data integrity and accuracy to support downstream PC ordering and deployment processes
- Quickly adapt to shifting priorities, new data sources, and evolving project requirements as the initiative progresses
- Collaborate with project coordination and deployment teams to ensure data readiness aligns with rollout timelines
- Flag data anomalies or risks that could impact the success of device deployment for individual users or groups
Required Skills & Experience:
- Proven experience in data analysis, data wrangling, and data cleansing, ideally in a large-scale IT asset or device deployment context
- Advanced Excel proficiency - comfortable with complex formulas, lookups, pivot tables, and large dataset manipulation
- Solid understanding of Active Directory (AD) structure and how user/device data maps within it
- Strong experience deduplicating and reconciling data across multiple, potentially inconsistent sources
- High attention to detail and a strong analytical mindset
- Demonstrated ability to work accurately and efficiently under pressure amid rapidly changing requirements
- Strong organizational skills with the ability to manage large volumes of data without losing accuracy
Preferred Skills:
- Power BI experience, to help build reporting dashboards off the cleaned/processed data
Ideal Candidate Profile: The ideal candidate is a highly analytical, detail-driven professional who thrives in a fast-paced, high-change environment. They should be comfortable working independently with messy, incomplete datasets, applying strong problem-solving skills to fill gaps and resolve inconsistencies, while maintaining accuracy under tight deadlines as project needs evolve.
Salary/Rate: $50-$58/HR (depends on experience level). This is a contract position with candidates expected to work 40 hours/ week
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:
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.
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:
Please note that:
If you prefer a non-AI interview format, we will gladly provide an alternative.
When applying for certain tech jobs, you may participate in:
We will always explain what to expect in advance so you can prepare with confidence.
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.
At PTP, every candidate has the right to:
Our goal is to ensure you feel respected, informed, and supported throughout your experience.
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:
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.
