Data Warehouse Architect

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 our 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 and candidates should meet all requirements. 8+ years required for the following: Teradata databaseUpgrades, provisioning, software maintenance, scripting - BASH, Perl, Python, GlinkTeradata ecosystem health monitoringTeradata node managementTeradata Viewpoint administrationTeradata Tools and Utilities (TTU)PSIM (Platform Service Intelligent Monitoring) administrationTeradata vendor upgradesTeradata workload managementTeradata backup & recoveryPerformance tuning and resource optimizationExtract Transform Load (ETL)Unix/Linux knowledgeCloud computing fundamentals, resource allocation, networking, preferably MS Azure StatisticsAudits & security plansFederal requirements - NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc. Additional Info At FastTek Global, Our Purpose is Our People and Our Planet . We come to work each day and are reminded we are helping people find their success stories . Also, Doing the right thing is our mantra . We act responsibly, give back to the communities we serve and have a little fun along the way. We have been doing this with pride, dedication and plain, old-fashioned hard work for 24 years ! FastTek Global is a financially strong, privately held company that is 100% consultant and client focused . We've differentiated ourselves by being fast, flexible, creative and honest . Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things and we do them for Fortune 10, Fortune 500, and technology start-up companies. Benefits Our benefits are second to none and thanks to our flexible benefit options you can choose the benefits you need or want, options include: Medical and Dental (FastTek pays majority of the medical program)VisionPersonal Time Off (PTO) ProgramLong Term Disability (100% paid)Life Insurance (100% paid)401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match Plus, we have a lucrative employee referral program and an employee recognition culture. FastTek Global was named one of the Top Work Places in Michigan by the Detroit Free Press in 2013, 2014, 2015, 2016, 2017, 2018, 2019 , 2020, 2021, 2022, and 2023! To view all of our open positions go to: https://www.fasttek.com/fastswitch/findwork Follow us on Twitter: https://twitter.com/fasttekglobal Follow us on Instagram: https://www.instagram.com/fasttekglobal Find us on LinkedIn: https://www.linkedin.com/company/fasttek You can become a fan of FastTek on Facebook: https://www.facebook.com/fasttekglobal/ AI & Hiring Disclosure We use AI tools to support parts of our hiring process, such as reviewing applications and identifying potential matches. These tools are designed to promote efficiency, consistency, and fairness, and they are always used under human oversight. All personal data collected is used solely for recruitment purposes, and you have the right to know, access, or request deletion of your data at any time, subject to legal limits. If AI will be used in a video interview, you'll be informed in advance and asked for your consent, with the option to opt out. Our tools are regularly reviewed to detect potential bias and to ensure compliance with all applicable laws and our commitment to inclusive hiring. To learn more or exercise your rights, please contact us at info@fasttek.com.