Data Integration / Application Engineer

sgs-job-6090

Business Support
 Massachusetts
Python
SQL
Snowflake
REST APIs
Data Pipelines
ETL/ELT
Data Integration
Workflow Automation
Data Quality
Git/GitLab
API Development
Data Warehousing

Contract - 01 Year Contract

Location : Boston, MA 02134 (Hybrid – Must be local to Boston; 2.5 days/week in office, 10 days/month starting January) We are looking for a hands-on Data Integration / Application Engineer to join BSO’s data and platform engineering pod. The candidate will work closely with the Senior Snowflake Engineer / Technical Lead to maintain and enhance Octopus and other approved data products. The role involves developing data integrations, automated pipelines, application-facing data services and reliable business solutions while ensuring data accuracy, security and maintainability.

Job Responsibilities:

  • Build and maintain scheduled data pipelines to ingest, clean, reconcile and combine data from approved enterprise systems.
  • Develop and maintain SQL transformations, data models, queries and views in Snowflake.
  • Develop APIs, reusable data services and integrations to support internal dashboards, analytical applications and operational workflows.
  • Build Python jobs and automations for recurring data preparation, quality checks, exports and system-to-system updates.
  • Implement data validation, reconciliation, error handling and logging to ensure data accuracy and reliability.
  • Deliver tested, version-controlled code and document interfaces, data mappings and operational procedures.
  • Work with business users and Product Owners to clarify requirements, demonstrate functionality, perform user testing and incorporate feedback.
  • Monitor existing pipelines and applications, resolve incidents and defects, and maintain integrations as business needs change.

Skills:

  • Strong Python programming skills for data processing, API integration, scheduled jobs and testing (pandas, requests and pytest).
  • Good SQL knowledge, including joins, transformations and data quality checks.
  • Hands-on experience with Snowflake or another cloud data warehouse.
  • Experience integrating enterprise systems through REST APIs, authentication, structured payloads and error handling.
  • Practical experience with ETL/ELT workflows, orchestration, reconciliation and monitoring of automated data flows.
  • Experience with Git/GitLab and version control.
  • Ability to write tested, documented and maintainable code.
  • Strong collaboration and communication skills with senior engineers and non-technical stakeholders.
  • Preferred experience with R Shiny, Shiny for Python or similar dashboard and application development tools.
  • Knowledge of Snowpark, dbt, Airflow or comparable data transformation and orchestration technologies.
  • Experience building reliable connectors and curated datasets for AI-enabled business workflows.
  • Familiarity with business intelligence, reporting and data preparation tools.
  • Experience with CI/CD, Docker and cloud services such as AWS.
  • Experience in pharmaceutical R&D, resource planning or regulated environments (GxP) is preferred.
  • A GitHub profile or portfolio showcasing relevant work is an advantage

Education/Experience:

  • Bachelor's degree in Computer Science, Engineering, Data Science, Information Systems or a related field, or equivalent practical experience.
  • At least 3 years of experience building or supporting data pipelines, enterprise integrations, analytical applications or internal business tools in production.
  • Must be local to Boston, MA, and available to work onsite 2.5 days per week (10 days per month) starting January.
  • Practical, collaborative engineer who enjoys connecting systems and transforming complex data into dependable business tools.
  • Ability to work iteratively, test changes and develop code that can be supported and maintained by others

Related Jobs

Forklift Operator

Business Support
 Texas
06 Months

Shift: Monday Through Friday, 8:00 AM - 5:00 PM Small Description (mandatory): We are currently looking for experienced forklift operators. You must have at least 6 months experience

Forklift
Forklift Operator
Stand-up
Sit Down
forklift certificate

Merchandiser

Business Support
 Florida
$18-$19
03 Months

Shift: Monday Through Friday, 8:00 AM - 5:00 PM Small Description : As a Merchandiser (Multiple Location), need to travel between Crystal River, FL 34429 and Lecanto, FL 34461 often to manages product presentation, stock levels, and promotional displays across several retail stores.

