Business Intelligence EDW Administrator

| Greater NYC Area
Sorry, this job was removed at 2:50 a.m. (EST) on Monday, July 10, 2017
Find out who's hiring in Greater NYC Area.
See all Data + Analytics jobs in Greater NYC Area
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

WHO ARE WE LOOKING FOR?
As member of The Trade Desk’s Business Intelligence Team, you will work extensively with Trade Desk team members across all functional areas to understand data and reporting needs; maintain the integrity of company data and put checks in place to ensure accuracy; and develop the foundational layer for all corporate reporting in the form of an enterprise data warehouse (EDW). You will be the key owner/driver of the EDW as we begin building this corporate data repository with the strategic goal of helping Senior Management team identify key growth opportunities.

KEY DAY TO DAY RESPONSIBILITIES:

 

Our Business Intelligence Data Warehouse Developer reports to our Manager of Business Intelligence Services and will own Business Intelligence service delivery and special projects from start to completion, including:

• Define, design and implement business intelligence (BI) processes and services to enable analysis of corporate data to support strategic initiatives
• Design, implement and maintain the enterprise data warehouse (EDW); Support creation and implementation of the data loading (ETL) and publishing processes within the DW/BI environment; Perform ETL work if required
• Support MDM efforts to create, implement and standardize “single source of truth” as part of the EDW.
• Work closely with the Finance Engineering team and TTD stakeholders to guide requirements gathering, conduct analysis and prepare specifications
• Contribute to Global BI Team process improvement initiatives and projects
• Make individual contributions to Global BI Team KPI achievement
• Contribute to the assessment of the current state of existing data, enhancements that can be made, and future data points that could provide value to the company
• Contribute to the company’s Knowledge Base by the creation of new articles and updating existing ones.
• Assist with screening and hiring permanent support team members for the Global BI Team
• Participate training on support-related tools and processes
• Light on-call/after-hours support


DESIRED SKILLS & EXPERIENCE


• Must have ability to design and implement multi-dimensional models, including the construction of Data Views, Dimensions, and Cubes (SQL Server environment preferred)
• Proven experience in DW, ETL and MDM tools/practices.
• Proven experience and ability to develop complex SQL queries and reports
• Must have deep hands-on expertise with relational databases (primarily Microsoft SQL), and data warehouse methodologies/practices - experience with SQL Server, Vertica, and Hadoop a plus
• Outstanding analytical and problem-solving abilities
• Ability to collaborate cross-functionally in a fast-paced start-up
• Experience in a customer / client facing role (working directly with business stakeholders)
• Excellent written, verbal and presentation skills
• Bachelor's degree from a four-year college or university is required; quantitatively focused majors preferred (Computer Science, Information Systems etc.)
• Effective time management skills – ability to prioritize and meet deadlines
• 3+ years of relevant work experience working in an analytics environment

 

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.

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Location

Our NY office is in the Grace Building with sweeping views of the city, Bryant Park and close to lots of great restaurants.

Similar Jobs

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about The Trade DeskFind similar jobs