Senior Software Engineer (Python, DBT, ETL)

About the role

As a Senior Software Engineer specializing in Python, DBT, and ETL at RevSpring, you will collaborate with cross-functional teams—including product managers, data engineers, and business leaders—to translate requirements into software solutions that process large volumes of data.

Responsibilities

• 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 a 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 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 and senior leadership.
• Handle all incoming support requests and errors in a timely manner, adhering to business time zone commitments.

Requirements

• 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).
• Experience with Google Dataflow (Apache Beam SDK) or equivalent Hadoop technologies.
• Experience with BigQuery or equivalent data warehouse technologies (Snowflake, Azure DW, Redshift, Athena).
• Experience with Cloud Storage Buckets (equivalent to S3).
• Experience with 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 Skills

• 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 internal and external sources.

Physical Capabilities

The physical capabilities described here are representative of those required to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform these functions.

• Regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear.
• Occasionally required to stand and walk.
• Occasionally required to lift and/or move up to 10 pounds.
• Specific vision abilities required include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.