Data Warehouse Architect

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. is a software development Company. Our passion is delivering technology strategies & digital solutions that assist our clients with building competitive , innovative and successful companies.

Job Description

Designs, implements and supports data warehousing. Implements business rules via stored procedures, middleware, or other technologies. Defines user interfaces and functional specifications. Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse. Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning. Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models. Development experience in implementation of data warehousing utilizing RDBMS. Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies. Expertise in SQL and proficiency in database tuning techniques. Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments. Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment.

Additional Information

All your information will be kept confidential according to EEO guidelines.