Senior PostgreSQL Data Engineer - Scale Big Data Pipelines

NetSmart Technologies; Overland Park (KS); On-site; USD 110,000 - 160,000; Full time

Job summary

Netsmart is seeking an experienced Data Engineer to design, optimize, and lead complex data pipelines and integration strategies that support advanced analytics and scalable enterprise data platforms.

The role requires expertise in Python, Spark, SQL, and big data technologies, with strong emphasis on data warehousing, data modeling, and ETL tooling. Collaboration with cross-functional teams and governance of data processes are essential.

Qualifications

• Bachelor's degree in CS/IT or related field.
• At least 5 years of experience in data engineering or related roles.
• Advanced proficiency in multiple programming languages (Python, Java, Scala) and expert-level SQL.
• Extensive experience with big data technologies (Hadoop ecosystem, Spark, Kafka) and cloud environments (Azure, AWS, or GCP).
• Proven experience in designing and implementing large-scale data warehousing solutions.
• Deep understanding of data modeling techniques and enterprise-grade ETL tools.
• Demonstrated ability to solve complex analytical problems.
• SQL - Strong SQL skills required, preferably PostgreSQL.
• ETL - Python with Spark; AWS Glue, Lambda, and Airflow preferred.

Responsibilities

• Design, implement, and optimize complex data pipelines using advanced SQL, ETL tools, and integration technologies.
• Collaborate with cross-functional teams to implement optimal data solutions for analytics and data science initiatives.
• Spearhead process improvements, including automation, data delivery optimization, and infrastructure redesign for scalability.
• Evaluate and recommend emerging data technologies to build comprehensive data integration strategies.
• Lead technical discovery processes, defining complex requirements and mapping out detailed scenarios.
• Develop and maintain data governance policies and procedures.

Skills

Python

SQL

Spark

Big data

Education

Bachelor's degree in Computer Science, Information Management, or related field

Tools

AWS

Airflow

Hadoop

Kafka

Job description

Netsmart is seeking an experienced Data Engineer to design, optimize, and lead complex data pipelines and integration strategies that support advanced analytics and scalable enterprise data platforms.

The role requires expertise in Python, Spark, SQL, and big data technologies, with strong emphasis on data warehousing, data modeling, and ETL tooling. Collaboration with cross-functional teams and governance of data processes are essential.