Principal Data Architect - RT

Principal Data Architect - RT

Bellevue, Washington 98004

The Enterprise Data Solutions (EDS) IT team is looking for a Principal Data Architect with strong background in Data Warehouse and an interest in driving a data driven culture through an optimized data architecture for delivering insights. This is a hands-on strategic role where the individual will be responsible in the overall design of the EDS data ecosystem including Integrated Data Warehouse (IDW), ODS and Hadoop Data Lake in addition to mentoring data architects and developing a roadmap of the future state data ecosystem. A person entering this role requires experience in data modeling, data architecture for near-real time data ingestion, API design, advanced reusable data profiling techniques, and design of semantic layer. The EDS team supports various business areas in achieving results including Internal IT, Finance, Marketing, Digital, Supply Chain, Care, and Sales.

Â

Responsibilities :

Work with IT and business management on architecture and design patterns alignment

Responsible for driving design reviews ensuring integration of data across multiple domains and design of semantic layer for data access

Architect, design, and build enterprise class relational and dimensional data models.

Conduct industry research & trends for setting the direction of Information Architecture

Stay abreast of information management trends and standards, master data management, data services, self-service business intelligence, metadata management, data quality, and data governance.

Build & maintain Reference Model Architecture and Standards for communicating direction of Information Architecture.

Lead design and build the data architecture layer to drive solutions that will be implemented by the development teams.

Work with the platform team in optimizing Data Architecture and optimize use of data assets for Data Science.

Develop proof-of-concept and prototypes to help illustrate approaches to technology and business problems

Collaborate with Enterprise Architecture to define service delivery landscape

Work with CIS team in delivering an architecture to support encryption and row-level data security

Support the Data Governance and EDS metadata initiative

Required Knowledge, Skills, and Abilities:

1. Looking for a very hands Architect to join our Enterprise Data Team

2. 8+ years of experience with digital architecture technology & patterns ( NRT loads, active DW,JSON processing design etc)

3. 8+ years of experieng with BigData and Cloud space

4. Must have experience with Teradata

5. Strong working knowledge of Teradata, Hive, HBase, and Postgres

6. Experience in data architecture for handling streaming and batch data within a data warehouse landscape

7. Understanding of Big Data technologies, Hadoop and modern data architectures like Spark and NoSQL structures

8. Experience in AWS (S3, Redshift, RDS, etc.)

9. Experience in distributed data processing framework such as Spark and MapReduce and data streaming such as Kafka, Spark streaming preferred

10. Experience with API management solution such as Apigee, Mulesoft, AWS API Gateway, etc

11. Strong programming skill with at least one of the following - Python, Java, Scala, etc.

12. Data modeling tools (Erwin, Power Designer) and standards.

13. Experience with data profiling tools such as Ataccama, Trifacta, etc preferred

14. Experience with ETL Tools such as Informatica BDM, etc

15. Excellent SQL tuning knowledge and experience with Teradata Query Grid preferred

16. Experience working with vendors to evaluate, select, and implement 3rd party solutions

17. Demonstrates working knowledge of UML documentation of various business process and modeling to build Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, and Event modeling

18. Excellent problem solving and analytical skills

19. Excellent written and verbal communication skills with strong relationship building skills

20. Minimum 12 Years BI data architecture experience.

21. Minimum 8-9 years professional experience designing BI solutions on RDBMS Teradata version 14, 15 or 16

DesiredÂ

22. B.S. Computer Science or Management Information Systems or equivalent experience.

23. Certification in Teradata, AWS or Hadoop preferred

24. . Salary Expectation? 25. Must be a US Citizen or Green Card holder?

26. Complete Current address