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 healthcare data integrations using FHIR and related standards. The engineer writes clean, maintainable, reusable code; participates in code reviews; and contributes to performance and reliability improvements. The position also involves keeping current with data processing and ETL developments, attending weekly stakeholder meetings, providing status updates, thoroughly testing code, and supporting releases through stakeholder sign-off. The engineer participates in a support rotation, triaging and resolving issues within SLA and escalating when necessary. This role requires hands-on DBT experience, understanding of complex ETL pipelines, strong SQL and relational database experience, Git knowledge, and experience building Python data pipelines. Familiarity with GCP and data warehouse technologies, FHIR, Airflow or Google Composer, Docker, Linux, shell scripting, virtualization, CI/CD, and UML diagrams is also relevant. Bonus experience includes Infrastructure as Code and observability or logging platforms.
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, and governmental regulations; write reports, business correspondence, and procedure manuals; and present information 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, or equivalent technologies, including Google Dataflow (Apache Beam SDK), data warehouses, cloud storage, and CLI tools.
- Experience with FHIR and related healthcare data standards.
- Experience with Apache Airflow or 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.
- 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, and 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.
- Keep up with developments in data processing and ETL and apply them to improve products.
- Attend weekly stakeholder meetings and provide status updates.
- Test code thoroughly and support releases, including stakeholder sign-off.
- Participate in the support rotation, triage and resolve issues within SLA, and escalate 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
