Hi Candidate
My name is Vinod Nagwanshi, and I'm a Technical Recruiter with Infobahn SoftWorld Inc. I specialize in connecting experienced technology professionals with opportunities that align with their technical expertise and career interests. I'm currently working on an opportunity with one of our clients for a Data Integration / Snowflake engineering based in Boston, MA, and your background caught my attention.
Our client is looking for a hands-on engineer to join its Data and Platform Engineering team, focusing on building and maintaining enterprise data integrations, automated pipelines, and application-facing data solutions.
This role combines SQL/Snowflake engineering, Python development and REST API integrations. The individual will be responsible for connecting data across enterprise systems, developing Python-based ETL/ELT workflows, transforming and managing data in Snowflake, and building reliable integrations that support internal applications, dashboards, and business processes.
You will collaborate closely with a Senior Snowflake Engineer / Technical Lead and business stakeholders to develop solutions, improve data quality, automate workflows, and support production applications.
Data Integration / Snowflake engineering
12+ Months
Boston, MA 02134 (Hybrid)
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.