Data Warehouse Consultant

  • Lancaster, PA
  • Posted 2 hours ago | Updated 2 hours ago

Overview

Remote
On Site
Hybrid
Depends on Experience
Contract - W2

Skills

Data Warehouse
Business Intelligence
ADF
Extract
Transform
Load
SQL
Visual Basic
Microsoft Azure
Microsoft Power BI
Azure Data Factory

Job Details

Data Warehouse Consultant Location: Remote or on site- your choice!
Overview:
We re working with a well-established organization that s reengineering its data infrastructure to better support Power BI and overall business intelligence goals. The current setup involves a homegrown data-moving tool (possibly built in VB) and a SQL-based data warehouse designed by an independent consultant. The client now needs an experienced Data Warehouse consultant to step in, modernize the pipeline, and stand up new connections using Azure Data Factory (ADF).

Why This Data Warehouse Role Exists:
The previous consultant designed and implemented the original system, but the client has no internal visibility into the code or architecture. As they evolve, they need expert guidance to rebuild and expand the data pipeline, transition away from the legacy tool, and build out the next iteration of their warehouse. This is not a lift and shift it s a roll-up-your-sleeves, let s-build-it-better opportunity.

Scope of Work:

  • The Data Warehouse Consultant will reengineer the current data pipeline to replace a legacy data-moving tool

  • Stand up and manage new data connections using Azure Data Factory

  • Optimize and/or rebuild components of the existing SQL data warehouse

  • Help enable smooth downstream integration with Power BI

  • Provide recommendations and documentation for long-term maintainability

What They Need:

  • Proven professional expertise in Azure Data Factory (ADF)
  • Strong handle on SQL

  • Ability to reverse engineer a legacy system without direct access to code documentation

  • Experience working with Power BI data models is a plus

  • Comfortable working with ambiguity client knows what outcomes they need but is looking for a partner to help shape the path

Other Info:

  • This is a contract role. While not likely to convert to full-time, the company is maintaining investment in IT and has a BI Engineer headcount budgeted.

  • You'll be working alongside internal stakeholders who understand data endpoints and goals, but are looking to you for technical leadership.

Ready to apply for this Data Warehouse Consultant role?

Click the Apply button to attach your resume.

Not ready to apply yet?

Contact a technical recruiter at or for a confidential conversation about your career goals.

With decades of industry experience, JFC Global, the largest locally owned and operated niche recruiting company, has built well-established relationships with hiring managers and HR professionals in our area. JFC Global has received a 9.6 NPS rating from the professionals we work with and pride ourselves on operating with the highest ethics and integrity within the recruiting industry. We look forward to putting our local connections to work for you!

Sorry, JFC Global is unable to offer 1099, subcontracting or sponsorship.
Direct W2 only
EOE.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.