Senior Data Engineer with Datalake, Snowflake or Microsoft Fabric- ONSITE in Boston or Needham[...]

Yoh, A Day & Zimmermann Company; Boston (MA); Hybrid; USD 89,544 - 110,208; Full time

Benefits offered by this job

Medical, Prescription, Dental & Vision Benefits

401K Retirement Savings Plan

Certification and training opportunities

Job summary

A leading staffing firm is seeking a Senior Data Engineer to design and implement a cloud-based data lake and analytics platform. The ideal candidate will have over 10 years of experience, including expertise in SQL and familiarity with Snowflake and Microsoft Fabric. This hybrid role in Boston will require collaboration with finance stakeholders and hands-on development of data transformations and ingestion pipelines. Competitive compensation and benefits offered.

Qualifications

• 10+ years of experience in data engineering, analytics engineering, or enterprise data platform development.
• Expertise in advanced SQL, performance tuning, and complex analytical queries.
• Demonstrated experience implementing data lakes or cloud data platforms such as Snowflake or Microsoft Fabric.

Responsibilities

• Design and implement a cloud-based data lake and analytics platform for Finance and Administration.
• Develop and maintain data ingestion pipelines from multiple upstream systems.
• Perform hands-on development of data transformations, data models, and analytical datasets.

Skills

Hands-on Data Engineering

SQL

Data Lake Development

Cloud Technologies (AWS, Azure)

Business Intelligence Tools (Tableau, Power BI)

Tools

Snowflake

Microsoft Fabric

AWS

Azure Data Lake

Job description

Overview

Please contact Renu Goel
857-207-2676
[e-mail]

Please do not respond if you dont have MSFT Fabric is a must
Local to Boston only

Senior Data Engineer with Datalake, Snowflake or Microsoft Fabric, SQL - HYBRID ONSITE in Boston or Needham MA

Location: Boston or Needham MA

Keys to the Position

• 1. 10+ years working experience as a hands on Data Engineer
• 2. Must have experience building a data lake
• 3. Experience with Snowflake or MSFT Fabric is a must
• 4. Must be strong with SQL
• 5. Excellent communication and interpersonal skills are required as this is a client facing role supporting the business
• 6. Finance experience is a nice to have
• 7. Experience with AWS or Azure is a nice to have

About the Role

Seeking a highly experienced, hands-on technical data professional to design and implement a modern enterprise data lake and analytics platform for the Finance and Administration organization. This role will focus on building and delivering a consolidated data layer that integrates data from multiple systems and modernizes existing financial data analytics and reporting solutions. The current reporting ecosystem includes a range of Tableau dashboards and reporting solutions. The new data lake platform will provide a scalable, governed, and high-performance data foundation to support advanced analytics, standardized reporting, and self-service data access for downstream consuming teams. This role is ideal for a senior technologist who enjoys deep technical problem solving, hands-on development, and close collaboration with business partners, while contributing to architectural direction and best practices.

Key Responsibilities

• Design, build, and implement a cloud-based data lake and analytics platform supporting Finance and Administration use cases
• Partner closely with finance stakeholders to understand reporting requirements and translate them into technical solutions
• Develop and maintain data ingestion pipelines from multiple upstream systems, including finance, client services, and operational platforms
• Perform hands-on development of data transformations, data models, and analytical datasets using SQL and modern ELT patterns
• Build and optimize curated data layers to support reporting, analytics, and downstream consumption
• Modernize existing Tableau-based reporting solutions by re-platforming datasets and improving performance, scalability, and data consistency
• Implement data quality checks, data governance standards & compliance, and reconciliation processes to ensure accuracy and trust in financial data
• Troubleshoot and resolve complex data, performance, and pipeline issues across the data platform
• Contribute to platform standards, best practices, and reusable data patterns
• Collaborate with infrastructure, security, and architecture teams to ensure solutions meet governance and compliance requirements

Required Qualifications

• 10–15 years of experience in data engineering, analytics engineering, or enterprise data platform development
• Strong, hands-on expertise in advanced SQL (such as Oracle, MS SQL Server, PostgreSQL, or MySQL), including performance tuning and complex analytical queries
• Demonstrated experience implementing data lakes or cloud data platforms, such as:
  Microsoft Fabric
  Snowflake
  AWS (S3, Glue, Athena, Redshift, Lambda)
  Azure Data Lake, Synapse, or equivalent platforms
• Experience with AI technologies is a plus
• Experience working with Agile methodologies, CI/CD tools (Jenkins or equivalent), version control (Git) and Orchestration tools
• Experience operating in a DevOps environment with cloud technologies. Amazon Web Services is a plus.
• Experience building end-to-end data pipelines, including ingestion, transformation, and consumption layers
• Strong experience supporting business intelligence and analytics tools, such as Tableau, Power BI, or similar platforms
• Solid understanding of data modeling techniques (dimensional, normalized, and analytical models)
• Experience working with financial data domains (e.g., accounting, FP&A, budgeting, expense, headcount, or vendor data)
• Ability to independently implement solutions from requirements through production deployment

Compensation

• Estimated Min Rate: $65.00
• Estimated Max Rate: $80.00

What’s In It for You?

We welcome you to be a part of the largest and legendary global staffing companies to meet your career aspirations. Yoh’s network of client companies has been employing professionals like you for over 65 years in the U.S., UK and Canada. Join Yoh’s extensive talent community that will provide you with access to Yoh’s vast network of opportunities and gain access to this exclusive opportunity available to you. Benefit eligibility is in accordance with applicable laws and client requirements. Benefits include:

• Medical, Prescription, Dental & Vision Benefits (for employees working 20+ hours per week)
• Health Savings Account (HSA) (for employees working 20+ hours per week)
• Life & Disability Insurance (for employees working 20+ hours per week)
• MetLife Voluntary Benefits
• Employee Assistance Program (EAP)
• 401K Retirement Savings Plan
• Direct Deposit & weekly epayroll
• Referral Bonus Programs
• Certification and training opportunities

Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Visit https://www.yoh.com/applicants-with-disabilities to contact us if you are an individual with a disability and require accommodation in the application process.

For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

By applying and submitting your resume, you authorize Yoh to review and reformat your resume to meet Yoh’s hiring clients’ preferences. To learn more about Yoh’s privacy practices, please see our Candidate Privacy Notice: https://www.yoh.com/privacy-notice