Data Engineer (W2 Role)

Job Title: Data Engineer
Location: Pittsburgh, PA 15222 (Fully in Ofice)
Contract to Hire***
The candidate must be local to Pittsburgh, PA and authorized to work for any employer on W2***

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. 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: Years of experience: 4-6 yrs
• 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 Google Cloud Platform)
Knowledge of financial and cost data, preferably Activity Based Costing & customer profitability systems.