Data Engineer Job Description
Job Overview
This on-site Data Engineer in York, PA will play a key role in designing, building, and maintaining scalable data pipelines and infrastructure to support a growing, fast-paced organization. This position is responsible for developing ETL workflows, managing a cloud-based data warehouse, and modeling data to empower analytics and decision-making across the business. This role involves collaboration with internal stakeholders, analysts, and operations teams to streamline how data is used and accessed.
Key Responsibilities of a Data Engineer
- Design, implement, and maintain ETL pipelines to extract, transform, and load data from multiple sources
- Build and manage a cloud-based data warehouse (Amazon Redshift) to support analytics and reporting needs
- Develop and maintain data models that enable scalable reporting, insights, and dashboarding
- Collaborate with analysts, operations, and leadership to identify data needs and deliver efficient solutions
- Ensure data accuracy, consistency, and availability across the organization
- Document data architecture, processes, and data dictionaries to improve visibility and governance
- Participate in the design and implementation of long-term data strategies and automation initiatives
- Troubleshoot and resolve data-related issues with attention to quality and performance
- Adapt to evolving business needs and provide technical support to internal teams
Data Engineer Requirements
- 2–5 years of experience in a Data Engineer or similar role
- Strong proficiency in Python and SQL
- Hands-on experience working with cloud data warehouses, preferably Amazon Redshift
- Experience designing and implementing ETL workflows and data pipelines
- Familiarity with data visualization platforms (e.g., Tableau) and how data models support them
- Strong problem-solving skills and ability to work with ambiguity in a fast-paced environment
- Comfortable collaborating with both technical and non-technical stakeholders
- Excellent communication and documentation skills
- Bonus: Background in operations-heavy industries or distributed teams
Salary Expectations
The base salary for this position is approximately $90,000, with potential for profit sharing (estimated at 15–25% of salary, though not guaranteed). Additional benefits include:
- 401(k)
- Tuition reimbursement
- Health, dental, and vision insurance
- Flexible scheduling (hybrid, based on performance and manager discretion)
- Cell phone stipend
How to Apply
Please submit your application by clicking the Apply button below. Make sure your resume highlights your experience with automation, data scraping, and the tools you've used.
Crafting Your Resume
Tailor your resume to show hands-on experience with scripting and automation tools. Highlight your ability to clean and structure data, adapt to changes in external systems, and build workflows that save time and improve accuracy. Use examples and metrics when possible to demonstrate your impact—whether that’s reducing manual work, improving data access, or completing high-volume scrapes.
Interview Tips
Be prepared to:
- Walk through specific scraping or automation projects you've built
- Describe how you've handled broken scripts or unexpected site changes
- Talk through how you cleaned and structured unorganized data
- Demonstrate your problem-solving approach, especially in ambiguous or messy scenarios
- Show curiosity and a willingness to figure things out as you go—this role values resourcefulness as much as technical skill
This is a great opportunity for someone who enjoys exploring complex systems, solving technical puzzles, and building tools that make a real impact.
Ready to apply for this Automation Analyst position?
Click the Apply button to attach your resume.
Not ready to apply yet?
Contact a technical recruiter at ITjobs@jfcglobal.com or 717-761-8095 for a confidential conversation about your career goals.
With decades of industry experience, JFC Global, the largest locally owned and operated niche recruiting company, has built well-established relationships with hiring managers and HR professionals in our area.
JFC Global has received a 9.6 NPS rating from the professionals we work with and pride ourselves on operating with the highest ethics and integrity within the recruiting industry.
We look forward to putting our local connections to work for you!
Direct W2 only
EOE.
INDIT
Job Type: Full-time
Pay: $75,000.00 - $90,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Tuition reimbursement
- Vision insurance
Compensation Package:
Schedule:
- 8 hour shift
- Monday to Friday
Application Question(s):
- Which State do you currently live in?
Ability to Commute:
- York, PA 17404 (Required)
Work Location: Hybrid remote in York, PA 17404
