Strategic Data Warehouse Architect for Scalable BI

Ask IT consulting; Lansing (MI); On-site; USD 90,000 - 120,000; Full time

Job summary

Ask ITC Inc. designs, implements and supports data warehousing solutions for enterprise clients. The role focuses on end-to-end data warehouse architecture, ETL workflows, SQL tuning and data modeling across relational and dimensional models.

The candidate will verify data accuracy, maintain the warehouse environment and contribute to future architectural directions for BI reporting. Strong leadership and collaboration with cross-functional teams are required.

Qualifications

• Experience with data warehouse design and data modeling (relational and dimensional).
• Strong knowledge of SQL and performance tuning techniques.
• Ability to lead a multi-person implementation team and resolve issues.

Responsibilities

• Designs, implements and supports data warehousing solutions.
• Defines user interfaces and functional specifications for warehouse systems.
• Verifies data accuracy and maintains the data warehouse.
• Develops ETL processes and data integration workflows; tunes performance.

Skills

Data warehousing

SQL

ETL

Leadership

Tools

RDBMS

Job description

Ask ITC Inc. designs, implements and supports data warehousing solutions for enterprise clients. The role focuses on end-to-end data warehouse architecture, ETL workflows, SQL tuning and data modeling across relational and dimensional models.

The candidate will verify data accuracy, maintain the warehouse environment and contribute to future architectural directions for BI reporting. Strong leadership and collaboration with cross-functional teams are required.