Data Warehouse Consultant

6 days ago

Lancaster, PA, United States JFC Staffing Full time
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 JD Edwards Specialist position? Click the Apply button to attach your resume.
Not ready to apply yet?
Contact a technical recruiter at ITjobs@jfcglobal.com 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.

  • Warehouse Associate

    1 day ago

    Lancaster, PA, United States Quality Bicycle Products Full time

    Warehouse Associate - Weekdays Unlock Your Potential with a Team That Values Responsibility and Collaboration! Ready to take your skills to the next level? At Quality Bicycle Products (QBP), we combine autonomous self-driving robots with a mission-driven culture to create a workplace that values your health, happiness, and growth. We're looking for...

  • Warehouse Associate

    23 hours ago

    Lancaster, PA, United States Quality Bicycle Products Full time

    Warehouse Associate - Weekdays Unlock Your Potential with a Team That Values Responsibility and Collaboration! Ready to take your skills to the next level? At Quality Bicycle Products (QBP), we combine autonomous self-driving robots with a mission-driven culture to create a workplace that values your health, happiness, and growth. We're looking for...

  • Warehouse Associate

    24 hours ago

    Lancaster, PA, United States Quality Bicycle Products Full time

    Warehouse Associate - Weekdays Unlock Your Potential with a Team That Values Responsibility and Collaboration! Ready to take your skills to the next level? At Quality Bicycle Products (QBP), we combine autonomous self-driving robots with a mission-driven culture to create a workplace that values your health, happiness, and growth. We're looking for...

  • Warehouse Associate

    1 day ago

    Lancaster, PA, United States Quality Bicycle Products Full time

    Warehouse Associate - Weekdays Unlock Your Potential with a Team That Values Responsibility and Collaboration! Ready to take your skills to the next level? At Quality Bicycle Products (QBP), we combine autonomous self-driving robots with a mission-driven culture to create a workplace that values your health, happiness, and growth. We're looking for...

  • Warehouse Associate

    1 day ago

    Lancaster, PA, United States Quality Bicycle Products Full time

    Warehouse Associate - Weekdays Unlock Your Potential with a Team That Values Responsibility and Collaboration! Ready to take your skills to the next level? At Quality Bicycle Products (QBP), we combine autonomous self-driving robots with a mission-driven culture to create a workplace that values your health, happiness, and growth. We're looking for...

  • Warehouse Associate

    1 day ago

    Lancaster, PA, United States Quality Bicycle Products Full time

    Warehouse Associate - Weekdays Unlock Your Potential with a Team That Values Responsibility and Collaboration! Ready to take your skills to the next level? At Quality Bicycle Products (QBP), we combine autonomous self-driving robots with a mission-driven culture to create a workplace that values your health, happiness, and growth. We're looking for...

  • Warehouse Associate

    1 day ago

    Lancaster, PA, United States Quality Bicycle Products Full time

    Warehouse Associate - Weekdays Unlock Your Potential with a Team That Values Responsibility and Collaboration! Ready to take your skills to the next level? At Quality Bicycle Products (QBP), we combine autonomous self-driving robots with a mission-driven culture to create a workplace that values your health, happiness, and growth. We're looking for...

  • Warehouse and Production Team #readytowork

    4 days ago

    Lancaster, PA, United States PeopleShare by PROMAN Full time

    Are you #readytowork ??? PeopleShare Lancaster is here to help! We are HIRING IMMEDIATELY for Team Member Warehouse, Assembly, General Labor, and Production jobs in the Lancaster, PA area - all positions and all shifts: 1st Shift, 2nd Shift, and 3rd Shift, paying $650-$1100+ weekly, $17 - $28+ per hour depending on shift and skillset! Openings are limited,...

  • Warehouse and Production Team #readytowork

    2 weeks ago

    Lancaster, PA, United States PeopleShare by PROMAN Full time

    Are you #readytowork ??? PeopleShare Lancaster is here to help! We are HIRING IMMEDIATELY for Team Member Warehouse, Assembly, General Labor, and Production jobs in the Lancaster, PA area - all positions and all shifts: 1st Shift, 2nd Shift, and 3rd Shift, paying $650-$1100+ weekly, $17 - $28+ per hour depending on shift and skillset! Openings are limited,...

  • Warehouse and Production Team #readytowork

    8 hours ago

    Lancaster, PA, United States PeopleShare by PROMAN Full time

    Are you #readytowork ??? PeopleShare Lancaster is here to help! We are HIRING IMMEDIATELY for Team Member Warehouse, Assembly, General Labor, and Production jobs in the Lancaster, PA area - all positions and all shifts: 1st Shift, 2nd Shift, and 3rd Shift, paying $650-$1100+ weekly, $17 - $28+ per hour depending on shift and skillset! Openings are limited,...