Trooh is a leading American media company, reaching millions of Gen Z consumers on their daily journey out-of-home. We have transformed the landscape with the integration of data, insights, and digital into large-scale, sought-after locations. As leaders in audience targeting to 18 to 24's, we have built scale and impact through our campus environments in over 1000+ colleges and universities nationwide. Trooh’s extensive addressable media, spread across thousands of high dwell time locations, ensure high-impact solutions to engage Gen Z consumers at the right time.
This is an exciting opportunity for a database analyst who will provide valuable support through the administration and analysis of client contracts for US internal departments and external clients. Responsible for the initiation and creation of venue records and accounts in our CRM system, and managing data and reporting to update external client platforms and report on strategic analytics across the organization.
The Database Analyst will have the opportunity to gain valuable insight and hands‑on experience in collaborating in the end-to-end operations of the advertising industry.
Accountabilities and Responsibilities :
- Collect data to identify areas for improvement within an organization’s IT infrastructure
- Develop and maintain computer databases
- Document reporting needs, queries, logic, results and recommendations to other information systems professionals
- Enact measures to make sure unauthorized users cannot access the data
- Provide advice to other informatics professionals regarding database management tools
- Operate database management systems to analyze data
- Develop and implement data administration policy, standards and models
- Research and document data requirements, data collection and administration policy, and data access rules
- Develop policies and procedures for network access and usage and for the backup and recovery of data
- Upkeep Trooh inventory in sales planning, agency, and programmatic platforms
- Liaise with Operations and Network Development Managers for updates on venue and contract status
- Develop venue accounts and enter the financials of approved Trooh contracts in our asset management system
- Provide ongoing management on digital and static inventory data by ensuring all files are up to date and reflective of current assets and contracts
- Manage and create content accounts for venues
What you offer :
Post‑secondary education preferably related to business administration and a minimum of over 3 years experience in an operations roleExperience creating and maintaining reports from single and multiple data sourcesSuperior PC skills with an advanced proficiency in MS Office Suite (specifically Excel, PowerBI, PowerApps)Experience in a company wide ERP / CRM media software is requiredAbility to handle multiple projects and requests simultaneously utilizing strong time‑management skills in a highly organized fashion
Professional, outgoing, enthusiastic and a real team player that is ready to champion the Trooh brandHighly accurate, detail‑oriented and attention to detailExceptional organizational skills coupled with excellent interpersonal, verbal and written communication skillsWhat a career at Trooh can offer you?
Competitive compensation packagesFull benefits including a 401K and tax savings through a FSAGenerous paid time off as well as a December holiday closure4.5 Day Work WeekMilestone Recognition ProgramPaid InternshipsTraining opportunities : Online and leadership development trainingVibrant team‑work environmentWe appreciate the interest of all candidates, however, only candidates selected for an interview will be contacted.
Trooh Media is an equal opportunity employer. If you require accommodation during the recruitment and selection process, please let us know. We will work with you to meet your needs.
Seniority level
Mid‑Senior levelEmployment type
Full-timeJob function
Information TechnologyIndustries
Advertising ServicesReferrals increase your chances of interviewing at Trooh by 2x
Get notified about new Database Analyst jobs in Toronto, Ontario, Canada .
#J-18808-Ljbffr