Data Platform Engineer III

Data Platform Engineer III

Hybrid (Office 3 days/wk – Onsite-Flex) within Oregon, Washington, Idaho or Utah.

Every day, Cambia’s Data/Software Engineering Team is living our mission to make health care easier and lives better. We are the Data and Analytics Solutions division within Cambia that builds and delivers data analytics products driven by value and focuses on our members’ health care journey. We provide enterprise data technology services by crafting data solutions that enable Analytics and AI capabilities.

Our engineers specialize in a variety of technology stacks including Snowpark, DBT, Apache Airflow, Stream Lit, and integration with tools such as Collibra, Sigma, Tableau, DBT Cloud, Alteryx and AWS Glue over the Snowflake Cloud Platform.

The Senior Data Platform engineer will have extensive data product development experience specializing in database design and system testing in a cloud platform. We are looking for a seasoned engineer who can work with Product to build our software and data products with a good technical vision – all in service of making our members’ health journeys easier.

• Bachelor’s degree in Computer Science, Engineering, or related field
• 6-8+ years of relevant experience in application and database development
• 6+ years of launching, maintaining and testing data products and 3+ years of experience in data modeling, design and architecture
• 6+ years of demonstrated proficiency writing complex, efficient SQL scripts, including complex joins, aggregations, and use of analytics/windowing functions
• 4+ years of experience in cloud platforms such as Snowflake and AWS
• Equivalent combination of education and experience

• Experience in building and maintaining batch data pipelines using technologies like Airflow, Spark, EMR, S3, etc.
• Strong dedication to code quality, automation and operational excellence including CI/CD pipelines, unit/integration tests.
• Value SQL as a flexible and extensible tool and are comfortable with modern SQL data orchestration tools like DBT, Mode, or Airflow.
• Experience working with different performant warehouses and data lakes like Snowflake or equivalent.
• Maintain data privacy and integrity, and always act in the best interest of consumers.
• Experience integrating data from multiple sources into one or more targets.
• After initial training, able to maintain awareness, monitor, and manage direct computing costs, such as Snowflake credits.
• Intermediate knowledge around object-oriented languages like Java would be desirable but not required.
• Proficient with defensive programming.
• Adhere to Cambia Coding Standards and guidelines and contribute to improving our technology and coding standards.
• Able to adapt to changing technologies and methodologies and apply them to technological and/or business needs of limited scope.

• Design, build and maintain scalable data pipelines using ETL and ELT on cloud platforms.
• Develop data integration solutions to connect various data sources to a single unified source while ensuring a single source of truth.
• Develop efficient, effective, and maintainable program and system solutions to solve complex business problems.
• Develop automated workflows for data ingestion, transformation, and application integration.
• Write efficient code in languages such as SQL and Python.
• Support our product and business partners by researching, identifying and resolving highly technical programming problems.
• Meet established deadlines while maintaining a high level of quality of work.
• Determine program design and prepare work estimates for development or changes for assigned work.
• Perform testing and document the results.
• Proficiency in using version control software like Git Hub or Git Lab.
• Deliver requirements analysis, system analysis, system design, data models, program design, source code development, test case development, testing, and documentation.
• Adhere to policies, procedures, and standards in IT/Engineering and corporate guidelines including technical, architecture, production implementation, status reporting, team…