JOBSEARCHER

Data Integration / Application Engineer

The Opportunity: You are a hands-on builder within BSO's data and platform engineering pod, reporting to the Business Digital, Data & AI Infrastructure Lead. You will work closely with the Senior Snowflake Engineer / Technical Lead to maintain and enhance Octopus and other approved data products, developing integrations, automated pipelines, and application-facing data services. You turn agreed business needs into reliable working solutions, test with users, and help ensure that the underlying data remains accurate, secure, and maintainable.
Key Responsibilities: Data Pipelines and Integrations: Build and maintain scheduled pipelines that ingest, clean, reconcile, and combine data from approved enterprise systems for Octopus and other BSO use cases. Snowflake Development: Write and maintain SQL transformations, data models, queries, and views in Snowflake, working with the Senior Engineer on performance, access controls, and maintainability. Application Enablement: Develop APIs, reusable data services, and integrations that support internal dashboards, analytical applications, and operational workflows. Workflow Automation: Build dependable Python jobs and automations for recurring data preparation, quality checks, exports, and system-to-system updates. Data Quality and Traceability: Implement validation, reconciliation, error handling, and logging to keep business-critical data accurate, explainable, and fit for use. Quality and Documentation: Deliver tested, version-controlled code; document interfaces, data mappings, and operational procedures; contribute validation evidence for regulated use cases where required. Testing and Collaboration: Work with business users and Product Owners to clarify requirements, demonstrate working functionality, perform user testing, and incorporate feedback. Run and Improve: Monitor existing pipelines and applications, resolve incidents and defects, and update integrations as upstream systems or business needs change.
Who You Are: (Must Haves) You are a practical, collaborative engineer who enjoys connecting systems and turning complex data into dependable business tools. You work iteratively, test your changes, and write code that others can support.
Education: Bachelor's degree in Computer Science, Engineering, Data Science, Information Systems, or a related field, or equivalent practical experience.
Experience: At least 3 years building or supporting data pipelines, enterprise integrations, analytical applications, or internal business tools in production. Python: Strong Python for data processing, API integration, scheduled jobs, and testing (for example, pandas, requests, and pytest). SQL and Snowflake: Good SQL, including joins, transformations, and data quality checks, with hands-on experience using Snowflake or another cloud data warehouse. APIs and Integration: Experience integrating enterprise systems through REST APIs, authentication, structured payloads, and error handling. Data Engineering: Practical experience with ELT/ETL workflows, orchestration, reconciliation, and monitoring of automated data flows. Ways of Working: Git/GitLab and version control; writes tested, documented code and works iteratively with senior engineers and non-technical stakeholders.
Preferred Qualifications: Experience developing dashboards or data-driven applications using R Shiny, Shiny for Python, or similar tools. Snowpark, dbt, Airflow, or comparable data transformation and orchestration technologies. Building reliable connectors and curated datasets for AI-enabled business workflows. Experience with business intelligence, reporting, and data preparation tools. Deploying applications and scheduled jobs with CI/CD, Docker, and cloud services such as AWS. Experience in pharmaceutical R&D, resource planning, or another regulated environment (GxP). A GitHub profile or portfolio showing relevant work is an advantage.