Data Warehouse Architect(Teradata

US IT Solutions Inc; Lansing (MI); On-site; USD 90,000 - 120,000; Full time

Job summary

A premier IT solutions provider located in Michigan is seeking a Data Warehouse Developer to design and support data warehousing in a Teradata environment. The ideal candidate will have over 5 years of experience with Teradata physical modeling and SQL, possessing strong leadership and problem resolution skills. This role offers the chance to define technical architecture and develop strategies for data warehouse systems, ensuring alignment with organizational goals.

Qualifications

• 5+ years of experience in Teradata database development and management.
• Strong understanding of end-to-end data warehouse implementation.
• Excellent communication and presentation skills.

Responsibilities

• Design and support data warehousing in a Teradata environment.
• Plan database architecture and oversee data integration.
• Monitor data warehousing industry trends to guide strategy.

Skills

Teradata physical modeling

Data warehousing design

SQL proficiency

Problem resolution

Leadership skills

Tools

ETL tools

RDBMS

Data profiling software

Job description

We are from US IT Solutions, an ISO Certified, E-Verify, WMBE Certified organization established in 2005 in CA. O ur company is serving various State, Local and County Departments for over 10 years. USITSOL has been helping clients innovate across all phases of the application lifecycle for over a decade. Some of our prestigious clients are State of CA, State of OR, State of FL, State of NC, State of GA, State of CO, State of VA, State of AR, State of MI, State of OH, State of IL, State of MO, State of MS, California State University, Sacramento Area Sanitation Department, SMUD, Sound Transit, LA Superior Courts, District of Columbia, UMAS, University of Central Florida and Hennepin County and many more.

Job Description

Short Description:-

Designs, implements and supports data warehousing in a Teradata database environment. The position has responsibility for data base planning, development, administration and maintenance/ETL of the Client’s data warehouse.

Complete Description:

Years of Experience:

5 or more years of Teradata physical modeling and indexing techniques.

Qualifications

• Job Description: Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.
• 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.
• Responsible for proper selection of appropriate hardware, software, tools and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting and analytic tools.
• Defining and documenting the technical architecture of the data warehouse, including the physical components and their functionality.
• Setting or enforcing standards and overall architecture for data warehouse systems.
• Monitoring the data warehousing industry and assisting in establishing the organization's data warehousing strategy and section of strategic warehousing tools and techniques.
• Ensuring compatibility of the different components of the DW architecture and ensuring alignment with broader IT strategies and goals.
• Ability to educate the project teams on the standards and architecture of each component of the data warehouse architecture.
• Very strong written and oral communication skills, including some presentation skills.

Additional Information

Applicant must be a Delaware Licensed plumber.