Data Engineer

Data Engineer

Location: Pittsburgh, PA, Onsite 5 days a week. Length of Assignment: 2 months contract to hire role. Pay Rate: $45 to 50/hr. on W2 ONLY. Function of the Group: Support Costing and Profitability for Line of Business Initiatives/Projects: Costing for Customer Profitability. Industry background: Finance or banking-preferred, solid understanding of data-required.

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 (4-6 Years of experience):

• 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.

Education/Certifications: Bachelor's Degree or equivalent experience.

Pre-Screening Questions:

• Describe a scenario where you designed or optimized a large-scale ETL pipeline using Informatica and SQL/PLSQL for a data warehouse.
• How did you ensure performance, scalability, and data quality when processing high-volume financial data?
• What specific techniques (e.g., partitioning, pushdown optimization, indexing) did you apply, and how did you validate the improvements.

Interview Process: Two interviews, 1st round 30-45 mins with manager, 2nd round 1 hour deep dive technical interview panel.

Hiring Manager Stack Ranking of Importance (Most Important to Least Important): Skills, Location, Prior Client Experience, Rate.