Data Warehouse Architect
- 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.
- 5+ years of experience in data warehousing, ETL development, or database engineering.
- Strong expertise with Microsoft SQL Server (2012, 2022) and related technologies.
- Proven experience building (not just maintaining) an enterprise data warehouse.
- Solid understanding of data modeling, data integration, and ETL best practices.
- Experience working with Snowflake or other cloud-based data warehouse platforms.
- Ability to manage large datasets and optimize query performance.
- Strong problem-solving skills and a “roll-up-your-sleeves” attitude—this is a builder/doer role, not an architecture-only position.
- Excellent communication and collaboration skills.
#LI-JH3
Recommended Jobs
Foreman
Hourly Salary Range: 22.00-35.00 Apex Storage provides a full service, cross-solution approach for material handling industry customers, offering expertise in warehouse and industrial facility d…
CDL-A Flatbed Truck Driver | $5,000 Sign-On Bonus | Home Weekends
CDL-A Flatbed Truck Driver | $5,000 Sign-On Bonus | Home Weekends | 27% Load Pay Pay & Bonuses Earn 27% of load pay (avg $1,400-$1,600/week gross ) $5,000 Sign-On Bonus! $1,50…
Regional scheduler
We are currently seeking a Regional Scheduler for our Transportation Group in Chicago, IL. As a fourth-generation, family-owned business, Walsh recruits individuals who are seeking a small com…
A&P Mechanic
Job Description Job Description Aircraft Maintenance Technician | **If interested, please apply or call Danielle at 3 1 6 4 4 8 4 4 8 9** Join our team as an Aircraft Maintenance Technician whe…
Assistant Boutique Manager
A. Lange & Söhne seeks an Assistant Boutique Manager in Chicago, Illinois to act as a brand ambassador and support boutique operations. The role involves achieving sales targets, managing a team, and …
Explore Urbana: Your Adventure Awaits in Nursing!
Registered Nurse - Medical Surgical - Travel - (MS RN) Embark on a rewarding travel nursing journey as a Registered Nurse in Medical Surgical at Carle Foundation Hospital in Urbana, renowned for its …
Manager consulting services
Job Description RevCycle Patient Access Manager, Consulting Services (Oracle Health - Federal) Overview As a RevCycle Patient Access Manager within Oracle Health Consulting Services, y…
Systems Programmer Analyst
About North Park Founded in 1891, North Park University is a Christian university affiliated with the Evangelical Covenant Church of over 3,200 students from around the country and the world. Nor…
Founding Private Client Tax Analyst HNWI
Our Client Is a startup based in downtown San Francisco building the next gen tax forecasting engine for high-net-worth individuals , designed to give users visibility into their tax obligatio…
School counselor or social worker
Relationships: Reports to the Principal. Collaborates with Student Service Department Members, Dean of Students, Director of Student Life, AP of Curriculum and Instruction, Division Chairs, Depar…