Lead Data Engineer: Oracle, PySpark & ETL Specialist

Saransh Inc; Charlotte (NC); On-site; USD 130,000 - 180,000; Full time

Job summary

Saransh Inc. is seeking a Lead Data Engineer in Charlotte, NC to design, implement, and maintain robust data pipelines. The role requires hands-on Oracle RDMS, SQL/PLSQL, and Python/PySpark expertise to deliver scalable analytics solutions.

You will collaborate with cross-functional teams, ensure data quality, and drive best practices in data engineering across the organization. This position emphasizes strong ETL development and data governance.

Qualifications

• Advanced Oracle RDMS expertise, including object creation (tables, views, indexes, partitioned objects).
• Proficient in SQL and PL/SQL for data manipulation and analysis.
• Strong experience with K shell scripting, including sed, awk, grep, and invoking SQL Plus shell.
• Hands-on experience with NDM (Connect:Direct) for file transfers.
• Familiarity with Autosys for job scheduling and monitoring.
• Proficient in Python and PySpark for data processing and analytics.
• Experience using GitHub as a code repository.
• Comfortable using GitHub Copilot for AI development efficiencies.

Responsibilities

• Design, develop, and optimize complex SQL queries and PL/SQL scripts for ETL.
• Create and manage Oracle database objects including tables, views, indexes, and partitioned objects.
• Implement and manage file transfers using NDM (Connect:Direct) to ensure secure data movement.
• Utilize Autosys for job scheduling and monitoring to ensure timely execution of data processes.
• Develop and maintain data processing workflows using Python and PySpark for large-scale data processing.
• Leverage GitHub as a code repository for version control and collaboration on data engineering projects.
• Utilize GitHub CoPilot to enhance development efficiency and streamline coding processes.
• Collaborate with cross-functional teams to gather requirements and deliver data solutions.
• Ensure data quality and integrity through rigorous testing and validation processes.
• Stay updated with industry trends and best practices in data engineering and contribute to continuous improvement initiatives.

Skills

Oracle RDMS

SQL

PL/SQL

Python

PySpark

GitHub

GitHub Copilot

Tools

NDM (Connect:Direct)

Autosys

K shell scripting

Job description

Saransh Inc. is seeking a Lead Data Engineer in Charlotte, NC to design, implement, and maintain robust data pipelines. The role requires hands-on Oracle RDMS, SQL/PLSQL, and Python/PySpark expertise to deliver scalable analytics solutions.

You will collaborate with cross-functional teams, ensure data quality, and drive best practices in data engineering across the organization. This position emphasizes strong ETL development and data governance.