Data Analyst, Digital Media Sales

This is a fully remote position, open to applicants in New York.

📋 Description

• Design, maintain, troubleshoot, and implement both automated and ad-hoc solutions to meet reporting and analytical requirements.

• Collaborate across departments to support the Inventory Team, Account Managers, Sales, Finance, and other key stakeholders.

• Create and manage intricate Excel spreadsheets utilizing advanced formulas and functions.

• Sustain and improve the Python codebase for reporting, automation, and data workflows.

• Oversee and manage Business Intelligence tools, such as Tableau.

• Identify and resolve reporting errors and data inconsistencies in the client-facing DOMO Dashboard.

• Automate customized reports for stakeholders using Python.

• Generate additional reports and analyses on an as-needed basis.

• Create and maintain documentation and Standard Operating Procedures (SOPs) to ensure consistent data processes, facilitate knowledge sharing, and support operational continuity.

⛳️ Requirements

• Bachelor's degree or equivalent experience is required.

• A minimum of 2 years of experience in data analytics, business intelligence, data operations, or a similar analytical role.

• Advanced proficiency in Excel, including INDEX/MATCH, XLOOKUP, pivot tables, complex nested formulas, and data reconciliation techniques.

• Proficient in Python, with substantial experience using pandas for data cleaning, manipulation, transformation, and analysis.

• Extensive knowledge of Tableau, including Level of Detail (LOD) expressions, calculated fields, and parameters.

• Experience with DOMO, including Magic ETL, Beast Mode, Dataflows, Views, and calculated fields.

• Familiarity with Git and GitHub for version control and collaborative development processes.

• Experience working within Jira or a similar project management/ticketing platform.

• Availability to provide regular support during Eastern Time business hours.

• Must possess unrestricted work authorization to be employed in the United States.

• Candidates must be at least 18 years old.

• Experience with digital advertising platforms such as FreeWheel, Google Ad Manager, Operative, or equivalent systems.

• Familiarity with digital advertising concepts and terminology, including impressions, video completion rates, CPMs, pacing, inventory, and audience targeting.

• Experience in developing or maintaining automated data pipelines and scheduled reporting processes.

• Strong skills in troubleshooting, investigation, and root-cause analysis.

• Understanding of relational data concepts.

• A demonstrated curiosity and willingness to continuously learn new tools and technologies.

• Ability to prioritize tasks and work independently.

🏝️ Benefits

• Medical, dental, and vision insurance.

• 401(k) plan.

• Paid leave.

• Tuition reimbursement.

• Discounts and perks.

• Fully remote work arrangement.