Senior Data Engineer

Medadvisor Solutions
Woburn, MA

Position Summary:

We are seeking a Senior Data Engineer with deep expertise in SQL Server and Google BigQuery to design and implement robust, scalable data solutions. In this role, you’ll be a key contributor to our data architecture strategy, helping to bridge legacy systems with modern cloud-based infrastructure and drive data reliability, accessibility, and performance across the organization.


Key Responsibilities:


  • Design, build, and optimize scalable data pipelines across SQL Server and BigQuery .


  • Lead efforts to migrate and integrate data between legacy systems (SQL Server) and Google Cloud ( BigQuery ).


  • Develop and maintain complex stored procedures, ETL processes, and data models.


  • Optimize SQL queries and data workflows for performance, cost-efficiency, and reliability.


  • Collaborate with cross-functional teams including data analysts, data scientists, and business stakeholders to understand data needs and deliver solutions.


  • Establish best practices for data architecture, governance, quality, and security.


  • Mentor junior engineers and contribute to the continuous improvement of the data engineering function.


  • Document technical designs, data flows, and process standards.


Required Qualifications:


  • Bachelor's degree in computer science , Engineering, Information Systems, or a related field.


  • 5+ years of experience in data engineering or a similar role.


  • Advanced experience with Microsoft SQL Server (T-SQL, stored procedures, indexing, SSIS).


  • Strong hands-on experience with Google BigQuery and the Google Cloud Platform ecosystem (e.g., Cloud Storage, Dataflow, Pub/Sub).


  • Proven track record of building and maintaining high-volume, reliable ETL/ELT pipelines.


  • Experience with data warehousing concepts, star/snowflake schema, and data modeling.


  • Proficient in a scripting language (e.g., Python or Shell) for automation and data processing.


  • Excellent problem-solving, communication, and collaboration skills.


Preferred Qualifications:


  • Experience with data orchestration tools (e.g., Apache Airflow, dbt ).


  • Familiarity with CI/CD pipelines and DevOps in a data context.


  • Understanding of cost optimization strategies in BigQuery .


  • Experience in agile environments and working with distributed teams.

Posted 2025-08-23

Recommended Jobs

Front Desk Agent

Anadi Hotels
Massachusetts

Job Description Job Description We are looking for a Front Desk Agent to serve as our guests’ first point of contact and manage all aspects of their accommodation. Hotel Front Desk Agent respon…

View Details
Posted 2025-07-25

RN - Medical Specialties/Oncology

Cambridge Health Alliance
Cambridge, MA

Requisition Number: 8281 Location: CHA Cambridge Hospital  Work Days: M-F Category: Registered Nurse   Department: Medical Specialties Clinic at CHA Cambridge Hospital  Job Type:Part time   …

View Details
Posted 2025-08-07

Future Openings

The Chestnut Hill School
Chestnut Hill, MA

Job Description Job Description New positions at The Chestnut Hill School become open from time to time. If you do not see the position you are looking for, apply here for future consideration. W…

View Details
Posted 2025-09-01

Mental Health Therapist

Healing Well Counseling
Boston, MA

Job Description Job Description Psychotherapist/Full -Time (Virtual) Are you a newly graduated therapist who is eager to help those who have experienced trauma? At Healing Well Counseling, we m…

View Details
Posted 2025-08-06

Inventory Assistant Manager

Osterville Hardware
Osterville, MA

Job Description Job Description Benefits: Employee discounts Paid time off Training & development About Us Osterville Hardware is a small-town hardware store rooted in excellent cu…

View Details
Posted 2025-09-01

Pediatrician Opening with Successful Practice West of Boston - Partnership

Enterprise Medical Recruiting
Massachusetts

Successful independent pediatric practice west of Boston is adding a Pediatrician to its growing team. Practice Details ~ Cohesive team of 10 Pediatricians with support from NPs and PAs ~1:1…

View Details
Posted 2025-08-06

Board Certified Behavior Analyst (BCBA) - Master Trainer, Boston

QBS, provider of Safety-Care
Boston, MA

Empower. Train. Transform. Are you a passionate Behavior Analyst looking to make a lasting impact? Do you thrive in dynamic training environments and enjoy sharing your expertise with professional…

View Details
Posted 2025-07-29

Info Governance and Privacy - Data Governance & Data Engineering Sr. Manager Save for Later Remove job

PwC
Boston, MA

At PwC, our people in cybersecurity focus on protecting organisations from cyber threats through advanced technologies and strategies. They work to identify vulnerabilities, develop secure systems,…

View Details
Posted 2025-08-22

Technician A (E-M)

MIT Lincoln Laboratory
Westford, MA

  The nation’s satellites perform important civil, scientific, and national defense functions such as navigation, communications, weather forecasting, astronomical observations, and surveillance. As…

View Details
Posted 2025-07-29

Software Engineer III

Pickle Robot Company
Cambridge, MA

About this role: Pickle is on the hunt for a dynamic and driven Software Engineer III to revolutionize the future of warehouse automation. You’ll design and develop algorithms that enable our robots…

View Details
Posted 2025-08-20