Motion Recruitment
Data Integration / Application Engineer
Job at a glance
- Workplace
- On-site
- Sector
- Engineering & Technology
- Posted
- Nov 17, 2026
- First found
- Nov 17, 2026, 12:08 PM ET
What's your fit?
Score your resume against this job to see your fit, the gaps and the risks.
About the job
**Job Title: Data Integration / Application Engineer
Job Location: Boston, MA 02134
Job Duration: 12 months contract with possible ext**
Description:
Hybrid role; worker must be local to Boston: 60 Western Ave, Suite 9100, 9th floor, Boston, MA 02134
Starting in January, worker must be in office 2.5 days/week, 10 days/month
Conversion to FTE possible, depending on performance
The Opportunity
As a Data Integration / Application Engineer, 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.