Sr. Architect, Technical

T-Mobile Bellevue, WA
Job Description

The Product & Technology Corporate Finance IT team is looking for a Senior Architect, technical with strong background in Data Warehouse and Business Intelligence. This is a hands-on Senior Architect role where the individual will be responsible in the overall design of the data ecosystem serving our Finance business partners with a focus on Revenue data. The finance data ecosystem currently includes data in our Aptitude data repository in Teradata, SAP data in BW, and hosted data in DB2. A person entering this role requires experience in data modeling, data architecture, design of semantic layer and report creation.

Responsibilities

* Own and advise on data architecture and reporting solutions for Finance data to support end user reporting and enterprise programs

* Deliver detailed design to development organization on enhancements to data architecture

* Perform detailed design reviews with product owners, developers and business stakeholders

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

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

* Partner closely with Business and Technology leads to build & deliver roadmaps

* Develop and maintain the semantic layer on the Teradata revenue finance data repositories

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

* Work closely with Enterprise architects, represent the domain and provide inputs around architecture, application and data capabilities

* Ensure data solutions are built for performance, fault tolerance and security with reusable patterns

* Support performance optimization within the Teradata platform by identifying opportunities in data transfer and storage to support improved performance

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

* Review the non-functional requirements and provide inputs/solutions to address concerns related to data security.

Qualifications

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

* Experience using architectural methodologies and frameworks like TOGAF, CITA, Zachman and ArchiMate

* Understanding of Big Data technologies, Hadoop, modern data architectures like Spark and NoSQL structures and cloud architecture

* Experience in Power BI, Alteryx, and other reporting applications

* Experience with stored procedures, PL/SQL, SQL queries, data analysis, and validation

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

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

* Good understanding of ETL processes and ETL best practices

* 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

* Experience working with financial data and an understanding of data quality standards and controls

* Minimum 6-8 Years BI data architecture experience.

* Minimum 5-7 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

Education

Minimum Required

* Bachelor's Degree

Minimum Qualifications

* LI-CS1