Senior Data Engineer

Bitwise Solutions; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

Bitwise Solutions is seeking a Senior Data Engineer dedicated to building scalable data platforms. You will design and optimize PostgreSQL databases on AWS RDS, develop robust ETL pipelines, and shape data models for analytics and ML workflows.

The role requires strong Python development, experience with AWS Glue and Batch, and hands-on CI/CD work with Jenkins and Git. You will collaborate with stakeholders to deliver secure, high-quality data solutions and support data-driven decisions across

Qualifications

• Senior-level experience in database engineering with PostgreSQL (AWS RDS).
• Expertise in database architecture, optimization, and advanced SQL.
• Experience developing and maintaining database objects (tables, views, procedures, functions, packages).
• Proficient in Python for data engineering and ETL.
• Hands-on experience with AWS Glue, AWS Batch, and AWS S3.
• Experience with data migration and processing large datasets.
• Familiarity with CI/CD pipelines, Jenkins, and Git.
• Strong problem-solving and communication skills; team collaboration.
• Experience with AI/ML libraries and frameworks.

Responsibilities

• Architect, develop, and maintain robust database structures (PostgreSQL on AWS RDS).
• Optimize database performance with complex SQL queries.
• Develop procedures and scripts for data migration and processing large data volumes.
• Design and manage ETL pipelines using Python and AWS Glue/Batch with S3.
• Collaborate with stakeholders to deliver secure, high-quality data solutions.
• Implement and maintain CI/CD pipelines; automate deployments with Jenkins and Git.
• Support AI/ML initiatives by preparing data for model training and inference.

Skills

PostgreSQL

Advanced SQL

Python

Data modeling

Tools

AWS Glue

AWS Batch

AWS S3

Jenkins

Git

Job description

Role: Senior Data Engineer

Location: Remote

Notice Period: Immediate to 30 days

Position overview:

We are seeking a Senior Data Engineer with a primary focus on database architecture, optimization, and management. The ideal candidate will have deep expertise in PostgreSQL (AWS RDS), advanced SQL, and database development, along with strong Python skills for data engineering and ETL processes. Experience with AWS Glue, AWS Batch, AWS S3, and CI/CD tools (Jenkins, Git), and AI-related technologies is also required.

Key Responsibilities:

• Architect, develop, and maintain robust database structures (tables, views, procedures, functions, packages) with a focus on PostgreSQL (AWS RDS).
• Optimize database performance, write and debug complex SQL queries, and ensure reliability and scalability of the database layer.
• Develop procedures, packages, and scripts for data migration and processing large volumes of structured and unstructured data.
• Design and manage ETL pipelines using Python and AWS Glue/Batch, integrating with AWS S3 for data storage.
• Collaborate with stakeholders to deliver secure, high-quality data solutions.
• Implement and maintain CI/CD pipelines, automate deployments with Jenkins, and manage code with Git.
• Support AI and machine learning initiatives by preparing, processing, and managing data for model training and inference.

Required Skills & Qualifications:

• Senior-level experience in database engineering, especially with PostgreSQL (AWS RDS).
• Expertise in database architecture, optimization, and advanced SQL.
• Experience developing and maintaining database objects (tables, views, procedures, functions, packages).
• Proficient in Python for data engineering and ETL.
• Hands-on experience with AWS Glue, AWS Batch, and AWS S3.
• Experience with data migration and processing large datasets.
• Familiarity with CI/CD pipelines, Jenkins, and Git.
• Strong problem-solving, communication, and collaboration skills.
• Experience with AI and machine learning libraries and frameworks.