T-Mobile USA, Inc. seeks Business Analysis Managers in Bellevue, WA to own analysis of paid media investment in one or more channels (e.g., Search, Social, Display) supporting T-Mobile's key initiatives such as Un-carrier moves, demand gen offers, and brand campaigns. Discuss with business partners and align on key performance indicators that need to be monitored and analyzed. Develop deep understanding of available datasets, and ability to transform, join and aggregate them to extract key performance indicators. Perform prototype ingestion, aggregation, and quality control of new datasets. Analyze historical data to understand how investments in different media channels impact business results. Recommend how to change the mix and nature of our advertising spend in future periods to achieve maximum possible outcome. Create visualizations and formulate storylines to provide actionable recommendations to partners. Present complex analyses in concise and impactful manner to business line owners, media buying team and other marketing stakeholders. Communicate insights with a purpose of increasing enterprise value by improving efficiency of media spend. Cultivate collaborative and positive cross-functional relationships with marketing teams, media agencies, advertising partners, and measurement/analytical vendors. Keep updates on evolving MarTech and AdTech platforms and capabilities by attending relevant webinars and educational sessions from business partners. Validate, and critique analyses and models built by external measurement partners. Telecommuting is permitted, but applicants must live within a reasonable commuting distance. Experience and education requirements: PRIMARY REQUIREMENTS: Master's degree in Business Administration or related, and 3 years of relevant work experience. ALTERNATIVE REQUIREMENTS: Bachelor's degree in Business Administration or related, and 5 years of relevant work experience. In addition, the following skills are required: (1) Working with advanced command of SQL, conducting data encoding, transforming, and loading (ETL), including data cleaning and normalization. Preparing data for visualization, querying, and statistical and quantitative analysis. Using Alteryx for validating, cleansing, and blending various data sources, and uploading new datasets into Enterprise Data Warehouse; (2) Working with Tableau, creating data visualizations that accurately reflect analytical results, for the purpose of presenting analytical findings to executive stakeholders using PowerPoint. Building complex dashboards using filters, parameters, data blending, and level of detail expressions. Utilizing commands of dashboard publishing and subscriptions procedures; (3) Using Excel, conducting data analysis across disparate database sources for the reporting insights to executive stakeholders. Exporting output of database analysis to use as inputs for quantitative analysis in Excel, including financial modeling and KPI/business driver modeling. Building complex data models with multiple inputs and calculation tabs using scenario planning, sensitivity analysis, ROI analysis, and cash flow calculations; (4) Using PowerPoint and ThinkCell, creating executive-level decks summarizing complex analytical projects into actionable takeaways and recommendations. Presenting to large groups, staying on message, and managing time effectively while answering questions. Coordinating content across multiple contributors using project management techniques (Gantt chart, project documentation) and gaining stakeholder alignment on key messages. Washington Pay Range: $152,214.00 to $157,214.00/year. The pay range above is the general base pay range for a successful candidate in the state listed. The successful candidate's actual pay will be based on various factors, such as work location, qualifications, and experience. At T-Mobile, employees in regular, non-temporary roles are eligible for an annual bonus or periodic sales incentive or