Senior Data Engineer: Scalable Pipelines & Data Warehousing

Artifintech; Jersey City (NJ); On-site; USD 120,000 - 160,000; Full time

Job summary

Artifintech is seeking an experienced Data Engineer to build scalable data pipelines, data warehouses, and integration solutions. The role focuses on transforming raw data into analytics-ready datasets to support BI, reporting, and data science initiatives.

The ideal candidate has 5+ years in data engineering with Python, SQL, and cloud data platforms. You will collaborate with analysts, scientists, and stakeholders, and contribute to Agile delivery with automated deployments.

Qualifications

• Bachelor's degree or equivalent experience in a technical field.
• 5+ years of data engineering, data integration, or ETL development experience.
• Strong proficiency in Python, SQL, and data transformation techniques.
• Hands-on experience with cloud data platforms and distributed processing.
• Understanding of relational databases and data warehousing concepts.

Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines for structured and semi-structured data.
• Ingest data from APIs, databases, files, and streaming sources.
• Build scalable data transformation workflows using Python, SQL, and Spark.
• Develop and optimize data warehouse tables, data models, and analytical datasets.
• Implement batch and real-time data processing solutions.
• Improve query performance, pipeline reliability, and data processing efficiency.
• Implement data quality checks, validation rules, reconciliation, and error-handling mechanisms.
• Monitor production pipelines and troubleshoot data failures.
• Apply data security, access controls, and governance standards.
• Collaborate with data analysts, data scientists, architects, and business stakeholders.
• Automate deployments and support CI/CD practices.
• Maintain technical documentation and participate in Agile development activities.

Skills

Python

SQL

PySpark

Data modeling

Data warehousing

Data governance

Distributed processing

Cloud data platforms

Performance tuning

Production support

Automation

APIs

Education

Bachelor's degree in CS/IT/Engineering

Tools

Informatica

Azure Data Factory

AWS Glue

Snowflake

Databricks

Amazon Redshift

Google BigQuery

Apache Spark

Hadoop

Kafka

PostgreSQL

SQL Server

Oracle

MySQL

AWS

Azure

GCP

Git

CI/CD

Docker

Job description

Artifintech is seeking an experienced Data Engineer to build scalable data pipelines, data warehouses, and integration solutions. The role focuses on transforming raw data into analytics-ready datasets to support BI, reporting, and data science initiatives.

The ideal candidate has 5+ years in data engineering with Python, SQL, and cloud data platforms. You will collaborate with analysts, scientists, and stakeholders, and contribute to Agile delivery with automated deployments.