Senior Software Engineer (Python, DBT, ETL)

RevSpring, Inc.; Phoenix (AZ); On-site; USD 150,000 - 190,000; Full time

Job summary

RevSpring, Inc. is seeking a Senior Software Engineer specializing in Python, DBT and ETL to design, build and maintain data pipelines that process large data sets.

You will collaborate with product managers, data engineers and business leaders to translate requirements into scalable software solutions and ensure reliable data processing. The role requires hands-on experience with Python, DBT, SQL, and BigQuery on GCP, plus familiarity with CI/CD, Docker and Linux.

Qualifications

• 5+ years building data pipelines with Python (required).
• DBT transformations experience (required).
• ETL data pipelines knowledge (required).
• 4+ years SQL with complex data relationships (required).
• Git familiarity (required).
• 3+ years BigQuery and other GCP-native tech (preferred).
• Experience with FHIR and healthcare data (preferred).
• Experience with Apache Airflow / Google Composer (preferred).
• Docker, Linux, Shell/Bash, virtualization knowledge (required).
• CI/CD methodologies understanding (required).
• Ability to design UML diagrams to showcase complex logic (preferred).

Responsibilities

• Collaborate with product managers and data teams to translate requirements into software.
• Design, build and maintain Python data pipelines and DBT transformations for ETL.
• Build and maintain healthcare data integrations using FHIR standards.
• Write clean, maintainable code following best practices and standards.
• Conduct thorough code reviews to ensure high-quality codebase.
• Optimize software performance for scalability and reliability.
• Stay current with data processing trends and apply them to products.
• Meet with product owners weekly to discuss priorities and requirements.
• Ensure new code is tested and approved by stakeholders and leadership.
• Handle incoming support requests and errors promptly within time frames.

Skills

Python

DBT

ETL

SQL

Git

BigQuery

GCP

FHIR

Airflow

Docker

Linux

CI/CD

UML

Tools

Airflow

Docker

Linux

GCloud CLI

CI/CD tools

Job description

Job Title: Senior Software Engineer (Python, DBT, ETL)

What you will do in a Senior Software Engineer (Python, DBT, ETL) role at RevSpring:

• Collaborate with teams across the organization, including product managers, data engineers and business leaders, to translate requirements into software solutions to process large amounts of data.
• Design, build, and maintain data pipelines in Python and data transformations in DBT, ensuring ETL and data processes run efficiently and reliably.
• Build and maintain integrations for healthcare data using FHIR and related standards.
• Write clean, maintainable, and reusable code that adheres to best practices and coding standards.
• Conduct thorough code reviews and provide constructive feedback to ensure high-quality codebase.
• Optimize software performance and ensure scalability and reliability.
• Stay up to date with the latest trends and advancements in data processing and ETL development and apply them to enhance our products.
• Meet with product owners and other stakeholders weekly to discuss priorities and project requirements.
• Ensure deployment of new code is tested thoroughly and has business sign off from stakeholders as well as senior leadership.
• Handle all incoming support requests and errors in a timely manner and within the necessary time frame and time zone commitments to the business.

What You Will Bring

• 5+ years of experience building data pipelines with Python (required)
• Hands-on experience building data models and transformations with DBT (required)
• Knowledge and understanding of complex data pipelines utilizing ETL processes (required)
• 4+ years of experience using relational databases and deep knowledge of SQL with the ability to understand complex data relationships and transformations (required)
• Knowledge and understanding of Git (required)
• 3+ years of experience with BigQuery and other GCP-native technologies (preferred)
  • Google Dataflow (Apache Beam SDK) (equivalent Hadoop technologies)
  • BigQuery (equivalent of any data warehouse technologies: Snowflake, Azure DW, Redshift, Athena)
  • Cloud Storage Buckets (equivalent to S3)
  • GCloud CLI
• Experience with FHIR and related healthcare data standards (preferred)
• Experience with Apache Airflow / Google Composer
• Knowledge and understanding of Docker, Linux, Shell/Bash and virtualization technologies
• Knowledge and understanding of CI/CD methodologies
• Ability to understand and build UML diagrams to showcase complex logic

Bonus Points For Tech Enthusiasts

• Infrastructure as Code technologies (Pulumi, Terraform, CloudFormation)
• Experience with observability and logging platforms (DataDog)

Language Skills

Ability to read, analyze and interpret general business periodicals, professional journals, technical procedures or governmental regulations. Ability to write reports, business correspondence and procedure manuals. Ability to effectively present information and respond to questions from a variety of both internal and external sources.

Physical Capabilities: Standard categories

The physical capabilities described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee is occasionally required to stand and walk. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

RevSpring is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

Note:

This Job Description may not describe all of the job responsibilities and standards assigned to this position. The duties may change from time to time. RevSpring does not discriminate against any group in hiring or employment practices. Nothing in this job description constitutes a contract for employment.