Ad Sales Data Steward Coordinator
Title: Ad Sales Data Steward Coordinator
Location: New York, NY 10013 (Remote, NY)
Duration: 12 Months
Description/Comment:
This role will be directly responsible for ensuring Customer and Ad Sales Data is as healthy, complete and robust as possible. He/she will work with his/her counterparts across the Media Network to help to establish and enforce business rules, define data quality metrics, assist with cross-system reconciliations and participate in the remediation of data issues.
This role will be core to improving processes that ensure cross-system data harmonization and alignment with the Master Data Management (MDM) solution. The Business Data Steward Coordinator will report to the Manager, Master Data Manager and help manage DAS’s internal Sales data including Sales Team structure, Sales Team-to-Account alignment and Account mapping.
• Understand Data Flows/Processes across internal systems.
• Assist with system-to-system field mapping for future migrations & integrations as well as manage system data on Sales teams and Sales Team-to Account Assignments.
• Assist with data cleansing activities, including creation, mapping, updates, and de-duplication.
• Identify and utilize public data sources to enrich our existing advertiser/agency customer data.
• Assist in monitoring and profiling existing data sets to ensure business rule adherence, system feature adoption and suggest methods for improvements or additional training needed.
• Work with Sales, Account Management, and Accounting to process order and proposal transfers.
• Record, troubleshoot, and resolve various support requests originating from SalesHub and integration with other sales systems directly from end users in a timely manner. Escalate issues to technology and Credit teams were deemed appropriate.
• Pursue enhanced efficiencies within Sales processes and in providing support.
• Escalate issues to manager related system enhancements and support requests and share with Sales and IT.
Basic Qualifications:
• Proficient understanding of relational data and relational database concepts. Excel Proficiency a must - creating spreadsheets, formulas, macros, etc.
• Minimum 1 years of Data Analysis experience
• Ability to articulate and communicate complex data to a variety of audiences including business leaders, project teams, IT and management.
• Prior experience with Salesforce.com or similar CRM system preferred
• Willingness to learn and collaborate on solutions.
• Meticulous attention to detail
• Outside-the-box thinker when it comes to creating/improving processes, systems, tools, etc. Excellent communication, interpersonal, motivational, and presentation skills
Preferred Qualifications:
• Minimum 2 years exp is preferred.
• Familiarity with the Media and/or Advertising industries
• Experience using Data Visualization tools such as Tableau
• Strong operational mindset with a passion for quality control and efficiency.
• Ability to work independently and meet deadlines with minimal supervision.
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.
US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Title: Ad Sales Data Steward Coordinator
Location: New York, NY 10013 (Remote, NY)
Duration: 12 Months
Description/Comment:
This role will be directly responsible for ensuring Customer and Ad Sales Data is as healthy, complete and robust as possible. He/she will work with his/her counterparts across the Media Network to help to establish and enforce business rules, define data quality metrics, assist with cross-system reconciliations and participate in the remediation of data issues.
This role will be core to improving processes that ensure cross-system data harmonization and alignment with the Master Data Management (MDM) solution. The Business Data Steward Coordinator will report to the Manager, Master Data Manager and help manage DAS’s internal Sales data including Sales Team structure, Sales Team-to-Account alignment and Account mapping.
• Understand Data Flows/Processes across internal systems.
• Assist with system-to-system field mapping for future migrations & integrations as well as manage system data on Sales teams and Sales Team-to Account Assignments.
• Assist with data cleansing activities, including creation, mapping, updates, and de-duplication.
• Identify and utilize public data sources to enrich our existing advertiser/agency customer data.
• Assist in monitoring and profiling existing data sets to ensure business rule adherence, system feature adoption and suggest methods for improvements or additional training needed.
• Work with Sales, Account Management, and Accounting to process order and proposal transfers.
• Record, troubleshoot, and resolve various support requests originating from SalesHub and integration with other sales systems directly from end users in a timely manner. Escalate issues to technology and Credit teams were deemed appropriate.
• Pursue enhanced efficiencies within Sales processes and in providing support.
• Escalate issues to manager related system enhancements and support requests and share with Sales and IT.
Basic Qualifications:
• Proficient understanding of relational data and relational database concepts. Excel Proficiency a must - creating spreadsheets, formulas, macros, etc.
• Minimum 1 years of Data Analysis experience
• Ability to articulate and communicate complex data to a variety of audiences including business leaders, project teams, IT and management.
• Prior experience with Salesforce.com or similar CRM system preferred
• Willingness to learn and collaborate on solutions.
• Meticulous attention to detail
• Outside-the-box thinker when it comes to creating/improving processes, systems, tools, etc. Excellent communication, interpersonal, motivational, and presentation skills
Preferred Qualifications:
• Minimum 2 years exp is preferred.
• Familiarity with the Media and/or Advertising industries
• Experience using Data Visualization tools such as Tableau
• Strong operational mindset with a passion for quality control and efficiency.
• Ability to work independently and meet deadlines with minimal supervision.
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.
US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
