Job Description :
Principal Data Engineer
Direct Hire position
Location: Bellevue, WA
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
Qualifications :
Strong working knowledge of Teradata, Hive, HBase, and Postgres
Experience in data architecture for handling streaming and batch data within a data warehouse landscape
Understanding of Big Data technologies, Hadoop and modern data architectures like Spark and NoSQL structures
Experience in AWS (S3, Redshift, RDS, etc
Experience in distributed data processing framework such as Spark and MapReduce and data streaming such as Kafka, Spark streaming preferred
Experience with API management solution such as Apigee, Mulesoft, AWS API Gateway, etc
Strong programming skill with at least one of the following - Python, Java, Scala, etc.
Data modeling tools (Erwin, Power Designer) and standards.
Experience with data profiling tools such as Ataccama, Trifacta, etc preferred
Experience with ETL Tools such as Informatica BDM, etc
Excellent SQL tuning knowledge and experience with Teradata Query Grid preferred
Experience working with vendors to evaluate, select, and implement 3rd party solutions
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
Excellent problem solving and analytical skills
Excellent written and verbal communication skills with strong relationship building skills
Minimum 12 Years BI data architecture experience.
Minimum 8-9 years professional experience designing BI solutions on RDBMS Teradata version 14, 15 or 16
Desired
B.S. Computer Science or Management Information Systems or equivalent experience.
Certification in Teradata, AWS or Hadoop preferred
SKILLS AND CERTIFICATIONS
Big data
Cloud
TeraData
IDEAL CANDIDATE
Looking for a very hands-on Architect to join our Enterprise Data Team
8+ years of experience with digital architecture technology & patterns (NRT loads, active DW, JSON processing design etc)
8+ years of experience with BigData and Cloud space
Must have experience with Teradata