Technical Lead - Data Warehouse & Data Integration

Your Role...

Overall Purpose and Main Objectives :

The Technical Lead for Data Warehouse & Data Integration, will be expected to take ownership of delivery execution and modernization across our Data Warehouse (DW) and Reporting platforms. This role is ideal for someone who is not only a strong technical implementer but also a delivery-focused leader-ready to drive change, build clean and scalable systems, and lead by example. The Technical Lead for Data Warehouse & Data Integration, will be at the center of our data engineering transformation, leading a globally distributed team, working closely with business and technical stakeholders, and helping us evolve from legacy tools toward a modern, cloud-enabled data stack. This is a hands-on leadership role that will help shape the future of Blick's data capabilities. Helping to modernize our data pipelines and architecture, improve our ETL approaches, and deliver accurate, high-quality data to business users across the organization. From operational reports to strategic dashboards, the work will directly influence decision-making across merchandising, marketing, supply chain, and more.

Responsibilities :

Data Engineering & Leadership :

• Lead and guide engineers (primarily offshore) responsible for ETL development, data pipelines, and data warehouse loads.
• Build and maintain workflows for data ingestion, cleansing, transformation, and transfer using tools like SSIS, Python, ADF, Fabric.
• Support both legacy systems (on-prem SQL Server, SSRS) and modern platforms (Redshift, MS Fabric, Power BI), with a focus on enabling transition to Azure-based infrastructure.
• Be highly hands-on-capable of coding, debugging, reviewing, and delivering alongside your team.

Delivery Ownership :

Data Quality, Cleansing, and Architecture :

Cross Functional Collaboration :

Modernization & Innovation :

Skills / Qualifications :

SQL (T-SQL, PL / SQL), and Python

Experience with modern data platforms like Redshift, Fabric, BigQuery, or Databricks.

Pay Rate :

The pay range below is provided in compliance with state / city specific laws. This pay range applies to this location. Pay ranges may be different in other locations.

Benefits Include :

Who we are...

Founded in 1911, Blick Art Materials is in its third generation of family ownership, and is the largest and oldest provider of art supplies in the United States.

Our Mission...

At Blick Art Materials, our family owners and dedicated staff support the Visual Art Community by providing the widest selection of art supplies at the lowest prices. With extraordinary service and integrity, we strive to provide artists, educators, students, and our employees with the tools, assistance, and training they need to grow, innovate, and reach their creative potential.