Data Warehouse Architect 3

TekWissen LLC

Lansing, MI

JOB DETAILS
SALARY
$81.48–$81.48
SKILLS
Administrative Skills, Agriculture, Bash Scripting, Business Solutions, Cloud Computing, Data Mining, Data Recovery, Data Warehousing, Database Extract Transform and Load (ETL), Decision Support, Department of Health and Human Services, Disaster Recovery, Diversity, Ecosystems, Environmental Health, Federal Government, Healthcare, Identify Issues, Law Enforcement, Linux Operating System, Medicaid, Microsoft Windows Azure, NCR Teradata, Natural Resources, Operating Systems, Performance Analysis, Performance Tuning/Optimization, Perl Programming Language, Problem Solving Skills, Public Safety, Python Programming/Scripting Language, Release Management/Engineering, Resource Management, Rural Development, Security Auditing, Software Administration, Software Patches, Statistics, Strategic Planning, Systems Administration/Management, Technical Support, Testing, U.S. National Institute of Standards and Technology (NIST), Unix Operating Systems, Workforce Management
LOCATION
Lansing, MI
POSTED
Today
Overview:
TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients worldwide. The below Client runs through fifteen executive departments which carry out the daytoday administration of the federal government. Popular departments like Agriculture and Rural Development, Civil Rights, Environment, Health and Human Services, Natural Resources, Secretary of State. This Client has opportunities in a number of career pathways, including, but not limited to, business and administrative support, education and human services, IT and computers, medical and healthcare, natural resources, law enforcement and public safety, skilled trades and more. With positions in over 18 state departments, your perfect career fit is waiting for you at the client. This client is an Equal Opportunity Employer.
Job Title:Data Warehouse Architect 3
Location: Lansing, MI 48917
Duration: 12 Months
Job Type:Hybrid
Work Type: Temporary Assignment
Shift: 8.00AM - 4:30PM
Job Description:
  • 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.
  • This position defines the technical planning, implementation plan, and delivery of the EDW platform services and supporting technologies to meet the client'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.
The state maintains an enterprise data warehouse built on the Teradata ecosystem. Below is a list of services; however, this list is not exhaustive.
8+ years required for the following:
  • 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.
TekWissen Group is an equal opportunity employer supporting workforce diversity.

About the Company

T

TekWissen LLC

WE THE TEKWISSEN PEOPLE

TekWissen offers you a broader portfolio of services, industry-leading solutions, and the meaningful innovations that give you greater flexibility and speed to respond to market dynamics, reduced costs and risk to improve enterprise performance, and increased productivity to enable growth.

To keep pace with global market demands, TekWissen keeps its finger on the pulse of change. Our organized approach to guiding a project from its inception to closure. Managing projects is becoming more and more important as we enter the digital era. To cope with the pace that this transition demands, a method is required to manage projects so they can yield quality work, while incorporating efficient use of time and resources.

Project involves identifying which quality standards are relevant to the project and determining how to satisfy them.

It is important to perform quality planning during the Planning Process and should be done alongside the other project planning processes because changes in the quality will likely require changes in the other planning processes, or the desired product quality may require a detailed risk analysis of an identified problem. It is important to remember that quality should be planned, designed, then built in, not added on after the fact.

Capabilities and accomplishments in one TekWissen business enhance the opportunity for success in the others. Put simply, TekWissen's unique combination of attributes promotes success.



COMPANY SIZE
100 to 499 employees
INDUSTRY
Computer/IT Services
FOUNDED
2009
WEBSITE
http://www.tekwissen.com/