Data Warehouse Consultant

1 week 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 and Production Team #readytowork

    7 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

    4 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,...

  • Warehouse Associate

    7 days ago

    Lancaster, PA, United States United Electric Supply Full time

    Warehouse Associate / Backup Delivery Driver Who We Are United Electric Supply Co. Inc. is a nationally recognized, 100% employee-owned company that is a large multi-regional supplier of electrical products and advanced services for the construction and industrial markets. United Electric offers a full range of electrical products and services with...

  • Lead Data Architect

    2 weeks ago

    Lancaster, PA, United States Fulton Bank Full time

    Value Proposition Our values define us and our culture inspires us to change lives for the better. Our employees are the heart and soul of our company, and every success we experience begins with them. Together we are committed to making a positive impact in our local communities. We champion a culture of continuous learning, work-life integration, and...

  • Data Scientist

    6 days ago

    Lancaster, PA, United States Fulton Bank Full time

    Value Proposition Our values define us and our culture inspires us to change lives for the better. Our employees are the heart and soul of our company, and every success we experience begins with them. Together we are committed to making a positive impact in our local communities. We champion a culture of continuous learning, work-life integration, and...

  • Data Scientist

    4 days ago

    Lancaster, PA, United States Fulton Bank Full time

    Value Proposition Our values define us and our culture inspires us to change lives for the better. Our employees are the heart and soul of our company, and every success we experience begins with them. Together we are committed to making a positive impact in our local communities. We champion a culture of continuous learning, work-life integration, and...

  • Data Scientist

    2 days ago

    Lancaster, PA, United States Fulton Bank Full time

    Value Proposition Our values define us and our culture inspires us to change lives for the better. Our employees are the heart and soul of our company, and every success we experience begins with them. Together we are committed to making a positive impact in our local communities. We champion a culture of continuous learning, work-life integration, and...

  • Solar Sales Consultant

    1 week ago

    Lancaster, PA, United States Lumina Solar Full time

    About Lumina: We're committed to working towards building a better future through sustainable energy. As the top-rated solar company in the Mid-Atlantic and one of the fastest-growing in the industry, we provide reliable solutions that save customers money and give them control over their energy needs. By joining our team, you'll play a key role in...

  • Solar Sales Consultant

    7 days ago

    Lancaster, PA, United States Lumina Solar Full time

    About Lumina: We're committed to working towards building a better future through sustainable energy. As the top-rated solar company in the Mid-Atlantic and one of the fastest-growing in the industry, we provide reliable solutions that save customers money and give them control over their energy needs. By joining our team, you'll play a key role in...

  • Leasing Consultant

    7 days ago

    Lancaster, PA, United States Campus Apartments Full time

    Overview Enthusiastic, outgoing leasing professional wanted! The Campus team is filled with passionate and enthusiastic people! Since 1958, we have been singularly focused on providing superb housing for college students across the country and our team is the reason for our success and for our ability to grow over the long-term. If you’re someone who loves...