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