Data Engineer

Metropolitan Companies; Wyomissing (Berks County); On-site; USD 75,000 - 95,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k) Plan

Paid Time Off

Bonus Program

Job summary

Metropolitan Companies is seeking a Data Engineer to enhance their data environments in Wyomissing. The role involves building and optimizing data pipelines, troubleshooting database issues, and ensuring data accuracy for various teams. Ideal candidates have 2-5 years of relevant experience, strong SQL skills, and an analytical mindset. Metropolitan Companies offers competitive benefits, including health insurance, bonus opportunities, and a 401(k) plan, making it an exciting opportunity for growth in a fast-paced environment.

Qualifications

• 2–5 years of experience working with databases or data-related roles.
• Strong knowledge of SQL including queries, joins, and performance tuning.
• Experience with SQL Server or similar relational databases.

Responsibilities

• Design, build, and maintain data pipelines for internal applications and reporting.
• Write, optimize, and maintain SQL queries and stored procedures.
• Support and monitor SQL Server and improve database efficiency.

Skills

SQL knowledge

Database administration

Data engineering

Automation skills

Analytical thinking

Tools

SQL Server

PowerShell

Python

ETL tools

Reporting tools

Job description

Data Engineer

Department: IT Development

Employment Type: Full Time

Location: Metropolitan Companies Wyomissing

Description

Metropolitan Companies is seeking a Data Engineer to support our growing data and application environment. This role will serve as a critical bridge between traditional database administration and modern data engineering—supporting data pipelines, integrations, reporting, and database performance.

This position is ideal for someone who has a strong foundation in SQL and databases, and is looking to grow into data engineering, automation, and analytics. The individual will work closely with developers, business teams, and IT leadership to ensure data is accurate, accessible, and optimized for business use.

This is an excellent opportunity for a motivated professional with a strong technical background who enjoys working in a fast-paced, evolving environment. We offer a competitive compensation package including medical, dental, vision, life insurance, disability coverage, 401(k), bonus opportunities, paid time off, and more.

Key Responsibilities

• Design, build, and maintain data pipelines for internal applications and reporting
• Write, optimize, and maintain SQL queries, stored procedures, and database jobs
• Support and maintain SQL Server and other relational databases
• Monitor database performance, troubleshoot issues, and improve efficiency
• Assist with ETL/ELT processes to move and transform data between systems
• Work with APIs and external systems to integrate data into internal platforms
• Ensure data integrity, consistency, and reliability across systems
• Support reporting needs for operations, finance, and leadership teams
• Assist in managing backups, restores, and disaster recovery processes
• Document data flows, schemas, and processes for internal use
• Collaborate with development teams on data structures and application performance

Skills, Knowledge and Expertise

Requirements:

• 2–5 years of experience working with databases or data-related roles
• Strong knowledge of SQL (queries, joins, indexing, performance tuning)
• Experience with SQL Server or similar relational databases
• Understanding of data structures and relational design
• Experience writing scripts or automations (PowerShell, Python, or similar)
• Ability to troubleshoot data issues and think analytically
• Strong attention to detail and data accuracy

Preferred:

• Experience with ETL tools or data pipeline frameworks
• Familiarity with APIs and data integrations
• Exposure to cloud platforms (AWS, Azure, or GCP)
• Experience with reporting tools (Power BI, Tableau, etc.)
• Understanding of CI/CD or version control (Git)
• Basic knowledge of data warehousing concepts

Benefits

• Medical, Dental, Vision Insurance
• Voluntary Benefits (Life Insurance, Short-Term & Long-Term Disability)
• Health Savings Account (HSA)
• 401(k) Plan
• Holiday Pay
• Paid Time Off
• Bonus Program
• Employee Referral Bonus