Software Engineer II (Python, DBT, ETL)
About The Position
The Software Engineer II works with product owners and teammates to implement well-defined requirements, asking clarifying questions early. The role builds and maintains data pipelines, DBT transformations, and integrations for healthcare data using FHIR and related standards, contributing to design discussions with guidance from senior engineers. It involves writing clean, maintainable, reusable code; participating in code reviews; improving performance and reliability; and keeping current with data processing and ETL advancements. The engineer attends weekly stakeholder meetings and provides work updates, thoroughly tests code, and supports releases through stakeholder sign-off. The role also participates in a support rotation, triaging and resolving issues within SLA and escalating when needed. The position requires the ability to read and interpret business and technical materials, write reports and procedures, and present information to internal and external audiences.
Requirements
- Bachelor’s degree.
- At least 2 years of experience building data pipelines with Python.
- Hands-on experience building data models and transformations with DBT.
- Knowledge and understanding of complex data pipelines using ETL processes.
- At least 3 years of experience using relational databases and deep knowledge of SQL, including the ability to understand complex data relationships and transformations.
- Knowledge and understanding of Git.
- Ability to read, analyze, and interpret business periodicals, professional journals, technical procedures, or governmental regulations.
- Ability to write reports, business correspondence, and procedure manuals.
- Ability to present information effectively and respond to questions from internal and external sources.
Nice To Haves
- At least 3 years of experience with BigQuery and other GCP-native technologies.
- Experience with Google Dataflow (Apache Beam SDK) or equivalent Hadoop technologies.
- Experience with BigQuery or equivalent data warehouse technologies such as Snowflake, Azure DW, Redshift, or Athena.
- Experience with Cloud Storage Buckets or equivalent storage such as S3.
- Experience using a CLI.
- Experience with FHIR and related healthcare data standards.
- Experience with Apache Airflow or Google Composer.
- Knowledge of Docker, Linux, Shell/Bash, and virtualization technologies.
- Knowledge of CI/CD methodologies.
- Ability to understand and build UML diagrams to showcase complex logic.
- Experience with Infrastructure as Code technologies such as Pulumi, Terraform, or CloudFormation.
- Experience with observability and logging platforms such as DataDog.
Responsibilities
- Work with product owners and teammates to implement well-defined requirements and ask clarifying questions early.
- Build and maintain data pipelines and DBT transformations, contributing to design discussions with guidance from senior engineers.
- Build and maintain healthcare data integrations using FHIR and related standards.
- Write clean, maintainable, reusable code that follows best practices and coding standards.
- Participate in code reviews and provide constructive feedback.
- Contribute to performance and reliability improvements and identify bottlenecks in own code.
- Stay current with data processing and ETL advancements and apply them to improve products.
- Attend weekly stakeholder meetings and provide status updates.
- Thoroughly test code and support the release process, including stakeholder sign-off.
- Participate in the support rotation, triaging and resolving issues within SLA and escalating when needed.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
