Data Warehouse Architect

Job Title : Data Warehouse Consultant (Contract)

Pay Range : $75hr - $95hr

Benefits : LaSalle Network contractors have the opportunity to enroll in benefits including medical, dental and vision insurance.

Location : Onsite 3 days per week - Elk Grove Village, IL

Type : 6-Month Contract

Schedule : Hybrid (3 days onsite / 2 remote)

Start Date : ASAP

Overview :

We are seeking a hands-on Data Warehouse Consultant to design and build an Enterprise Data Warehouse (EDW) leveraging the Microsoft technology stack. This is a critical, high-impact project to establish a centralized data environment supporting enterprise reporting and analytics. The ideal candidate will be a senior-level developer who thrives in a build-focused, execution-oriented role-not a theoretical architect.

Responsibilities :

• Design, develop, and implement a scalable Enterprise Data Warehouse using Microsoft SQL Server technologies.
• Work directly with existing infrastructure, including SQL Server 2012 and SQL Server 2022 environments (3 production servers, 1 development server).
• Integrate and optimize data flows from multiple sources to support enterprise reporting.
• Build and maintain ETL processes, data pipelines, and data models.
• Collaborate with stakeholders to standardize reporting and develop 6-10 recurring reports that leverage the new EDW.
• Support backend database processes and manage large datasets to ensure data accuracy, integrity, and performance.
• Utilize Snowflake as part of the data architecture (experience with Snowflake is strongly preferred).
• Work closely with internal teams to ensure seamless integration between data sources, warehouse, and reporting layers.

Qualifications :

#LI-JH3

LaSalle Network is an Equal Opportunity Employer m / f / d / v.

LaSalle Network is the leading provider of direct hire and temporary staffing services. For over two decades, LaSalle has helped organizations hire faster and connect top talent with opportunities, from entry-level positions to the C-suite. With units specializing in Accounting and Finance, Administrative, Engineering, Marketing, Technology, Supply Chain, Revenue Cycle, Call Center, Human Resources and Executive Search, LaSalle offers staffing and recruiting solutions to companies of all sizes and across all industries.

LaSalle Network is the premier staffing and recruiting firm, earning over 100 culture, revenue and industry-based awards from major publications and having its company experts regularly contribute insights on retention strategies, hiring trends, hiring challenges, and more to national news outlets. LaSalle Network offers temporary Field Employees benefit plans including medical, dental and vision coverage. Family Medical Leave, Worker's Compensation, Paid Leave and Sick Leave are also provided. View a full list of our benefits here

All assignments are at-will and their duration is subject to change.