Data Warehouse Architect

About the role

The state maintains an enterprise data warehouse built on the Teradata ecosystem. This position serves as a platform administrator for the EDW, managing three distinct platforms (Production, Development/Disaster Recovery, and Test).

Responsibilities

• Research and coordinate long-term EDW strategies with all current and potential users, management, and vendor personnel.
• Define technical planning, implementation plans, and delivery of EDW platform services and supporting technologies to meet business requirements and objectives.
• Communicate with vendors, report and troubleshoot issues, manage releases and patches.
• Provide operating system guidance and EDW security expertise for the systems, advise agencies on disaster recovery planning strategies related to the EDW and their business applications.
• Resolve performance issues and provide direct technical expertise to department DBAs and specialists across the enterprise.

Requirements

• 8+ years of experience with Teradata database upgrades, provisioning, software maintenance, scripting (BASH, Perl, Python, Glink), and Teradata ecosystem health monitoring.
• Experience with Teradata node management, Viewpoint administration, TTU, PSIM administration, vendor upgrades, workload management, backup & recovery, performance tuning, and resource optimization.
• Unix/Linux knowledge, cloud computing fundamentals, resource allocation, networking, preferably MS Azure.
• Knowledge of statistics audits and security plans, federal requirements such as NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc.

Qualifications

• Proven experience in managing and maintaining large-scale data warehouses.
• Strong understanding of data warehousing concepts and practices.
• Excellent problem-solving skills and the ability to work independently and as part of a team.
• Ability to communicate effectively with various stakeholders, including technical and non-technical personnel.
• Proficiency in SQL and other relevant database management tools.

Skills

• Teradata database administration and management.
• Scripting languages (BASH, Perl, Python, Glink).
• Cloud computing and resource management.
• Data warehousing and analytics.
• Performance tuning and resource optimization.
• Unix/Linux operating systems.
• Statistical auditing and security planning.
• Federal regulations compliance (NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc.).

Benefits

Everforth Apex offers a comprehensive benefits package including medical, dental, vision, life, disability, ESPP (employee stock purchase program), 401K, HSA (Health Savings Account on the HDHP plan), SupportLinc Employee Assistance Program (EAP), corporate discounts, and more. Professional development opportunities include an on-demand training program, certification prep, and access to technical and leadership courses/books/seminars.