CareerZen Logo
Company logo

Senior SQL / Oracle DBA

Alliance Consulting Corp

Full-time

Remote

Job description

Senior Python Developer/Database Administrator

The Developer is responsible for designing, developing, and implementing Python based automation to execute the reconciliation process. They are responsible for building robust, scalable ETL data pipelines that extract, transform, and load data from multiple sources into an integrated platform. This role develops, tests, and deploys Python automation scripts and workflows, ensuring accuracy, efficiency, and reliability throughout the reconciliation lifecycle. Working within cloud and enterprise data environments, they collaborate closely with technical leads and stakeholders to translate requirements into well-architected, maintainable solutions and continuously enhance automation performance.

Key Responsibilities:

  • Design, develop, and maintain robust ETL pipelines for data integration across multiple sources.
  • Refactor existing code and automated processes into Python, validating functionality through detailed test cases and user feedback.
  • Implement scalable data solutions using Python and cloud-based platforms such as Databricks and Apache Airflow.
  • Collaborate with data scientists and analysts to ensure seamless data accessibility and usability.
  • Optimize data architecture and workflows to enhance efficiency, performance, and security.
  • Troubleshoot data pipeline issues and ensure data integrity across systems.

The ideal candidate must have the following experience, background, and credentials:

  • 5+ years of experience in data and automation engineering with a strong focus on Python
  • 3+ years of experience developing, maintaining, and administrating SQL databases
  • 2+ years of experience working with cloud-based data platforms such as Databricks, Apache Airflow, or other AWS services (e.g. Lambda, S3)
  • Experience designing, testing, and deploying robust ETL workflows and integrate with enterprise data systems.
  • Be a U.S. citizen able to pass a background investigation by the client agency. DHS clearance with CBP/ICE, or DoD Top-Secret preferred.

Preferred Skills:

  • Experience with Optical Character Recognition (OCR) and Document Understanding frameworks (e.g., AWS Textract, Tesseract, or layout-aware models)
  • Familiarity with DevOps practices such as version control, CI/CD, and containerized deployment.

Job Type: Full-time

Pay: $130,000.00 - $150,000.00 per year

Benefits:

  • 401(k)
  • 401(k) matching
  • Dental insurance
  • Employee assistance program
  • Flexible schedule
  • Flexible spending account
  • Health insurance
  • Life insurance
  • Professional development assistance
  • Tuition reimbursement
  • Vision insurance

Application Question(s):

  • This position requires U.S. citizenship. Are you a U.S. citizen ?
  • Do you have a DHS or a DoD clearance ?

Experience:

  • Python: 4 years (Required)

Work Location: Remote