T-Mobile USA, Inc. Sr. Architect, Technical in Bellevue, Washington

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 Min