Merchandiser
Stock Management
Inventory Management
promotional display
Retail Store
Stocking

Hospitality Associate

Business Support
 New York
$20-$22
03 Month

Shift: Monday–Friday, 8am to 5pm Small Description : Friendly, professional, and customer-focused individual who enjoys supporting office operations, assisting employees and visitors, and ensuring meeting spaces are organized, clean, and ready for use. The role focuses on conference room setup, hospitality services, stocking supplies, and general office support. The associate will also cover the reception desk during the receptionist's lunch break. Previous reception experience is a plus but not required.

Receptionist
Admin Specialist
Front Desk
Front Office
Customer service
Hospitality
printing
copying
scanning
Mailroom
Food
Beverage
Conference setup

Facility Services Specialist

Business Support
 New York
$20-$22
03 Month

Shift: Monday Through Friday 7:00 AM - 4:00 PM (Training hours: 8:00 AM - 5:00 PM) Small Description : We are seeking a dependable and hands-on Facilities / Office Services Specialist to support daily office operations, facilities maintenance, furniture assembly, and workplace organization. The ideal candidate will have previous facilities, maintenance, custodial, or office services experience and be comfortable performing physical tasks, including office moves, furniture assembly, hanging frames, and general building maintenance.

Maintenance
Repair
Electrical
furniture assembly
office operation
office move
Office Relocation
office fixture
carpentry
Painting
trash removal
dusting
sweeping
mopping
vacuuming

Hospitality Associate

Business Support
 Texas
03 Months

Shift: Monday–Friday, 8am to 5pm Small Description : Someone who enjoys staying busy, can juggle office services and hospitality duties, works well with professional clients, and takes initiative to keep operations running smoothly.

Receptionist
Admin Specialist
Front Desk
Front Office
Customer service
Hospitality
printing
copying
scanning
Mailroom
Food
Beverage
Conference setup

Admin Specialist

Business Support
 New Mexico
$17-18/hr. on W2
12+ (Temp to Hire)

Shift: Monday–Friday, 7:30 AM – 4:30 PM We are seeking a friendly, dependable, and professional Receptionist to support daily front-office and administrative operations. The ideal candidate will have a welcoming personality, positive attitude, strong communication skills, and at least one year of relevant experience.

Receptionist
Admin Specialist
Front Desk
Front Office
Customer service
Hospitality Specialist

Warehouse Associate

Business Support
 Tennessee
05 Months

Small Description : We are seeking a reliable and hardworking Warehouse Returns Processor to manage excess returns of printer parts and related products. This position involves receiving, scanning, identifying, sorting, and processing returned items using an RF scanner (RF gun).

RF Scanner
Barcode check
Return Processor
RMA
RF Gun
Printer Part

Proposals Analyst

Business Support
Remote
05+ (Temp to Hire)

Location :- REMOTE Shift: Monday–Friday, 8am to 5pm The Analyst, Proposals role supports the end-to-end sales proposal and quoting process for new and existing business opportunities. The position works closely with sales, underwriting, operations, and customer teams to evaluate RFPs/RFIs, coordinate proposal development, manage timelines, prepare customer-facing materials, and support post-sale implementation activities

RFI
RFP
Salesforce
Loopio
Underwriter
Account management
post-sale

Digital Print Operator

Business Support
 Ohio
12+ (Temp to Hire)

Location :- Blue Ash, OH 45242 Shift: Monday–Friday, 8am to 5pm We will focus on candidates with directly relevant print-production experience and hands-on proficiency with digital production printing, finishing equipment, file Pref lighting, quality control, and managing multiple deadlines. Preferred experience with Fiery Command WorkStation, VersaWorks, InDesign, or Illustrator will also be considered

Digital Printer
Laser Printer
Guillotine
Binder
Laminator
InDesign
Illustrator
Printer
logo

At SGS Consulting, we go beyond resume-job matches, creating meaningful connections and pathways for individuals to thrive in defining careers.


© 2026 All rights reserved.
logologologologo