Data Solutions Analyst (Multiple Positions)

About TikTokTikTok is the leading destination for short-form mobile video. At TikTok, our mission is to inspire creativity and bring joy.TikTok's global headquarters are in Los Angeles and Singapore, and we also have offices in New York City, London, Dublin, Paris, Berlin, Dubai, Jakarta, Seoul, and Tokyo.Why Join UsInspiring creativity is at the core of TikTok's mission. Our innovative product is built to help people authentically express themselves, discover and connect – and our global, diverse teams make that possible.Together, we create value for our communities, inspire creativity and bring joy - a mission we work towards every day.We strive to do great things with great people. We lead with curiosity, humility, and a desire to make impact in a rapidly growing tech company.Every challenge is an opportunity to learn and innovate as one team. We're resilient and embrace challenges as they come.By constantly iterating and fostering an "Always Day 1" mindset, we achieve meaningful breakthroughs for ourselves, our company, and our users.When we create and grow together, the possibilities are limitless.Join us.About the TeamOur team plays a crucial role in ensuring the company’s success. We seek people who are willing to learn and put in the effort to solve problems. Our challenges are not your regular day-to-day problems - you’ll be part of a team that’s developing new solutions to new challenges. It’s working fast, at scale, and we’re making a difference. We are looking for talents to join us on this exciting journey!ResponsibilitiesDesign, develop, and implement data models and techniques and transform raw data to provide insights and recommendations to influence business decisions and strategies.Visualize, analyze, interpret, and report on revenue, ad product performance, and campaign KPI data findings.Design data schema, write queries to extract data, and manipulate data through ETL processes in SQL.Perform root cause analysis and troubleshoot failures through ad-hoc analysis of data, and communicate findings with cross-functional partners to drive resolution.Create automated dashboards to track real time product performance.Collaborate with cross-functional teams (including sales, product, engineering, operations, or marketing) to develop tools for data visualization.QualificationsMust have a Master’s degree or foreign equivalent degree in Computer Science, Engineering (any), Information Systems, Data Science, Business Analytics, Statistics, Mathematics or a related field, and 1 year of related work experience; OR a Bachelor’s degree or foreign equivalent degree in in Computer Science, Engineering (any), Information Systems, Data Science, Business Analytics, Statistics, Mathematics or a related field, and 3 years of related work experience.Of the required experience, must have 1 year of experience in each of the following:Constructing advanced queries using SQL;Analyzing historical data and applying root cause analyses to identify trends and patterns;Designing and maintaining dashboards using Tableau or Power BI to visualize key data and insights, track key performance indicators, and provide self-service tools to stakeholders;Creating, maintaining, and delivering reports using Excel and developing and validating metrics to evaluate business performance;Using Python to manipulate data for analysis and prediction, automate data load processes, and optimize reporting processes; andDeveloping and maintaining tables, views, indexes, datasets, and data pipelines to extract, clean, transform, load and maintain data across multiple databases.Travel Requirement: Domestic travel required up to 5%.Employer: TT Commerce & Global Services LLCType: Full time, 40 hours/weekLocation: New York, NYSalary Range: $115835 - $151200 per yearTo Apply, click the apply button below. Contact View email address on us.fitly.work if you have difficulty submitting resume through the website.TikTok is committed to creating an inclusive space where employees are valued for their skills, experiences, and unique perspectives. Our platform connects people from across the globe and so does our workplace. At TikTok, our mission is to inspire creativity and bring joy. To achieve that goal, we are committed to celebrating our diverse voices and to creating an environment that reflects the many communities we reach. We are passionate about this and hope you are too.TikTok is committed to providing reasonable accommodations in our recruitment processes for candidates with disabilities, pregnancy, sincerely held religious beliefs or other reasons protected by applicable laws. If you need assistance or a reasonable accommodation, please reach out to us at ID: A215540