Overview

The Data Architect is responsible for delivering high quality data storage solutions and efficient data integration strategies used to support applications (OLTP), business intelligence (OLAP), advanced analytics, and machine learning (NoSQL) across the Enterprise. Drawing on robust hands-on experience and leveraging multi-cloud services, NoSQL/ Distributed systems, web services, and relational database technologies, this team member will drive the adoption of multi-hybrid cloud data services as well as large scale data pipelines across the enterprise ensuring emerging business goals are met while maintaining a consistent and stable data landscape.

The Data Architect leads and coordinates cross-functional teams composed of developers, administrators, and business teams on a project basis, effectively communicating database design related activities to a wide range of technical, non-technical, and 3rd party team members. While they search for, identify, and exploit opportunities for more effective data storage and use; this team member will also provide mentorship to more junior team members, and participate in strategic discussions with department and IT leadership.

Responsibilities

JOB DUTIES

• Create and Document Logical Data Integration (ETL) Strategies for Data Flows between disparate Source/ Target Systems and the Enterprise Data Warehouse
• Perform a variety of in-depth Data Analysis, Data Modeling, and Data Administration tasks on complicated Datasets and potentially complex Data Integration scenarios with limited supervision
• Provide Senior-Level Guidance in the interaction with business users to plan, develop, improve, and maintain complex components of the Logical/ Physical Enterprise Data Warehouse and related Models
• Establish, Maintain and Adhere to Enterprise Data Modeling and Data Integration Standards
• Communicate with and/or interview users to plan, develop, improve and maintain moderately complex components of the logical/ physical corporate model
• Work closely with BSA, Business, and ITS Team Members to clarify and refine functional data requirement specifications
• Develop and present training materials such as Data Flow Diagrams, Conceptual Diagrams, UML Diagrams, ER Flow Diagrams as needed in order to clarify Data Model meaning and usage effectively to a wide range of technical and non-technical consumers
• Create, maintain, and adhere to Enterprise Data Modeling Standards
• Participate in the implementation of strategic Enterprise Data Strategies
• Must drive innovations by keeping current on emerging technology and Data Trends which may fit with GMF needs; must be able to research, present, and accurately articulate benefits and goals of these technologies
• Serve as a SME for cloud data storage, on-premises data storage, and data integration across teams to support 12-Factor software development (operational) and NoSQL data engineering. Initial focus on Azure followed by Multi-Cloud
• Recommend advanced cloud and on-premises data storage and integration-related solutions on basis of need and risk
• Educate and mentor teams on cloud data services and standards
• Regularly communicates project health and identifies risks to project, program stakeholders, sponsors, and management
• Resolve most conflicts between timeline, budget, and scope independently but intuitively escalate complex or consequential issues to management
• Define cloud data standards, DevOps, Continuous Integration / Continuous Delivery (CI/CD) processes
• Participate in the proliferation of our Corporate Meta-Data Repository
• Perform other duties as assigned
• Conform with all company policies and procedures

Qualifications

Knowledge

• Thorough understanding and working knowledge of Data Modeling and extensive experience in Modeling and Fact-Finding Techniques
• Must have strong knowledge of Relational Database, Dimensional Database, NoSQL, and Hub and Spoke Database architectures
• Advanced experience with current data technologies including Hadoop, Big Data, NoSQL, Data Virtualization, Data Services, Oracle, Oracle Exadata
• Must have strong working knowledge of use of Data Modeling Software
• Must have strong working knowledge of ETL and Data integration techniques, Informatica Power Center/ Cloud preferred
• Thorough knowledge of SQL and SparkSQL
• Hands-on experience in creation and usage of 3rd Normal Form OLTP Databases/ Models
• Hands-on experience in creation and usage of ETL Design Specifications
• Hands-on experience in creation and usage of Dimensional Models (STAR Schema, Kimball, Inmon)
• Advanced understanding of Busing Intelligence Tools, their functional and technical requirements, Cognos and Power BI preferred
• Must have basic understanding and working knowledge in at least 1 (one) of the following Data Management disciplines: Data Vault, Master Data Management, Data Virtualization, Cloud Data Storage Services
• Must be highly intelligent, conceptual, display excellent judgment, and be capable of analyzing business and management problems
• Must possess the ability to arrive at sound and effective business solutions
• Position requires proficient business knowledge in the subject areas being modeled

Skills

• Must have excellent oral and written communication skills, and the ability to prioritize and handle multiple tasks
• Advanced Analytical Skills
• Must be able to recognize and identify Patterns in Data Relationships from Disparate Systems
• Ability to independently identify opportunities for improvement in Enterprise Analytical Databases
• Ability to create system and process flow diagrams, data flow diagrams, sequence and UML diagrams, inter- and intra- system dependencies within and across functional domains
• Possess strong organizational, facilitation and critical thinking abilities, to assess complex problems, analyze options, navigate diverse perspectives and objectives and develop acceptable Data Management solutions
• Strong work ethic, positive demeanor, and drive to see projects through to successful completion
• Ability to meet expected delivery dates and the tasks necessary to achieve objectives
• Must possess the interpersonal skills necessary to lead and coordinate others to accomplish goals on complex tasks/ projects
• Must have the ability to work both autonomously and with appropriate collaboration among other team members
• Must be able to apply Data Management concepts to a variety of "real-life" business scenarios
• Must be assertive, proactive, and have the ability to bring out the best in others
• Must have strong project management skills

Education

• High School Diploma or equivalent required
• Bachelor's Degree in related field or equivalent work experience preferred

Experience

• 5-7 years data modeling experience required
• 2-4 years working with ERwin Data Modeler required
• 3-5 years with cloud architecture and PaaS, IaaS, SaaS services related to data storage (Azure required, multi-cloud solutions preferred)
• Database/ data store design experience with three or more years of experience with cloud-like technologies such as Microsoft Azure, Amazon Web Services (AWS) or Google Cloud Platform (Google Cloud Platform) preferred
• Experience in Application Development, ETL Development, Report Development and/ or other Data Warehouse Projects preferred
• Experience working within an Enterprise Data Management role including transactional Data, Analytical Data, and Data Governance/ Administration preferred
• Experience with Oracle/ Oracle Exadata highly preferred
• Strong experience with Data Modeling and Data Integration tools preferred
• Experience with Cloud-based Data Warehouse services (Azure Synapse, Data Bricks Delta Lake, Snow Flake, AWS Redshift) preferred
• Experience architecting DevOps automated data pipelines preferred
• Experience architecting Enterprise Data Pipelines leveraging technologies such as Kafka, Azure Event Hub, Azure Service Bus preferred
• Experience creating and maintaining Web Services for Enterprise Data Hub preferred
• Experience Architecting solutions for Machine Learning and Advanced Analytics/ Data Science deployments preferred
• Experience Architecting Enterprise Data Lake/ Distributed Data patterns for use in Multi-Cloud/ Hybrid Cloud Environments preferred #LI-TS1 #LI-TS1