T-Mobile USA is a national provider of wireless voice, messaging, and data services capable of reaching over 268 million Americans where they live, work, and play. In a world full of busy and fragmented lives, we at T-Mobile USA, Inc. have the idea that wireless communications can help. The value of our plans, the breadth of our coverage, the reliability of our network, and the quality of our service are meant to do one thing; help you stick together with the people who make your life come alive. That's why we're here.
Data Architecture Manager (Manager, Systems Architect)
As the leader of Data Architecture team for the Enterprise Data Warehouse (DW), this role is responsible to ensure correct architectural decisions around projects are consistent with the overall architecture vision. This role will work as a part of the Information Management (IM) organization, specifically the Architecture and Modeling team. This role will have responsibility for all data architects/modelers and solution architects. This position requires: expert level understanding of data warehousing concepts including both ER and Dimensional modeling and data integration (ETL, ELT), Business Intelligence/Information Delivery including experience creating architecture solution documents/architectural trade-offs, and sound decision-making.
The Architecture team is a leadership group within the Information Management team and is responsible for regular communications with the Enterprise Architecture team, IT groups, across IM and into development and support groups. The IM architecture strategies must line-up with overall IT architecture and strategies for the strategic vision for data warehousing at T-Mobile - working with and aligning to other business IT groups. Another responsibility is to work with the Solution Architect to help assess business requests and align to business data requirements to ensure the most efficient and effective architectural solutions are designed and implemented.
With respect to the Data Architecture/Modeling function, this role will have responsibility for continuing to organize this team and leading us to a central architect managed data model and data model standards & consistency with the EDW Chief Architects direction. This role will ensure data model consistency through reviews. It will also conduct business data modeling sessions with the business for all projects. This position will need mastery of understanding data relationships and how those are practically applied to high-performance information reporting, OLAP, operational and general analytical reporting. Currently, the data model is not centrally managed by the modeling team. The successful candidate will need to lead and drive the team to own, manage and deploy the data model via ERwin the DBA team. This leader will key role will be responsible for managing "single version of truth" core data models for the integrated EDW architectures. This includes modeling of the integration layer (IDS), DW (Teradata, and Greenplum) data storage areas. This person is responsible for ensuring the data models are consistent, and conform to enterprise and data modeling standards. Also, this role will be responsible for ongoing maintenance of the data models in their area of focused data subjects/subject areas. This team will work in parallel to complete data models for T-Mobile's Enterprise Data Warehouse Environment, including an integration layer (Oracle) model and data warehouse (Teradata) model. They will work from business data models gathered from business user sessions (data modeling workshops), and from the data requirements document provided by the Business Analyst team. These business data modeling sessions will be lead by data modelers with an interest in this and/or the Lead Data Architect/Modeler.
This position requires ERwin expert-level expertise. Also, requires experience with Teradata and Oracle database (skills on UNIX) are also helpful in order to perform DB functions such as DDLs and custom DML's as needed. Familiarity with Informatica is helpful. Understanding reporting performance turning concepts and how they relate to building data models and Teradata/Oracle database tuning assistance will be helpful.
Experience modeling complex hierarchies, models for performance and experience with logical and physical modleing techniques with Teradata is a plus. Greenplum experience also a plus.
Qualifications
General Responsibilities
Work with PM's, the Business Analyst teams, and the business to manage the architecture intake and workload of data architecture/modeling activities to meet project deadlines.
Work with the front-end reporting/requirements gathering team to produce adequate requirements documentation including Use Cases, DDS and conceptual/business data model.
Provide leadership around existing data model for integration layer- landing flat tables - non-relational, normalized area for storage of data and retaining data integrity and deltas and aggregated layer as-needed for high-performance reporting.
Organize team to provide data architecture/modeling for all projects/data subjects assigned.
Work with T-Mobile DBA group to drive changes to inefficient processes and/or where we need increased ownership.
Also, ensure clear communication between architecture, DBA's and development - communicate needs, environment migrations for DDL, schema/database, backups, and other data requirements
Work in an ambiguous, large and complex organization on tight-timelines with DBA team to ensure set-up of environment
Work with all IM teams with MTP's and migrations
Work with Testing team for set-up of testing environment
Manage all models through ERwin
Provide complete Data Modeling design documentation
Create templates and best practices for data modeling as needed
Create Conceptual/Business, Logical and Physical model and manage implementation
Requirements for this position include:
Extensive experience with end-to-end data warehouse implementations
DW industry expert with knowledge of, and interest in leading edge, best practice data warehousing/BI components
Knowledge of governances and current best practices for large scale enterprise data warehouses to ensure modeling meets these standards
Expertise in both federated or hybrid-federated, normalized and de-normalized data warehouse designs
Familiarity with all data warehousing components (Sourcing, ETL, Data Modeling, Infrastructure, profiling and Reporting)
Familiarity with reporting tool concepts such as Business Objects and/or Business Objects, MicroStrategy
Expert database knowledge and SQL skills required - Oracle, Teradata, or DW Appliances
Teradata expertise at the database level required
Expertise with Netezza or other appliances a plus
Deep knowledge of data modeling techniques for 3NF, dimensional models and hyper-normalized models (or generic data modeling components a plus), or dimensional-normal form
Able to communicate and persuasive with technical information to a wide audience -- inside the team of experienced architects all the way to executives
T-Mobile USA offers a full range of comprehensive benefits, including medical, dental, vision, as well as matching 401(k), generous paid time off programs, mobile phone and service discounts, tuition reimbursement, free parking - not to mention a fun and business casual work environment.
T-Mobile USA is an equal opportunity employer (EOE). We strongly support diversity in the workforce.
Job: EIT
Primary Location: WA-Bellevue WA
Work Locations:
WA-Corporate Sunset (WA503)
13920 SE Eastgate Way
Ste 300
Bellevue, 98006
Relocation assistance available
Schedule: Full-Time
Travel: Yes, 10% of the time
Contact me at kimberly.hughes@rightthinginc.com to apply
0 comments:
Post a Comment