Data Warehouse Consultant

JFC Staffing Companies; Lancaster (Lancaster County); Remote; USD 80,000 - 110,000; Full time

Job summary

A leading company is seeking a Data Warehouse Consultant to modernize their data infrastructure. This role involves reengineering data pipelines, optimizing SQL warehouses, and ensuring integration with Power BI. The ideal candidate will have strong expertise in Azure Data Factory and SQL, along with the ability to navigate ambiguity in project requirements.

Qualifications

• Proven expertise in Azure Data Factory (ADF).
• Strong SQL skills.
• Ability to reverse engineer legacy systems.

Responsibilities

• Reengineer current data pipeline to replace legacy tools.
• Manage new data connections using Azure Data Factory.
• Optimize existing SQL data warehouse components.

Skills

Azure Data Factory

SQL

Data modeling

Technical leadership

Job description

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 onSQL

• 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 JD Edwards Specialist position?

Click the Apply button to attach your resume.

Not ready to apply yet?

Contact a technical recruiter at [e-mail] or 717-761-8095 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, C2C, 1099, subcontracting or sponsorship.
Direct W2 only
EOE.