Data Management Analyst

Icon Media Direct is seeking a talented Data Management Analyst to join our innovative team. As a Data Management Analyst, you will be responsible for managing the movement of data into and out of the organization’s systems, ensuring the integrity, security, and usability of our data assets to drive effective marketing campaigns and strategic decision-making. 

Reporting to the Sr. Director of Business Operations, this position will serve as a technical resource and work closely with cross-functional teams to optimize data processes, maintain data quality standards, implement governance policies, support users to troubleshoot issues, and maintain documentation, which all supports the organization’s data-driven initiatives and business objectives.

This position requires strong analytical and problem-solving skills to identify, isolate, and correct data errors, ensuring pristine data quality used in our internal systems. 

The right candidate will be detail-oriented, resourceful, and effectively multi-task under tight deadlines in a fast-paced environment. This position will manage and analyze data from various sources, therefore an above average understanding and competence of MSSQL, relational databases, Excel, and programming languages (Python) are essential. 

About Icon Media Direct:

Icon Media Direct is a leading brand response media agency obsessed with maximizing ROI for our clients. We are a group of experts in media, technology, relationships and analytics working together to consistently exceed our clients’ expectations. With over 19 years of experience, we pride ourselves in the deep relationships we have built with our clients, partners and employees. Headquartered in Sherman Oaks, CA, Icon Media Direct strives to be an employer of choice, offering competitive benefits and compensation, true work/life balance, and a fun, energetic company culture. We are an organization, truly focused on the growth of our team. With in-depth leadership training, strengths-based coaching and mentorship programs, we foster a culture of continual development and positive collaboration.

Essential Duties and Responsibilities:

  • Interacts with users to obtain data requirements for new and existing applications.
  • Receives, inspects, validates, cleanses, transforms, and loads data received in a variety of formats (e.g., Excel, CSV, Proposal XML, text) from disparate sources (e.g., clients, telemarketers, data vendors, analytic platforms, etc.).
  • Works with vendors and clients to correct problems with data and/or files.
  • Manages data, including collecting, organizing, and accessing data to support productivity, efficiency, and decision-making.
  • Manages information, including working with the team to manage the infrastructure used to collect, manage, preserve, store, and deliver information used for the organization.
  • Establish and enforce data governance frameworks to govern data usage, access, and compliance. 
  • Maintains client confidence and protects operations by keeping data & information confidential according to the various data privacy guidelines.
  • Establish and enforce data quality standards to uphold the accuracy, consistency, and completeness of information.
  • Perform data validation and cleansing procedures to identify and rectify discrepancies.
  • Identifies erroneous or anomalous data and corrects or removes errors to restore datasets to reliable levels.
  • Proactively addresses issues, questions, and problems in an accurate and timely manner.
  • Troubleshoots issues and tracks progress and resolutions logged in the Help Desk software, while providing excellent customer service and timely communication throughout the resolution process.
  • Develops and recommends process improvements for data management tasks.


  • Bachelor’s degree in computer science, Information Systems, Management Information Systems, or related field
  • Minimum three years of experience with Data Integration and Migration, Data Governance and Compliance, Reporting and Analysis Continuous Improvement
  • Proven experience in data management, information management, or related roles, preferably in the marketing or advertising industry.
  • High proficiency in Microsoft Office 365 applications (Excel, Word, PowerPoint, Teams) with knowledge of advanced Excel formulas, functions, and the creation and manipulation of pivot tables. 
  • High proficiency in Atlassian products (Jira, Work management & Confluence)
  • Proficiency in SQL & data management systems (e.g., SQL Server, MySQL, Snowflake, AWS (Amazon Web Services), Adverity, etc.).
  • Familiarity with data visualization tools (e.g., Tableau, Looker) and statistical analysis software (e.g., R, Python).
  • Strong understanding of data governance principles
  • Excellent analytical and problem-solving skills with meticulous attention to detail.
  • Effective verbal and written communication and collaboration abilities to work with diverse stakeholders.
  • Demonstrates ability to logically outline and document technical procedures and processes
  • Ability to multi-task, prioritize, and organize while meeting deadlines in a fast-paced environment
  • Certifications such as Certified Data Management Professional (CDMP) or related credentials are a plus.

Other Considerations:

  • Salary based on skills and experience
  • Skills will be tested upon interview
  • All applicants are subject to background checks and offers of employment will be pending the verification of information listed on application
  • All applicants will need to provide a list of professional references

Icon Media Direct is an Equal Opportunity Employer


Salary range: $60-70k