Yoh, A Day & Zimmermann Company · 23 hours ago
Senior Data Engineer with Datalake, Snowflake or Microsoft Fabric, SQL- HYBRID ONSITE
Yoh, A Day & Zimmermann Company is seeking a highly experienced Senior Data Engineer 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 to modernize existing financial data analytics and reporting solutions.
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
Qualification
Required
10+ years working experience as a hands on Data Engineer
Must have experience building a data lake
Experience with Snowflake or MSFT Fabric is a must
Must be strong with SQL
Excellent communication and interpersonal skills are required as this is a client facing role supporting the business
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 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
Preferred
Finance experience is a nice to have
Experience with AWS or Azure is a nice to have
Experience with AI technologies is a plus
Benefits
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
Company
Yoh, A Day & Zimmermann Company
At Yoh, we focus on helping you precisely navigate and fulfill your talent demands.
H1B Sponsorship
Yoh, A Day & Zimmermann Company has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (57)
2024 (28)
2023 (27)
2022 (25)
2021 (28)
2020 (27)
Funding
Current Stage
Late StageLeadership Team
Recent News
Philadelphia Business Journal
2025-01-11
Company data provided by crunchbase