Senior Data Engineer
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.
Recommended Jobs
Front Desk Agent
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…
RN - Medical Specialties/Oncology
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 …
Future Openings
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…
Mental Health Therapist
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…
Inventory Assistant Manager
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…
Pediatrician Opening with Successful Practice West of Boston - Partnership
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…
Board Certified Behavior Analyst (BCBA) - Master Trainer, Boston
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…
Info Governance and Privacy - Data Governance & Data Engineering Sr. Manager Save for Later Remove job
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,…
Technician A (E-M)
The nation’s satellites perform important civil, scientific, and national defense functions such as navigation, communications, weather forecasting, astronomical observations, and surveillance. As…
Software Engineer III
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…