Data engineer/Python developer

Pyramid Consulting, Inc; McLean (VA); On-site; USD 96,000 - 103,000; Full time

Job summary

Pyramid Consulting, Inc. is seeking an experienced Data engineer/Python developer for a 12+ month contract in McLean, VA (onsite). The role focuses on designing and maintaining scalable Python data apps, APIs with Flask or FastAPI, and ETL pipelines using Informatica.

Ideal candidates have 5+ years Python experience, PostgreSQL design/tuning, and PySpark data transformations, with cloud and containerization familiarity to support large data projects and analytics.

Qualifications

• 5+ years of professional experience as a Python developer.
• 3+ years with PostgreSQL, including database design and performance tuning.
• 3+ years of experience developing APIs with Flask or FastAPI.
• Proven experience working with large datasets and data-intensive applications.
• Experience integrating AI or machine learning models into data pipelines or applications.
• Familiarity with Python-based machine learning libraries such as scikit-learn, TensorFlow, or PyTorch.
• 2+ years of experience with data transformation using PySpark, Dask, Polars, etc.
• Strong understanding of data modeling, data warehousing, and data integration concepts.
• Experience with version control systems (e.g., Git).
• Excellent problem-solving skills and attention to detail.
• Strong communication and teamwork abilities.
• Hands-on experience with Informatica and ETL processes.
• Experience with cloud platforms.
• Familiarity with containerization (Docker, Kubernetes).
• Knowledge of data visualization tools and techniques

Responsibilities

• Design, build, and maintain scalable Python applications for data processing and analytics.
• Develop RESTful APIs using Flask or FastAPI.
• Implement and optimize complex SQL queries and database structures in PostgreSQL.
• Architect and maintain ETL pipelines using Informatica, ensuring data quality and integrity.
• Work with large datasets, ensuring efficient data ingestion, transformation, and storage.
• Develop and optimize data transformation workflows using PySpark.
• Collaborate with cross-functional teams to define technical requirements and deliver solutions.
• Troubleshoot and resolve issues in production environments.
• Mentor junior developers and contribute to best practices.

Skills

SQL

Python

Data analysis

Education

Bachelor’s degree in Computer Science, Engineering, or related field

Tools

Informatica

Docker

Kubernetes

Job description

Immediate need for a talented Data engineer/Python developer . This is a 12+months contract opportunity with long-term potential and is located in Mclean, VA(Onsite).

Job ID:26-23558

Pay Range: $70 - $75/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities:

• Design, build, and maintain scalable Python applications for data processing and analytics.
• Develop RESTful APIs using Flask or FastAPI.
• Implement and optimize complex SQL queries and database structures in PostgreSQL.
• Architect and maintain ETL pipelines using Informatica, ensuring data quality and integrity.
• Work with large datasets, ensuring efficient data ingestion, transformation, and storage.
• Develop and optimize data transformation workflows using PySpark.
• Collaborate with cross-functional teams to define technical requirements and deliver solutions.
• Troubleshoot and resolve issues in production environments.
• Mentor junior developers and contribute to best practices.

Key Requirements and Technology Experience:

• Must have skills: SQL, Python, Data analysis.
• Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent experience).
• 5+ years of professional experience as a Python developer.
• 3+ years of experience with PostgreSQL, including database design and performance tuning.
• 3+ years of experience developing APIs with Flask or FastAPI.
• Proven experience working with large datasets and data-intensive applications.
• Experience integrating AI or machine learning models into data pipelines or applications.
• Familiarity with Python-based machine learning libraries such as scikit-learn, TensorFlow, or
• PyTorch.
• 2+ years of experience with data transformation using PySpark, Dask, Polars, etc.
• Strong understanding of data modeling, data warehousing, and data integration concepts.
• Experience with version control systems (e.g., Git).
• Excellent problem-solving skills and attention to detail.
• Strong communication and teamwork abilities.
• Hands-on experience with Informatica and ETL processes.
• Experience with cloud platforms.
• Familiarity with containerization (Docker, Kubernetes).
• Knowledge of data visualization tools and techniques

Our client is a leading Banking and Financial Industry, and we are currently interviewing to fill this and other similar contract positions.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.