Experience Inc. Jobs

Career Band: L08 Be unstoppable with us! T-Mobile is synonymous with innovation-and you could be part of the team that disrupted an entire industry! We reinvented customer service, brought real 5G to the nation, and now we're shaping the future of technology in wireless and beyond. Our work is as exciting as it is rewarding, so consider the career opportunity below as your invitation to grow with us, make big things happen with us, above all, #BEYOU with us. Together, we won't stop! Position summary T-Mobile is America's supercharged Un-carrier, delivering an advanced 4G LTE and transformative nationwide 5G network that will offer reliable connectivity for all. Business Analysis Managers located in Bellevue, WA will 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. Position duties and responsibilities include, but are not limited to: 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. Skill requirements: (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. Coordina