Job Description

Do you love a career where you Experience , Grow & Contribute at the same time, while earning at least 10% above the market? If so, we are excited to have bumped onto you.

Learn how we are redefining the   meaning of work , and be a part of the team raved by Clients, Job-seekers and Employees.

If you are a  Data Engineer   Position looking for excitement, challenge and stability in your work, then you would be glad to come across this page.

We are an IT Solutions Integrator/Consulting Firm helping our clients hire the right professional for an exciting long term project. Here are a few details.

Check if you are up for maximizing your earning/growth potential, leveraging our Disruptive Talent Solution.

Requirements

Role: Data Engineer  

Location: Weehawken, NJ

Exp:8+ Years

Requirements

We are seeking an experienced SQL & Python Data Engineer with a strong background in SQL development, performance tuning, and Python programming for data engineering . The ideal candidate will have expertise in advanced SQL queries, stored procedures, and query optimization , along with experience in Apache Airflow for workflow automation . The role involves working on large-scale data platforms , ensuring efficient data processing and ETL workflows .

Key Responsibilities:

• Develop, optimize, and maintain complex SQL queries, functions, and stored procedures to support data processing and analytics workflows.
  
• Analyze and optimize SQL performance by improving indexing, partitioning, and query execution plans.
  
• Develop scalable and efficient data pipelines using Python for data engineering and transformation.
  
• Implement and manage workflow automation using Apache Airflow , ensuring smooth execution of data pipelines.
  
• Monitor and troubleshoot SQL and Python scripts to ensure high performance and reliability.
  
• Collaborate with cross-functional teams to gather requirements and design efficient database solutions .
  
• Work on ETL processing, data ingestion, and transformation pipelines for structured and semi-structured data.
  
• Ensure data integrity and consistency by implementing best practices in SQL and Python development.
  
• Stay updated with industry trends and recommend improvements to optimize data infrastructure and performance.
  

Must-Have Skills:

✔ 8+ years of hands-on experience with SQL and Python programming.

✔ Expertise in writing complex SQL queries, stored procedures, functions, and performance tuning techniques .

✔ Strong experience in Python for data engineering use cases , including data transformation, ETL, and automation.

✔ Proficiency in query optimization, indexing, and partitioning strategies to improve SQL performance.

✔ Experience with Apache Airflow for workflow automation and scheduling.

✔ Strong analytical and problem-solving skills in handling large-scale data.

✔ Excellent communication and interpersonal skills , with the ability to work in high-performance environments.

Good-to-Have Skills (Preferred but Not Mandatory):

➕ Working knowledge of Greenplum platforms for large-scale data processing.

➕ Experience with distributed databases and cloud-based data warehousing .

➕ Familiarity with data pipeline orchestration tools such as Prefect or Luigi .

➕ Knowledge of big data technologies (Hadoop, Spark, Kafka, etc.) .

➕ Exposure to DevOps practices for data engineering .

Benefits

Visit us at  . Alignity Solutions is an Equal Opportunity Employer, M/F/V/D.

CEO Message:   Click Here

Clients Testimonial:   Click Here

Job Tags

Similar Jobs