Data Engineer

System One; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

System One in Pittsburgh, PA is seeking a Data Engineer for a contract-to-hire engagement. The role focuses on data engineering, ETL development, and building scalable data pipelines for large-scale financial datasets.

You will collaborate with Finance stakeholders, design data solutions, mentor junior engineers, and contribute to documentation, code reviews, and testing in an Agile environment. Experience with Informatica PowerCenter or Informatica Intelligent Cloud Services is required.

Qualifications

• 6+ years of data engineering and ETL development experience.
• Experience with Informatica PowerCenter and/or Informatica Cloud/IICS.
• Advanced SQL/PLSQL skills and large-scale data transformations.
• Experience with data warehousing platforms (SQL Server, Oracle, Teradata).
• Ability to write and optimize code for scalable data pipelines.
• Familiarity with Agile/Scrum environments and collaborating with stakeholders.

Responsibilities

• Analyze requirements with users and management to scope solutions.
• Collaborate with Finance stakeholders to implement data solutions.
• Mentor junior engineers and contribute to team growth.
• Design and document technical specifications for proposed solutions.
• Participate in code reviews and testing; ensure robust data pipelines.

Skills

Data engineering

ETL development

SQL/PLSQL

Informatica

Data warehousing

Big data

Agile/Scrum

Stakeholder comms

Cloud platforms

Tools

Udeploy

Artifactory

Job description

Position Title: Data Engineer
Location: PA – Pittsburgh (Locals Preferred)
Work Status: Onsite 5 days a week
Duration: Contract to Hire
Years Of Experience Required: 6+ Years

Industry Background: Finance / Banking
Function of the Group: Support Costing and Profitability for Line of Business
Initiatives/Projects: Costing for Customer Profitability

Roles and Responsibilities

• Analyzes and evaluates requirements by working with users, product owners and management and provides recommendations on the scope and complexity of the solution.
• Collaborate with Finance Product owners and analysts to gather requirements and implement data solutions that meet business needs.
• Proactive and detail-oriented professional with strong sense of ownership; Creative problem solver who can tackle complex data challenges.
• Mentor who can guide junior engineers and contributes to team growth.
• Proposes & designs data solutions to address complex business needs.
• Prepares technical and procedural documentation required.
• Acts as a lead by developing and documenting technical specifications for proposed solutions.
• This includes hands‑on coding and testing as well to support solutions.
• Participates in code reviews & overall testing.
• Excellent problem‑solving and collaboration skills.

Must Have Technical Skills

• Strong experience in data engineering and ETL development
• Strong experience with Informatica (PowerCenter and/or Informatica Cloud/IICS)
• Advanced SQL, PL/SQL skills and experience with large-scale data transformations
• Experience with data warehousing platforms (e.g. SQL Server, Oracle, Teradata)
• Writing and optimizing code for data pipelines to ensure systems are highly efficient, scalable, and capable of handling large-scale financial datasets.
• Familiarity with Agile/Scrum development environments
• Strong collaboration and communication skills for working with finance and business stakeholders

Flex Skills / Nice to Have

• Proficient with code deployment tools such as Udeploy, Artifactory; Experience with cloud data platforms (Azure, AWS, or GCP)
• Knowledge of financial and cost data, preferably Activity Based Costing & customer profitability systems.