Finance Systems Analyst


WHO WE ARE LOOKING FOR:

Reporting to the SVP Finance, the Finance Data Systems Analyst is responsible for supporting the collection, validation and transformation of data for financial reporting.    The Finance Data 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.  The Finance Data Systems Analyst will work with finance personnel to understand the finance department information and reporting needs from an IT perspective.   The Finance Data 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 data – working with various departments, including the business intelligence team.  The Finance Data Systems Analyst will obtain and maintain an understanding of TTD’s IT infrastructure and help the finance org design and implement changes within or complementary to the infrastructure.   

WHAT YOU WILL BE DOING:

  • Gain an understanding of reporting needs and determine the best tool for accommodating these reporting requirements. Tools currently include MS Excel, MS Access, Dell Boomi, DBVisualizer, SSMS and Tableau
  • Develop the process to retrieve data from source systems using vsql, T-SQL, Microsoft Access SQL and provide such information to reporting tool(s)
  • 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 MS Excel and MS Access based tools 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, communicate the requirements to the IT team
  • Provide oversight and direction to development resources for finance-related business intelligence systems projects
  • Responsible for production support of all developed reports and databases
  • Support users with ad hoc reporting requests

WHAT YOU BRING TO THE TABLE:

  • Bachelor’s Degree with experience in a similar role
  • SQL Server Development skills
  • Strong understanding of data warehousing design principles and BI reporting / dash boarding tools such as Tableau
  • 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

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.


Help build the future of digital advertising.

View Opportunities View our awards.