Data Architect - Data and Automation (Teradata, SQL, Hadoop, Iceberg)
About The Position
Designs, develops and optimizes data warehouses, with flexible and scalable data and ETL architecture, to support business users and Business Intelligence (BI) applications. Analyzes business intelligence data and makes recommendations for data warehouse growth and integration an application/business function. Works with IT and business customers to capture requirements for designing the data warehouse architecture. Provides support and technical guidance to ensure the solutions are aligned with the architecture and framework. Leads and consults on the implementation and integration of data warehouses; ensures the solution meets organizational quality and integrity standards.
Requirements
- Teradata
- SQL
- Hadoop
- Iceberg
- University / college degree, with 5+ years of industry-relevant experience. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.
Nice To Haves
- Apache Hadoop
- Competitive Advantages
- Customer Solutions
- Design
- Enterprise Architecture Framework
- Machine Learning (ML)
- Risk Assessments
- Structured Query Language (SQL)
- Technical Knowledge
- Teradata ETL
Responsibilities
- Administer and support enterprise Teradata database environments, ensuring high availability, performance, security, and reliability for critical business applications and data warehouse solutions.
- Monitor database health, troubleshoot production incidents, optimize SQL performance, and resolve data and application issues to meet establish service level agreements (SLA).
- Support ETL and batch processing by managing Teradata utilities, analyzing job failures, and collaborating with application development and infrastructure teams to ensure successful data processing
- Implement database changes, manage user access and security, perform performance tuning, and maintain database objects in accordance with change management and operational best practices.
- Partner with cross functional teams to identify opportunities for process improvement, automate routine administrative tasks leveraging AI agent, and provide technical guidance to enhance database performance and operational efficiency.
Benefits
- medical/prescription drug coverage (with a Health Savings Account feature)
- dental and vision options
- employee and spouse/child life insurance
- short and long-term disability protection
- 401(k) with PNC match
- pension and stock purchase plans
- dependent care reimbursement account
- back-up child/elder care
- adoption, surrogacy, and doula reimbursement
- educational assistance, including select programs fully paid
- a robust wellness program with financial incentives
- maternity and/or parental leave
- up to 11 paid holidays each year
- 9 occasional absence days each year, unless otherwise required by law
- between 15 to 25 vacation days each year, depending on career level; and years of service
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
