Data Warehouse Architect

BEEU Infotech Limited; Okemos (MI); On-site; USD 105,000 - 130,000; Full time

Job summary

BEEU Infotech Limited is seeking a Data Warehouse Architect 3 in Okemos, Michigan. The role involves managing and optimizing an enterprise data warehouse built on Teradata technology, ensuring high performance for analytics and data mining across various departments.

The ideal candidate will have over 8 years of experience in data warehousing, particularly with Teradata, and be adept in scripting languages like BASH, Perl, and Python. Responsibilities include platform administration, vendor communication, and providing technical guidance.

Qualifications

• 8+ years of experience in data warehousing and database management.
• Extensive knowledge of Teradata ecosystem and its management.
• Experience with vendor upgrades and security plans.

Responsibilities

• Serve as platform administrator for the EDW, ensuring performance and security.
• Coordinate long-term EDW strategies with users and management.
• Provide technical expertise to department DBAs across the enterprise.

Skills

Teradata database

BASH scripting

Perl scripting

Python scripting

Unix/Linux knowledge

Cloud computing fundamentals

Performance tuning

ETL processes

Tools

Teradata Tools and Utilities

MS Azure

Job description

Department of Technology Management & Budget (DTMB) / Office of the Chief Technology Officer OCTO

Data Warehouse Architect 3 – Job Description

The state maintains an enterprise data warehouse built on the Teradata ecosystem. Below is a list of services; however, this list is not exhaustive.

Experience Requirements (8+ years)

• Teradata database
• Upgrades, provisioning, software maintenance, scripting – BASH, Perl, Python, Glink
• Teradata ecosystem health monitoring
• Teradata node management
• Teradata Viewpoint administration
• Teradata Tools and Utilities (TTU)
• PSIM (Platform Service Intelligent Monitoring) administration
• Teradata vendor upgrades
• Teradata workload management
• Teradata backup & recovery
• Performance tuning and resource optimization
• Extract Transform Load (ETL)
• Unix/Linux knowledge
• Cloud computing fundamentals, resource allocation, networking, preferably MS Azure
• Statistics
• Audits & security plans
• Federal requirements – NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc.

The Enterprise Data Warehouse (EDW) service offered by DTMB provides customers with the ability to conduct high performance analytics, data mining activities, and enhanced decision support capabilities. Currently, the EDW service employs Teradata technology.

This position will serve as a platform administrator for the EDW, consisting of 3 distinct platforms (Production, Development/Disaster Recovery, and Test). The EDW provides enterprise data warehousing services to executive branch department as well as the State Court Administrator Offices statewide. A total of 7 departments are supported, with a user base of over 10,000 and 40 Terabytes of data.

This position researches and coordinates long term EDW strategies with all current and potential users, DTMB management and vendor personnel. The position defines the technical planning, implementation plan, and delivery of the EDW platform services and supporting technologies to meet the State of Michigan’s business requirements and objectives. This includes vendor communication, trouble reporting, escalated troubleshooting, and release/patch management.

This position is responsible for providing operating system guidance along with EDW security expertise for the systems as well as advising the Agencies on disaster recovery planning strategies related to the EDW and their business applications. The position is also responsible for platform performance monitoring and resolving performance issues. This position provides direct technical expertise to department DBAs and specialists across the enterprise.