Finance Systems Analyst

The Trade Desk is changing the way global brands and their agencies advertise to audiences around the world. How? With a media buying platform that helps brands deliver a more insightful and relevant ad experience for consumers – and sets a new standard for global reach, accuracy, and transparency. We are proud of the culture we have built. We value the unique experiences and perspectives that each person brings to The Trade Desk, and we are committed to fostering inclusive spaces where everyone can bring their authentic selves to work every day. So, if you are talented, driven, creative, and eager to join a dynamic, globally-connected team, then we want to talk! What we do: The Finance Systems Analyst is responsible for supporting the collection, validation, and transformation of data for financial reporting. The Finance Systems Analyst will have a holistic view of data sources, processes, outputs and the ability to trouble shoot and resolve problems related to matching up data sources, data repositories and reporting for the finance department with a focus on revenue. The Finance Systems Analyst will work with finance personnel to understand the finance department information and reporting needs from an IT perspective. The Finance Systems Analyst will develop a strong understanding of the current financial applications, processes and data and work to build out solutions for reporting on finance with a focus on revenue. The Finance Systems Analyst will obtain and maintain an understanding of TTD’s finance systems infrastructure and help the finance org design and implement changes within or complementary to the infrastructure. What you’ll do: Gain an understanding of revenue and other finance team reporting needs and determine the best tool for accommodating these reporting requirements. Tools currently include Incorta, Oracle ERP, Oracle EPM, SQL Server, Vertica, Anaplan, and Tableau. Gather reporting requirements through workshops, questionnaires, surveys, workflow storyboards, use cases, scenarios, and other methods, and document report requirements. Design and develop the process to retrieve data from source systems and create reports on the reporting tool(s). Design and develop reporting solutions for end users with various reporting requests. Reconcile data and information from reporting tools back to source systems and vice versa. Assist in ensuring the integrity of the data in the data warehouse or reporting systems. Assist with building out solutions to “bridge the gap” between manual processes and IT tools and then, when the time comes to transition to a non-MS Excel/Access tool, build the solutions in a more scalable tool. Assist with testing and implementation of bug fixes and enhancements of finance systems. Assist in implementing business process improvements focusing on revenue. Provide oversight and direction to development resources for finance-related business intelligence systems projects. Responsible for production support of all developed reports and databases. Who you are: Bachelor’s Degree with experience in a similar role. Experience in data modeling, SQL, PLSQL including stored procedures, functions, packages, views, and performance tuning. Strong understanding of data warehouse design principles and structures. Hands-on experiences with BI reporting / Analytics tools such as Tableau, Incorta, Alteryx. Must have a functional understanding of typical corporate software systems – such as ERP, HRIS and other related systems. Must be completely proficient in Microsoft Office, including experience with MS Access and VBA for MS Excel. Strong critical and analytical thinking and problem-solving skills. Strong experience with data profiling, data mapping and data mining. Outstanding communication skills – including written and verbal communications, interpersonal, analytical, negotiating and problem-solving skills. Ability to juggle multiple high priorities and have a willingness to learn. Should love data and showing others the power it holds. Strong desire to expand knowledge, drive innovation and create solutions. #LI-CQ1 The Trade Desk does not accept unsolicited resumes from search firm recruiters. Fees will not be paid in the event a candidate submitted by a recruiter without an agreement in place is hired; such resumes will be deemed the sole property of The Trade Desk. The Trade Desk is an equal opportunity employer. All aspects of employment will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.