Teradata - Data Architect

Key Skills

AWS, Azure, Effective communication skills, Google Cloud Platform (GCP), SQL, Statistics

Job Description

NorthBay is looking for Data Architect - Teradata who defines, develops, and promotes the Teradata Enterprise Data Architecture strategy that aids our clients in achieving their strategic information management goals. The Data Architect defines and leads data architecture and data strategies that underpin a successful data implementation.

Excellent communication and stakeholder engagement skills are essential as the role involves working closely with our clients, 3rd party vendors, management consultants, and internal data teams.

Key Areas of Responsibility

• Work with business leaders to create Conceptual Data Architectures which align business needs with Target State Architecture.
• Participation in the creation of an Enterprise Reference Data Architecture for a Client
• Participation in the definition of standard enterprise data management and enterprise data architecture processes and deliverables.
• Define enterprise architectures for Data Warehouse, Master Data/Reference Data, integration for data and transaction processing.
• Collaboration with the business, its applications, solutions, and with technical architects to understand the implications of respective architectures on data architecture and to maximize the value of information across the organization.
• Effectively communicate the benefits of all aspects of Data Management including Master
• Data Management and Metadata Management process and principles
• Assist with the Client’s review and approval of all major business solutions delivery projects.
• Work with the Client’s Database Administration, Architecture, and Data Analytics teams to help set the enterprise data strategy and standards
• Actively participate and lead data mapping exercises and facilitate data modelling sessions with business and technical teams from information gathering to model validation.
• Build the enterprise conceptual, logical, and physical data models for analytics, operational, and reporting structures in accordance to Teradata’s industry best practices.
• Providing support to analyze data requirements and data stored in a disparate set of systems and designing a robust set of data structures.
• Develop lasting relationships with client personnel to facilitate a trusted advisor relationship.
• Responsible for coaching and mentoring less experienced team members.
• Semantic Modeling
• Data Profiling

Technical Skills

• Data modelling experience across relational and non-relational technologies
• Demonstrate an in depth understanding of designing the conceptual, logical, and physical database architectures, design patterns, best practices, and programming techniques around relational modelling, dimensional modelling, and data integration for relational and non-relational databases
• Knowledge of indexes, index management, and statistics.
• Experience with visualization and reporting tools, data profiling analysis and transformation.
• Previous technical background in Database Development and/or Data Warehouse Analysis /
• Business Intelligence roles with strong SQL skills, some programming, data design or business architecture experience
• Proven ability to undertake business analysis of problems and framing the solutions in business terms while providing the high-level designs and proposals
• Strong data mapping skills sufficient to take ownership of all mapping deliverables and ensure successful hand-over to the technical team.
• Demonstrated senior level capabilities in conceptual analysis, problem solving, and data analysis, with ability to lead and facilitate business requirements and data analysis and modelling sessions.
• Strong understanding of data architecture principles and techniques
• Experience working within a Cloud Data Environment: AWS, MS Azure, or Google Cloud Platform
• Experience with Cloud Data technologies, solutions, and future Cloud Data Strategies
• Experience Meta data architecture and Master Data Management Solutions.
• Performing analysis and design for Data Management and Data Driven projects.
• Strong Business and Data Analysis skills
• Strong leadership and influence skills across Business and Technology organizations
• Proactively engage with the project stake-holders and understand requirements.