
eSolutionsFirst, LLC
Hybrid in Philadelphia, Pennsylvania • Today
Easy Apply
Contract
Depends on Experience
25 results (2 new)

eSolutionsFirst, LLC
Hybrid in Philadelphia, Pennsylvania • Today
Easy Apply
Contract
Depends on Experience






Senior Data Engineer- SQL Server to Databricks Migration
Job Type: Contract (6-12 Months)- Possible extension
Location: Philadelphia, PA (Hybrid – Flexible Work Model)
Job description:
Job summary
We are seeking a senior data engineer with deep Microsoft SQL Server experience to assess and convert a legacy warehouse to Azure Databricks.
You will read complex T-SQL stored procedures and SSIS packages, document the business rules they contain, rebuild them as Databricks pipelines, and reconcile the results before the legacy platform is retired.
Key responsibilities
• Assess T-SQL stored procedures, SSIS packages and scheduled jobs for complexity, dependencies, and embedded business rules.
• Recommend, for each object, whether to retire, convert or redesign it.
• Convert legacy logic to Databricks SQL and PySpark pipelines using agreed patterns and conversion tooling.
• Review and correct automatically converted code.
• Build and run reconciliation between SQL Server and Databricks and resolve differences with business analysts.
• Migrate job schedules and dependencies to Databricks workflows.
• Support cutover and the evidence needed to decommission each legacy component.
• Document data flows, mappings and design decisions in the client's repositories.
Required qualifications
• 8+ years in data engineering or database development, including 5+ years of hands-on T-SQL and SSIS.
• 2+ years building pipelines on Databricks, or an equivalent Spark-based lakehouse platform, with Delta Lake.
• At least one completed migration from SQL Server or another warehouse to a cloud data platform.
• Strong SQL performance tuning and the ability to reverse-engineer undocumented code.
• Experience with data reconciliation and testing at scale.
• Git-based development with pull requests and automated deployment.
Preferred qualifications
• Databricks Lakeflow pipelines and jobs, and Unity Catalog.
• Code-conversion tools such as Databricks Lakebridge.
• Databricks Data Engineer Associate or Professional certification.
• Financial services or wealth management data.
• Experience with enterprise schedulers such as SQL Agent or ActiveBatch.
eSolutionsFirst is a premier technology and talent solutions partner providing best-in-class IT solutions and staffing services that empower our clients to be market leaders.
We Believe in Consistent, Quality & Transparent Hiring Process.
As a pioneer in talent management since we are proud of bridging the gap between diverse aspiring talent and various visionary organizations. Our people-centric Workforce portfolio spans across to help businesses overcome any talent management challenge. Our experience in serving industry leaders and Fortune500 companies gear us to empower enterprises of any size and industry with our dynamic staffing solutions.
We Deliver the Promise of Modern Technology.
Our leading-edge capabilities in Cloud, Data, and Security have been fortifying businesses with accelerated digital transformation over years. Our proven methodologies and pragmatic approaches revolutionize IT environments across diverse industries. Through our advisory and end-to-end digital transformation solutions, we encourage companies to establish a “Cloud-First Data-Driven” culture.
• Over 1,000 man-years of services in IT services.
• Over 100+ software development and management engagements.
• Over 17+ years of advisory services and multiple commercial-grade software products developed.


To see how well you match this job, please log in or create an account.
Once logged in, be sure to complete your profile to get the most accurate match score.
Hybrid in Philadelphia, Pennsylvania
•
Today
Business Analyst Finance Job Type: Contract (6-12 Months)- Possible extension Location: Philadelphia, PA (Hybrid Flexible Work Model) Job description: Program: Consolidation of five legacy data and BI platforms onto Azure Databricks and Power BI Job summary: We are seeking a senior business analyst to represent finance and wealth management requirements on a program that moves a legacy reporting and data warehouse estate to Azure Databricks and Power BI. You will work with finance, operation
Easy Apply
Contract
Depends on Experience